<Lesson Title>

Copyright Ó Oracle Corporation, 1999. All rights reserved.

4-8

Collecting Session-Related Statistics

V$STATNAME

• statistic#

• name

• class

V$SESSTAT

• sid

• statistic#

• value

V$SESSION_WAIT

• sid

• seq#

• event

• p1/2/3text

• wait_time

• seconds_in_wait

• state

V$SESSION

• sid

• serial#

• username

• osuser

V$SESSION_EVENT

• sid

• event

• total_waits

• total_timeouts

• time_waited

• average_wait

• max_wait

V$EVENT_NAME

• event#

• name

• parameter1

• parameter2

• parameter3