ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 学习Oracle动态性能表-v$system_event

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

原创 Linux操作系统 作者:xuelu2000 时间:2009-04-02 22:49:02 0 删除 编辑

转载: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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-23

  • 博文量
    89
  • 访问量
    235523