如何查看oracle打开的游标
2020-11-09
来源：爱够旅游网
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; |
显示全文