Skip to content

Instantly share code, notes, and snippets.

@chris-martin

chris-martin/oracle-open-cursors.sql

Created May 9, 2013 22:21
Show Gist options
  • Save chris-martin/5551060 to your computer and use it in GitHub Desktop.
Save chris-martin/5551060 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oracle-open-cursors.sql
select count(*) as numtimes, sql.sql_text
from v$open_cursor c, v$sql sql
where c.sql_id=sql.sql_id and c.user_name = 'username' group by sql.sql_text;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment