Skip to content

Instantly share code, notes, and snippets.

@niisar
Created May 4, 2014 16:12
Show Gist options
  • Save niisar/a95bd52a895ab35feca2 to your computer and use it in GitHub Desktop.
Save niisar/a95bd52a895ab35feca2 to your computer and use it in GitHub Desktop.
lists all objects being accessed in the schema
SET LINESIZE 255
SET VERIFY OFF
COLUMN object FORMAT A30
SELECT a.object,
a.type,
a.sid,
b.serial#,
b.username,
b.osuser,
b.program
FROM v$access a,
v$session b
WHERE a.sid = b.sid
AND a.owner = DECODE(UPPER('&1'), 'ALL', a.object, UPPER('&1'))
AND a.object = DECODE(UPPER('&2'), 'ALL', a.object, UPPER('&2'))
ORDER BY a.object;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment