Oracle Database Performance Tuning

How To Double, Triple Or Even Quadruple The Performance Of Your Oracle Database

If the performance of your Oracle database is letting you down, we can give you all the help you need to improve it.

A few simple steps and perseverance are all it takes to transform your database from a slow coach to an express train.

What's the one thing that would produce the biggest improvement in performance of your Oracle database ?

The biggest gain in performance for the least amount of cost is always going to be to tune your SQL, no matter how big or small or sophisticated or simple your system is. Poorly tuned queries will perform vast amounts of input/output as they read data from the disk and write to it during sort operations. As disk i/o is one of the slower activities and one of the most processor intensive activities, if you reduce disk i/o, the processor will spend less time just juggling resources, your applications will spend less time waiting for resources and everything will run much faster.

Here are a few tips on tuning your SQL:

1. De-normalise frequently joined tables. Normalisation is an analysis technique, not a design technique.

2. Make sure indexes are being used where appropriate. Functions on an indexed column (except for Oracle8i and above function-based indexes) will prevent the use of an index.
eg. select <my_data> from <my_table> where max(indexed_col) = <some_val>
will require a full table scan of the table being queried.

3. If you have an OLTP system, beware of having too many indexes. Whenever records are inserted or deleted the corresponding index entries have to be created or removed, generating twice as much work for the database.

We hope you found these tips useful, but if you lack either the time or the expertise to tune your databases why not let us do it for you? Click here for details of our guaranteed Oracle performance tuning service.

For more Oracle performance tuning tips and other help with Oracle databases, see our Oracle tips and tricks section

---------------------------------------

Looking for more Oracle tips and tricks ? If you're looking for no frills, no fluff, just solid, reliable technical information, take a short cut now and subscribe to our ezine. Published monthly, it's jam-packed full of tips and tricks to help you make more of your Oracle systems and save you hours of blood, sweat and tears searching for information. Subscribe today and your first issue will soon be winging its way to your mailbox.

Smartsoft Computing Ltd
Bristol, England
Tel: 0845 0031320

Contact Us

Click here to view our privacy policy .

This site uses woopra.com to gather statistical information about our visitors. View woopra privacy policy .

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. UNIX is a registered trademark of The Open Group in the United States and other countries.