从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博客

oracle等待事件一

最新文章