Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
V$ACCESS
displays objects in the database that are currently locked and the sessions that are accessing them.
Column | Datatype | Description |
---|---|---|
SID |
NUMBER |
Session number that is accessing an object |
OWNER |
VARCHAR2(64) |
Owner of the object |
OBJECT |
VARCHAR2(1000) |
Name of the object |
TYPE |
VARCHAR2(24) |
Type identifier for the object |