DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.V$CACHE_LOCK

Object Details
Object Name: V$CACHE_LOCK
Object Type: VIEW
Owner: SYS
Subobject Name: $DEPRECATED$
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE# NUMBER

BLOCK# NUMBER

STATUS VARCHAR2 (10)
XNC NUMBER

FORCED_READS NUMBER

FORCED_WRITES NUMBER

NAME VARCHAR2 (30)
KIND VARCHAR2 (15)
OWNER# NUMBER

LOCK_ELEMENT_ADDR RAW (4)
LOCK_ELEMENT_NAME NUMBER

INDX NUMBER

CLASS NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FILE#
,      BLOCK#
,      STATUS
,      XNC
,      FORCED_READS
,      FORCED_WRITES
,      NAME
,      KIND
,      OWNER#
,      LOCK_ELEMENT_ADDR
,      LOCK_ELEMENT_NAME
,      INDX
,      CLASS
FROM SYS.V$CACHE_LOCK;

Dependencies

[top of page]

SYS.V$CACHE_LOCK does not reference any database object

SYS.V$CACHE_LOCK is not referenced by any database object