Analyzing result I

• Find your query

  • At the start: SELECT ‘YOUR NAME’ from dual;

• Focus on statements

  • Consuming greatest resources overall
  • Consuming greatest resources per row
  • Most frequently executed

• Timing for embedded triggers will not be shown

• If CPU, elapsed time, and physical reads in the Parse row are high relative to Execute and Fetch, do dictionary cache tuning to get more data in RAM and reduce I/O

Notes: