Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

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

Static Data Dictionary Views, 260 of 452


DBA_WAITERS

DBA_WAITERS shows all the sessions that are waiting for a lock, but do not hold locks for which another session is waiting.

Column  Datatype  NULL  Description 

WAITING_SESSION 

NUMBER 

 

The waiting session 

HOLDING_SESSION 

NUMBER 

 

The holding session 

LOCK_TYPE 

VARCHAR2(26) 

 

The lock type 

MODE_HELD 

VARCHAR2(40) 

 

The mode held 

MODE_REQUESTED 

VARCHAR2(40) 

 

The mode requested 

LOCK_ID1 

VARCHAR2(40) 

 

Lock ID 1 

LOCK_ID2 

VARCHAR2(40) 

 

Lock ID 2 


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

All Rights Reserved.

Library

Product

Contents

Index