Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 55 of 211


V$DLM_RESS

V$DLM_RESS is an Oracle9i Real Application Clusters view. It displays information of all resources currently known to the lock manager.

Column  Datatype   Description 

RESP 

RAW(4) 

Resource pointer 

RESOURCE_NAME 

VARCHAR2(30) 

Resource name in hexadecimal for the lock 

ON_CONVERT_Q 

NUMBER 

1 if on convert queue, 0 otherwise 

ON_GRANT_Q 

NUMBER 

1 if on granted queue, 0 otherwise 

PERSISTENT_RES 

NUMBER 

1 if it is a persistent resource, 0 otherwise 

RDOMAIN_NAME 

VARCHAR2(25) 

Recovery domain name 

RDOMAINP 

RAW(4) 

Recovery domain pointer 

MASTER_NODE 

NUMBER 

Master node ID 

NEXT_CVT_LEVEL 

VARCHAR2(9) 

Next lock level to convert on global convert queue 

VALUE_BLK_STATE 

VARCHAR2(32) 

State of the value block 

VALUE_BLK 

VARCHAR2(64) 

First 64 bytes of the value block 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback