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 read 3 933125 1 0 0 3 933125 49 db file sequential read 3 656639 1 0 0 3 656639 49 db file sequential read 3 656473 1 0 0 3 656473 49 db file sequential read 3 663120 1 0 0 3 663120 9 rows selected. SQL> select owner, segment_name, segment_type from dba_extents where file_id = 3 and 661691 between block_id and block_id + blocks - 1 ; 2 3 4 5 OWNER SEGMENT_NAME SEGMENT_TYPE ------------------------------ --------------------------------------------------------------------------------- ------------------ SYS _SYSSMU2_967517682$ TYPE2 UNDO
读UNDO引发的db file sequential read
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
上一篇:行链接和行迁移
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
何时会发生db file sequential read等待事件
db file sequential read发生在哪些种情况
db file sequential r