V$ACCESS: View Oracle Locked Objects & Session Accessing

V$ACCESS displays objects in the database that are currently locked and the sessions that are accessing them.

• SID – Session number that is accessing an object
• OWNER – Owner of the object
• OBJECT – Name of the object
• TYPE – Type identifier for the object

SID  OWNER  OBJECT       TYPE
---  -----  ------       ----
34   SYS    J2EE_CONFIG  TABLE

1 rows selected.