2009년 7월 23일 목요일

V$SYSTEM_WAIT_CLASS

V$SYSTEM_WAIT_CLASS

V$SYSTEM_WAIT_CLASS displays the instance-wide time totals for each registered wait class.

Column

Datatype

Description

WAIT_CLASS_ID

NUMBER

Identifier of the wait class

WAIT_CLASS#

NUMBER

Number of the wait class

WAIT_CLASS

VARCHAR2(64)

Name of the wait class

TOTAL_WAITS

NUMBER

Number of times waits of the class occurred

TIME_WAITED

NUMBER

Amount of time spent in the wait by all sessions in the instance

 

댓글 없음:

댓글 쓰기