V$ACCESS: View Oracle Locked Objects & Session Accessing



Share this article :

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.

Tags:

Related posts

Difference: Oracle Session & Oracle Connection
Oracle SGA Memory Data Structure
ORA-16014: log sequence# not archived, no available destinations
Check if any Oracle Data Files Needed for Recovery
© 2017 ITsiti. All Rights Reserved
Powered by KEEM