oracle v$system_event,45.Oracle杂记——Oracle常用动态视图v$system_event

45.Oracle杂记——Oracle常用动态视图v$system_event

视图v$system_event 显示一个事件的总共等待。

如果不支持计时机制，那么TIME_WAITED和AVERAGE_WAIT列就显示0.

视图v$system_event描述：

sys@PDB1> desc v$system_event

Name                                                                  Null?    Type

------------------------------------------------------------- ------------------------------------

EVENT                                                                               VARCHAR2(64)

TOTAL_WAITS                                                                         NUMBER

TOTAL_TIMEOUTS                                                               NUMBER

TIME_WAITED                                                                        NUMBER

AVERAGE_WAIT                                                                     NUMBER

TIME_WAITED_MICRO                                                       NUMBER

TOTAL_WAITS_FG                                                               NUMBER

TOTAL_TIMEOUTS_FG                                                        NUMBER

TIME_WAITED_FG                                                               NUMBER

AVERAGE_WAIT_FG                                                             NUMBER

TIME_WAITED_MICRO_FG                                                          NUMBER

EVENT_ID                                                                        NUMBER

WAIT_CLASS_ID                                                                     NUMBER

WAIT_CLASS#                                                                          NUMBER

WAIT_CLASS                                                                  VARCHAR2(64)

CON_ID                                                                           NUMBER

每个列含义描述如下：

EVENT：等待事件名字

TOTAL_WAITS：事件的总等待次数

TOTAL_TIMEOUTS：事件的总超时次数

TIME_WAITED：事件总等待的时间

AVERAGE_WAIT：事件的平均等待时间

TIME_WAITED_MICRO：时间总等待时间(MS)

TOTAL_WAITS_FG：前台会话对该事件的等待次数

TOTAL_TIMEOUTS_FG：前台会话对该时间的超时次数

TIME_WAITED_FG：前台会话，总的等待时间

AVERAGE_WAIT_FG：前台会话平均等待时间

TIME_WAITED_MICRO_FG：前台会话总的等待时间(MS)

EVENT_ID：事件ID

WAIT_CLASS_ID：等待类ID

WAIT_CLASS#：等待事件类的号

WAIT_CLASS：等待事件类名字

CON_ID ：容器ID