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: sqlplus /nolog & /as sysdba
List / Find Users in Oracle
Oracle SQL Statement Types
Grant & Revoke User Privileges in Oracle
© 2018 ITsiti. All Rights Reserved
Powered by KEEM