Thursday, February 7, 2019

Find Open Cursor per session

SELECT COUNT(hash_value) cursors ,
  sid ,
  user_name
FROM v$open_cursor
GROUP BY sid ,
  user_name
ORDER BY cursors
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)