学习Oracle动态性能表-v$system_event

转载:http://hi.baidu.com/ldm_myself/blog/item/b5b68f4c0194cdffd72afc94.html 1. v$system_event 显示自从实例启动后所有Oracle会话遇到的所有等待事件的总计统计。它追踪等待的总次数、总超时，以及对任意会话遭遇到的任一等待事件的等待事件。 SQL> desc v$system_event; 名称                                                                                      是否为空? 类型 ----------------------------------------------------------------------------------------- -------- EVENT                                                                                              VARCHAR2(64) TOTAL_WAITS                                                                                        NUMBER TOTAL_TIMEOUTS                                                                                     NUMBER TIME_WAITED                                                                                        NUMBER AVERAGE_WAIT                                                                                       NUMBER TIME_WAITED_MICRO                                                                                  NUMBER EVENT_ID                                                                                           NUMBER WAIT_CLASS_ID                                                                                      NUMBER WAIT_CLASS#                                                                                        NUMBER WAIT_CLASS                                                                                         VARCHAR2(64)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/95233/viewspace-584442/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/95233/viewspace-584442/