- Run Statspack reports to see the top timed events in the instance.
- Trace a session to see what SQL it's executing and the breakdown, including wait events, of its elapsed time. Use DBMS_SUPPORT (install via $ORACLE_HOME/rdbms/admin/dbmssupp.sql and prvtsupp.plb) to collect extended trace data that includes wait event data.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.