SQL> select * from (select SESSION_ID,
NAME,
P1,
P2,
P3,
WAIT_TIME,
CURRENT_OBJ#,
CURRENT_FILE#,
CURRENT_BLOCK#
from v$active_session_history ash, v$event_name enm
where ash.event# = enm.event#
and ash.session_id=49)
where rownum<10; 2 3 4 5 6 7 8 9 10 11 12 13
SESSION_ID NAME P1 P2 P3 WAIT_TIME CURRENT_OBJ# CURRENT_FILE# CURRENT_BLOCK#
---------- ------------------------------ ---------- ---------- ---------- ---------- ------------ ------------- --------------
49 resmgr:cpu quantum 2 0 0 0 0 3 666568
49 db file sequential read 3 661691 1 0 0 3 661691
49 db file sequential read 3 661568 1 0 0 3 661568
49 db file sequential read 3 665469 1 0 0 3 665469
49 resmgr:cpu quantum 2 0 0 0 0 3 933207
49 db file sequential re
读UNDO引发的db file sequential read
最新推荐文章于 2021-03-25 08:58:40 发布