Find frequently reparsed statements

select sql_text, parse_calls, executions
  from v$sqlarea
  order by parse_calls;

Statements with large number of buffer gets

select address, hash_value, buffer_gets, executions,
  buffer_gets/executions "gets/exec", sql_text
  from v$sqlarea
  where buffer_gets > 50000
    and executions > 0
  order by 3;