Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance!

Re: Performance!

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 17 Jun 1999 15:41:41 -0700
Message-ID: <376979A5.1E34287@exesolutions.com>


> 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 Received on Thu Jun 17 1999 - 17:41:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US