1. 查看当前用户占游标数量 for:"Max Open Cursors Exceeded"
[color=red]UPDATER[/color]
[color=blue]ownername[/color]
2. DB中最近执行的SQL
3. ...
--select count(*) from v$open_cursor;
select o.sid, osuser, machine, count(*) num_curs
from v$open_cursor o, v$session s
where user_name = 'UPDATER'
and o.sid = s.sid
and s.OSUSER='ownername'
group by o.sid, osuser, machine
order by num_curs desc;
[color=red]UPDATER[/color]
[color=blue]ownername[/color]
2. DB中最近执行的SQL
select sql_text,last_load_time from v$sql t order by last_load_time desc
3. ...