select * from v$sesstat order by STATISTIC# desc;查找游标
select SQL_TEXT, COUNT(*) from v$open_cursor group by SQL_TEXT order by COUNT(*);
select SID, COUNT(*) from v$open_cursor group by SID order by COUNT(*);
select COUNT(*) from v$open_cursor;