Dynamic Performance (V$) Views, 2 of 179

V$ACCESS

This view 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(12)

Type identifier for the object

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(12)`	Type identifier for the object