db file scattered read

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

原文地址:https://www.cnblogs.com/hzcya1995/p/13352350.html