doc Original: usercurs.sql | Author: Mark Gurry | Type: Tuning | Cible: Curseurs | Desc: L'utilisation des curseurs. | Le nombre des curseurs ouverts doit etre inferieur a OPEN_CURSORS specifié dans INIT.ORA. # create view radu_user_cursors as select ss.username||'('||se.sid||') ' user_process, sum(decode(name,'recursive calls',value)) "Recursive Calls", sum(decode(name,'opened cursors cumulative',value)) "Opened Cursors", sum(decode(name,'opened cursors current',value)) "Current Cursors" from v$session ss, v$sesstat se, v$statname sn where se.statistic# = sn.statistic# and ( name like '%opened cursors current%' or name like '%recursive calls%' or name like '%opened cursors cumulative%') and se.sid = ss.sid and ss.username is not null group by ss.username||'('||se.sid||') '; ttitle 'Utilisation des curseurs / Session ' column USER_PROCESS format a25; column "Recursive Calls" format 999,999,999; column "Opened Cursors" format 99,999; column "Current Cursors" format 99,999; select * from radu_user_cursors order by "Recursive Calls" desc; drop view radu_user_cursors; ttitle off