• Narrow your visible statistics:

  • Search for SQL - enter text of the SQL you want to limit the shared pool area to SQL starting with the letters you enter.

  • Hide Zero Stats - when checked any stats with a value of 0 are hidden in the execution stats area.

  • Select an Instance - if you are on a RAC system, you can limit the display to a particular RAC instance.

  • To make statistics easier to find, hide any stats with a value of 0.