时间：2021-07-01 10:21:17 帮助过：11人阅读
oracle查看当前打开的游标数目和连接数： select count(*) from v$open_cursor; select count(*) from v$session; 查看当前打开的游标数 select * from v$sysstat where name = 'opened_cursors_current' 查看哪些会话打开了游标 select sid,count(*) from v
oracle查看当前打开的游标数目和连接数：
select count(*) from v$open_cursor;
select count(*) from v$session;
查看当前打开的游标数
select * from v$sysstat where name = 'opened_cursors_current'
查看哪些会话打开了游标
| select sid,count(*) from v$open_cursor group by sid having count(*)>1000; |