If we want to check the objects that a particular session id(SID) is accessing in oracle we can use the below SQL.
SELECT a.object,
a.owner,
a.type,
a.sid,
s.username,
s.osuser,
s.program
FROM v$access a,
v$session s
WHERE a.sid = s.sid
AND a.sid = &sid_to_check
ORDER BY a.object
SELECT a.object,
a.owner,
a.type,
a.sid,
s.username,
s.osuser,
s.program
FROM v$access a,
v$session s
WHERE a.sid = s.sid
AND a.sid = &sid_to_check
ORDER BY a.object
Post a Comment
Post a Comment