关于oracle提示超出游标问题解决 |
您所在的位置:网站首页 › 超出最大游标数 › 关于oracle提示超出游标问题解决 |
1.先可查看博客 https://www.cnblogs.com/huanghongbo/p/5569034.html 2.解决思路: 首先查看当前数据库允许的最大游标数 SELECT MAX(a.value) AS highest_open_cur, p.value AS max_open_cur FROM v$sesstat a, v$statname b, v$parameter p WHERE a.statistic# = b.statistic# AND b.name = 'opened cursors current' AND p.name = 'open_cursors' GROUP BY p.value;查看当前session占用游标情况 SELECT a.value, s.username, s.sid, s.serial# FROM v$sesstat a, v$statname b, v$session s WHERE a.statistic# = b.statistic# AND s.sid = a.sid AND b.name = 'opened cursors current' ORDER BY 1 DESC;之后对kill掉对应回话 alter system kill session '1023,9451' immediate; 注意:不加immediate有时候杀不掉。
|
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |