Monday, October 6, 2008

Number of Open Cursors per user/SID

This sql reports the number of open cursors per user/SID.

COLUMN user_name heading Username
COLUMN num heading "Open Cursors"
SET lines 80 pages 59
SELECT user_name, sid,COUNT (*) num
FROM v$open_cursor
GROUP BY user_name,sid;

No comments:

search engine

Custom Search