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***