Databases Reference
In-Depth Information
See also
F
The
V$MYSTAT
,
V$SESSTAT
, and
V$STATNAME
sections in this appendix
V$SYSTEM_EVENT
This view displays information on total waits for an event.
Fields
The most relevant view fields are as follows:
F
EVENT
: The name of the wait event
F
EVENT_ID
: The identifier of the wait event
F
TOTAL_WAITS
: The total number of waits for the event
F
TIME_WAITED
: The total amount of time waited in hundredths of a second
for the event
F
AVERAGE_WAIT
: The average amount of time waited in hundredths of a second
for the event
F
TOTAL_TIMEOUTS
: The total number of timeouts for the event
V$TEMPFILE
This view displays temporary file information.
Fields
The most relevant view fields are as follows:
F
FILE#
: The file identifier number
F
NAME
: The filename
F
STATUS
: The file status; it can be
ONLINE
or
OFFLINE
F
ENABLED
: This is enabled for read and/or write
F
BYTES
: The size of the file in bytes
F
BLOCKS
: The size of the file in blocks
F
BLOCK_SIZE
: The block size for the file