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

Dynamic Performance (V$) Views, 83 of 179

V$LOCKED_OBJECT

This view lists all locks acquired by every transaction on the system.

Column  Datatype  Description 

XIDUSN 

NUMBER 

Undo segment number 

XIDSLOT 

NUMBER 

Slot number 

XIDSQN 

NUMBER 

Sequence number 

OBJECT_ID 

NUMBER 

Object ID being locked 

SESSION_ID 

NUMBER 

Session ID 

ORACLE_USERNAME 

VARCHAR2(30) 

Oracle user name 

OS_USER_NAME 

VARCHAR2(15) 

OS user name 

PROCESS 

VARCHAR2(9) 

OS process ID 

LOCKED_MODE 

NUMBER 

Lock mode 

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