What to Tune in Production

 < Day Day Up > 



There are five general stages in tuning an Oracle production database:

  • Resolve obvious bottlenecks.

  • Configuration is often inappropriate due to initial Oracle installation and database creation. Examine basic configuration.

  • Physical space can be wasted. Often a database can be better organized and become much smaller, even as much as one-tenth of current size, and sometimes more.

    Note 

     Oracle Database 10 Grid   Oracle Database is becoming more automated with respect to physical configuration.

  • Poorly written SQL code in both applications and in the database can only be counteracted partially by physical and configuration tuning. SQL code tuning can help performance immensely but should be performed in development and testing environments first.

  • Data model tuning may be required if SQL code tuning does not resolve production performance problems. As with SQL code tuning, data model tuning should be done in development and testing environments first.

The easiest approach to tuning in production is Oracle Database physical and configuration tuning. In general, tuning the data model is the most expensive because it will require changes to SQL code, application code, and the production database. If SQL code is not tunable then your data model may be too granular or not properly Normalized. Physical and configuration tuning on your database server itself will not require SQL code and data model tuning changes. However, the purely database-oriented tuning approach may eventually lead to expensive hardware upgrades. Hardware upgrades can often be the best tuning option. However, costs can sometimes be more when the hardware becomes so complex that highly skilled, expensive administrators are required. Hardware upgrades are often a short-term solution and their cost effectiveness can be good if the software life cycle is short or money is tight, assuming the hardware is reusable or sellable.



 < Day Day Up > 



Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net