从v$event_name中可以看到所有的等待事件,以及等待事件的分类
SQL> select * from v$version where rownum <2;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
SQL>
SQL> desc v$event_name
Name Null? Type
----------------------------------------- -------- ----------------------------
EVENT# NUMBER
EVENT_ID NUMBER
NAME VARCHAR2(64)
PARAMETER1 VARCHAR2(64)
PARAMETER2 VARCHAR2(64)
PARAMETER3 VARCHAR2(64)
WAIT_CLASS_ID NUMBER
WAIT_CLASS# NUMBER
WAIT_CLASS VARCHAR2(64)
SQL> set pagesize 999
SQL> col wait_class for a20
SQL> select wait_class#,wait_class_id,wait_class,count(*) as count from v$event_name group by wait_class#,wait_class_id,wait_class order by wait_class#;
WAIT_CLASS# WAIT_CLASS_ID WAIT_CLASS COUNT
----------- ------------- -------------------- ----------
0 1893977003 Other 719
1 4217450380 Application 17
2 3290255840 Configuration 24
3 4166625743 Administrative 54
4 3875070507 Concurrency 32
5 3386400367 Commit 2
6 2723168908 Idle 94
7 2000153315 Network 35
8 1740759767 User I/O 45
9 4108307767 System I/O 30
10 2396326234 Scheduler 7
11 3871361733 Cluster 50
12 644977587 Queueing 9
13 rows selected.
SQL> col name for a30
SQL> col parameter1 for a10
SQL> col parameter2 for a10
SQL> col parameter3 for a10
SQL> select name,parameter1,parameter2,parameter3 from v$event_name where name='db file scattered read';
NAME PARAMETER1 PARAMETER2 PARAMETER3
------------------------------ ---------- ---------- ----------
db file scattered read file# block# blocks
parameter1,parameter2,parameter3为等待事件的输入参数,对于不同的等待事件其输入参数含义各不相同。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/438414/viewspace-764628/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/438414/viewspace-764628/