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;

原文转自：http://www.ltesting.net