Dynamic Performance (V$) Views, 2 of 237

Oracle9i Database Reference
Release 2 (9.2)
Part Number A96536-01

Go To Documentation Library

Go To Product List

Go To Table Of Contents

Go To Index

Dynamic Performance (V$) Views, 2 of 237

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

Go to previous page

Go to beginning of chapter

Go to next page

Oracle

Copyright © 1996, 2002 Oracle Corporation.
All Rights Reserved.

Go To Documentation Library

Go To Product List

Go To Table Of Contents

Go To Index