Databases Reference
In-Depth Information
V$LOCKED_OBJECT
This view shows which sessions are holding DML locks and on what objects.
Fields
The most relevant view fields are:
F
XIDUSN
: The undo segment number
F
XIDSLOT
: The slot number
F
XIDSQN
: The sequence number
F
OBJECT_ID
: The object ID being locked
F
SESSION_ID
: The session identifier number
F
ORACLE_USERNAME
: The Oracle username
F
OS_USER
: The operating system user
F
PROCESS
: The operating system process identifier
F
LOCKED_MODE
: The lock mode
See also
F
The
DBA_BLOCKERS
,
DBA_WAITERS
,
V$ENQUEUE_LOCK
, and
V$LOCK
sections
in this appendix
V$LOG
This view displays information on log files from the control file.
Fields
The most relevant view fields are:
F
GROUP#
: The log group number
F
THREAD#
: The log thread number
F
SEQUENCE#
: The log sequence number
F
BYTES
: The size of the log in bytes
F
BLOCKSIZE
: The block size of the log file