正如查询英文论坛中所说,CKPT或DBWR阻塞了direct path read ,那么我们需要知道出现这个等待事件的时候,CKPT或DBWR进程它们在等待什么 ?
如果程序还在运行的话,那么我们可以通过如下方式查询:
SQL> select sid,program from v$session where program like '%CKPT%' or program like '%DBW%';
SID PROGRAM
---------- ------------------------------------------------
453 oracle@localhost.localdomain (CKPT)
1521 oracle@localhost.localdomain (DBW0)
1773 oracle@localhost.localdomain (DBW1)
SQL> select sid,event,state,p1,p2,p3,seconds_in_wait from v$session_wait where sid in
(select sid from v$session where program like '%CKPT%' or program like '%DBW%');
SID EVENT STATE P1 P2 P3 SECONDS_IN_WAIT
---------- ------------------------------ ---------- ---------- ---------- ---------- ---------------
453 rdbms ipc message WAITING 300 0 0 3
1521 db file async I/O submit WAITING 967 0 0 1
1773 db file async I/O submit WAITING 1357 0 0 2
然后根据现象查询原因.....
如果程序还在运行的话,那么我们可以通过如下方式查询:
SQL> select sid,program from v$session where program like '%CKPT%' or program like '%DBW%';
SID PROGRAM
---------- ------------------------------------------------
453 oracle@localhost.localdomain (CKPT)
1521 oracle@localhost.localdomain (DBW0)
1773 oracle@localhost.localdomain (DBW1)
SQL> select sid,event,state,p1,p2,p3,seconds_in_wait from v$session_wait where sid in
(select sid from v$session where program like '%CKPT%' or program like '%DBW%');
SID EVENT STATE P1 P2 P3 SECONDS_IN_WAIT
---------- ------------------------------ ---------- ---------- ---------- ---------- ---------------
453 rdbms ipc message WAITING 300 0 0 3
1521 db file async I/O submit WAITING 967 0 0 1
1773 db file async I/O submit WAITING 1357 0 0 2
然后根据现象查询原因.....
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-1387118/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-1387118/