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

V$ARCHIVE_PROCESSES: Archive Process
Find Oracle Control File Location
Oracle 10g Installation Steps
How to Limit Oracle Query Result
© 2017 ITsiti. All Rights Reserved
Powered by KEEM