🚀 go-pugleaf

> I've been making tests with my Oracle and I think it's very slow! I'd like
> to know how do I proced to make Oracle Work faster. What are the steps I
> should take to get better perfomance on SELECTING, DELETING, or UPDATING
> tables? I think my server is not correctly configured. I use Oracle 8 in a
> Netware Server.
>
> Do I have to configure clusters? What else should I do?

You have provided a wholly inadequate amount of information from which to give
you any advice. Please provide the following:

Size of instance in megabytes/gigabytes
Number of rows in table(s) being queried
Number of simultaneous users
Hardware specifications (CPU, operating system, network, RAID, etc.)

This is just for starters. Then anyone trying to help you would need to know
where your code is executing. In the front-end (what tools), in a middle-tier
(Corba?) in the back-end (packages, procedures, triggers). I would also want
to know if your queries' WHERE clauses have indices that correspond and if the
structure of those WHERE clauses are using the indices.

And eventually we could ask whether you are identifying rows by rowid? using
concatenated indices, using views based on higher level views, what optimizer
mode you are using, how large the SGA is, what block size you are using, how
large your extents are, and at least a few hundred additional parameters.

I have taken a query that took seven hours and gotten it to execute in five
minutes just by creating the proper index. And had the developer let me
implement a trigger I could have gotten it down to milliseconds.

There are a lot of variables at work here. But the chances of clusters solving
the problem is negligible.

Daniel A. Morgan
Senior Oracle DBA