Databases Reference
In-Depth Information
F
ID2
: Lock identifier #2 (depends on
TYPE
)
F
LMODE
: A lock mode in which the session holds the lock; values can be:
NONE
NULL
(NULL)
ROW-S
(SS)
ROW-X
SHARE
(S)
S/ROW-X
(SSX)
EXCLUSIVE
(X)
F
REQUEST
: A lock mode in which the process request locks; values are the same
as for
LMODE
fields
F
CTIME
: The time since the current mode was grant
F
BLOCK
: Whether this lock is blocking another lock
See also
F
The
V$LOCK
,
V$LOCKED_OBJECT
,
DBA_WAITERS
, and
DBA_BLOCKERS
sections in this appendix
V$FILESTAT
This view displays statistics about I/O operations on files.
Fields
The most relevant view fields are as follows:
F
FILE#
: The file identification number
F
PHYRDS
: The number of physical reads done
F
PHYWRTS
: The number of physical writes done
F
READTIM
: The time spent doing reads (in hundredths of a second)
F
WRITETIM
: The time spent doing writes (in hundredths of a second)
See also
F
The
V$DATAFILE
section in this appendix