oracle查看非空闲等待时间

--设置列长度

COL FILE_NAME FOR A50;

--设置行和页

SET LINESIZE 200 PAGESIZE 200;

--event,count(*)事件总数，wait_class#<>6空闲连接

select event,count(*) from v$session where wait_class#<>6 group by event order by 2;

--查询sql_id,count(*)总数

select sql_id,count(*) from v$session where event='direct path read' group by sql_id;

--查询sql语句

select * from table(dbms_xplan.display_cursor('1ws8xjh2kmy86',null));