oracle性能调校

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;