欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

db file scattered read

程序员文章站 2022-04-19 16:37:29
...
SQL> set linesize 200
SQL> col name format a30
SQL> 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 =143  2    3    4  ;

SESSION_ID NAME 				  P1	     P2 	P3  WAIT_TIME CURRENT_OBJ# CURRENT_FILE# CURRENT_BLOCK#
---------- ------------------------------ ---------- ---------- ---------- ---------- ------------ ------------- --------------
       143 db file scattered read		   7	  13451 	16	    0	     95360	       7	  13451
       143 db file scattered read		   1	  38844 	10	    0		37	       1	  38844
       143 db file scattered read		   1	  33161 	13	    0		37	       1	  33161

SQL> select owner, segment_name, segment_type
  from dba_extents
 where file_id = 7
   and 13451 between block_id
   and block_id + blocks - 1  2    3    4    5  ;

OWNER			       SEGMENT_NAME									 SEGMENT_TYPE
------------------------------ --------------------------------------------------------------------------------- ------------------
AWP			       T46_HX_ACCJ_ATOM_LIST_HIS_Q							 TABLE