Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Monitoring Performance During Testing

• Oracle SQL trace
   

• Statspack
   

• Oracle Enterprise Manager with Tuning Pack option
   

• V$ performance tables

• Index utilization monitoring via ALTER INDEX MONITORING statement
   

• Third party performance monitoring tools
   

• LAN performance monitoring tools
   

• Operating system performance monitoring tools

Performance Design Reviews

Information collected from the various performance monitoring tools is discussed at this time. One meeting may be sufficient, but large application development efforts usually require several discussions.  If the DBA has maintained good communications throughout the initial stages of application design, there should be few surprises when these meetings are held. SQL tuning and tweaking recommendations are covered in this meeting. Depending on the length of the development process, follow-up meetings can be held to ensure that the application is performing as expected.  Some suggested topics include:

• Load testing assessment.  Is the load being placed on the test system large enough to accurately predict production performance?
   

• Review performance statistics collected during the testing process
   

• Assess SQL coding techniques by reviewing explain plan output for performance critical transactions

  • Index usage
     

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA