Databases Reference
In-Depth Information
F
TIME_WAITED
: The total amount of time waited, in hundredths of a second
for the event in the session
F
AVERAGE_WAIT
: The average amount of time waited, in hundredths of a
second for the event in the session
F
MAX_WAIT
: The maximum time waited, in hundredths of a second for the
event in the session
F
EVENT_ID
: The wait event identifier
See also
F
The
V$SESSION
and
V$SESSTAT
sections in this appendix
V$SESSTAT
This view displays statistics on the sessions.
Fields
The most relevant view fields are as follows:
F
SID
: The session identifier
F
STATISTIC#
: The statistic number
F
VALUE
: The statistic value
See also
F
The
V$STATNAME
section in this appendix
V$SGA
This view displays summary information about the System Global Area (SGA).
Fields
The most relevant view fields are as follows:
F
NAME
: The SGA component group
F
VALUE
: The memory size of the SGA component group in bytes