This is a helpful article to show how to solve further hidden bottlenexk through a typical performance tunning case.

In this article, the author conducts his experiment by following the steps below.

• Using TKPROF to produce trace report
• by examing TKPROF trace file report, find more efficient PL/SQL Procedure
• besides above, make check on index
  [url=http://www.oraclepoint.com]dFiZRwmCiOraclePointUG8YS1yba[/url]
  
  
• Comparing tracing report to Toad representative list of wait events, find log file bottleneck
• Do further investigation on OEM and find OEM recommend increasing redo log file.

Please find attachment for complete article.

Nice written .