col sql_text for a60
col sql_id for a20
set lin 300
set pagesize 300
col executions for 99999999999999                         
select sql_id,executions,sysdate,sql_text
  from (select sql_text,
               sql_id,
               executions,
               rank() over(order 
               by executions desc) exec_rank
          from v$sql) where exec_rank <= 10;   

版权声明：本文为博主原创文章，未经博主允许不得转载。