Tuning individual Oracle SQL statements The acronym SQL stands for Structured Query Language. SQL is an industry standard database query language that was adopted in the mid-1980s. It should not be confused with commercial products such as Microsoft SQL Server or open source products such as MySQL, both of which use the acronym as part of the title of their products. Do this before you start individual... 

Why and when should one tune? One of the biggest responsibilities of a DBA is to ensure that the Oracle database is tuned properly. The Oracle RDBMS is highly tunable and allows the database to be monitored and adjusted to increase its performance. One should do performance tuning for the following reasons: The speed of computing might be wasting valuable human time (users waiting for response);... 

Do not index every column in the table – have only those indexes, which are required. Distribute your data to parrallelise the IO operations among multiple disks especially for those tables which have lots of IO’s. Try to avoid large data retrievals, since if the data being retrieved from a table is more than 10%-20% of the total data, Oracle will most likely do the FST. Never do a calculation... 

Here are some useful online resources for oracle tuning: Oracle 10g Wiki http://wiki.oracle.com/page/Performance+Tuning Oracle Database Documentation Library (10g) http://www.mcs.csueastbay.edu/support/oracle/doc/10.2/nav/portal_booklist.htm Oracle9i Database Documentation Library (9.2) http://www.oracle.com/pls/db92/db92.docindex?remark=homepage Oracle tuning tips and tricks http://www.smart-soft.co.uk/Oracle/oracle-tips-and-tricks.htm  Read More →