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