orcale 查询执行sql的效率的sql

     select   *
    from   v$sqlarea v
   where       executions > 0
           and buffer_gets > 0
           and (buffer_gets - disk_reads) / buffer_gets < 0.8
order by   v.user_io_wait_time desc


select executions,
       disk_reads,
       buffer_gets,
       round((buffer_gets - disk_reads) / buffer_gets, 2) hit_radio,
       round(disk_reads / executions, 2) reads_per_run,
       sql_text
  from v$sqlarea v
where  v.parsing_schema_name = 'juqi'
and executions > 0
   and buffer_gets > 0
   and (buffer_gets - disk_reads) / buffer_gets < 0.8
order by 4 desc