NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Query for Checking the Object Accessed by a particular SID

No comments
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

No comments :

Post a Comment