V$SYSTEM_EVENT
V$SYSTEM_EVENT显示有关事件总等待的信息。 请注意,在不支持快速计时机制的平台上,TIME_WAITED和AVERAGE_WAIT列将包含零值。如果您正在其中一个平台上运行,并希望此列反映真实的等待时间,则必须将TIMED_STATISTICS参数设置为TRUE;这样做会对系统性能产生很小的负面影响。
Column | Datatype | Description |
EVENT | VARCHAR2(64) | Name of the wait event |
TOTAL_WAITS | NUMBER | Total number of waits for the event |
TOTAL_TIMEOUTS | NUMBER | Total number of timeouts for the event |
TIME_WAITED | NUMBER | Total amount of time waited for the event (in hundredths of a second) |
AVERAGE_WAIT | NUMBER | Average amount of time waited for the event (in hundredths of a second) |
TIME_WAITED_MICRO | NUMBER | Total amount of time waited for the event (in microseconds) |
TOTAL_WAITS_FG | NUMBER | Total number of waits for the event, from foreground sessions |
TOTAL_TIMEOUTS_FG | NUMBER | Total number of timeouts for the event, from foreground sessions |
TIME_WAITED_FG | NUMBER | Amount of time waited for the event (in hundredths of a second), from foreground sessions |
AVERAGE_WAIT_FG | NUMBER | Average amount of time waited for the event (in hundredths of a second), from foreground sessions |
TIME_WAITED_MICRO_FG | NUMBER | Amount of time waited for the event (in microseconds), from foreground sessions |
EVENT_ID | NUMBER | Identifier of the wait event |
WAIT_CLASS_ID | NUMBER | Identifier of the class of the wait event |
WAIT_CLASS# | NUMBER | Number of the class of the wait event |
WAIT_CLASS | VARCHAR2(64) | Name of the class of the wait event |
CON_ID | NUMBER | The ID of the container to which the data pertains. Possible values include: |
列的解释
TOTAL_WAITS:等待的总次数
TOTAL_TIMEOUTS:等待超时的总次数
TIME_WAITED:等待事件的总时间(百分之一秒)
AVERAGE_WAIT:等待事件的平均时间(百分之一秒)
TIME_WAITED_MICRO:等待事件总时间(以微秒为单位)
TOTAL_WAITS_FG:前台会话的等待事件的总数
TOTAL_TIMEOUTS_FG:前台会话的超时等待的总数
TIME_WAITED_FG:前台会话等待的总时间(百分之一秒)
AVERAGE_WAIT_FG:前台会话等待的平均时间(百分之一秒)
TIME_WAITED_MICRO_FG:等待事件总时间(以微秒为单位)