Oracle Session (SID) Details on a database object:
=====================================
SELECT sid, serial#, vs.*
FROM v$session vs
WHERE vs.sid IN (SELECT SID
FROM v$access
WHERE object = <object_name>)
=====================================
SELECT sid, serial#, vs.*
FROM v$session vs
WHERE vs.sid IN (SELECT SID
FROM v$access
WHERE object = <object_name>)
***Please leave a comment***
No comments:
Post a Comment
Please provide your valuable feedback which helps us to improve the content.