Wednesday, April 09, 2008

Show open cursors per user/process in Oracle

SELECT SUBSTR (ses.username || ' ' || ses.osuser, 1, 30) user_osuser,
stat.VALUE open_cursor, ses.process process
FROM v$sesstat stat, v$session ses
WHERE stat.statistic# = 3 AND stat.SID = ses.SID;

No comments: