direct path read

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 SESSION_ID=47;  2    3    4  SESSION_ID NAME   P1     P2 P3  WAIT_TIME CURRENT_OBJ# CURRENT_FILE# CURRENT_BLOCK#---------- ------------------------------ ---------- ---------- ---------- ---------- ------------ ------------- --------------47 direct path read   4 439696  8    0     78043       4 43455247 direct path read   4 431152  8    0     78043       4 43114447 direct path read   4 427264  8    0     78043       4 42725647 direct path read   4 423712  8    0     78043       4 42370447 direct path read   4 416816  8    0     78043       4 41680847 direct path read   4 413088  8    0     78043       4 41308047 direct path read   4 409936  8    0     78043       4 40992847 direct path read   4 406112  8    0     78043       4 40610447 direct path read   4 401984  8    0     78043       4 40197647 direct path read   4 399248  8    0     78043       4 39924047 direct path read   4 394848  8    0     78043       4 394840SESSION_ID NAME   P1     P2 P3  WAIT_TIME CURRENT_OBJ# CURRENT_FILE# CURRENT_BLOCK#---------- ------------------------------ ---------- ---------- ---------- ---------- ------------ ------------- --------------47 direct path read   4 390672  8    0     78043       4 39066447 direct path read   4 388096  8    0     78043       4 38808847 direct path read   4 383856  8    0     78043       4 38384847 direct path read   4 380096  8    0     78043       4 38008847 direct path read   4 377488  8    0     78043       4 37748047 direct path read   4 373856  8    0     78043       4 37384847 direct path read   4 370128  8    0     78043       4 37012047 direct path read   4 366896  8    0     78043       4 36688847 direct path read   4 362544  8    0     78043       4 36253647 direct path read   4 358432  8    0     78043       4 35842447 direct path read   4 354928  8    0     78043       4 354920SESSION_ID NAME   P1     P2 P3  WAIT_TIME CURRENT_OBJ# CURRENT_FILE# CURRENT_BLOCK#---------- ------------------------------ ---------- ---------- ---------- ---------- ------------ ------------- --------------47 direct path read   4 350336  8    0     78043       4 35032847 direct path read   4 346624  8    0     78043       4 34661647 direct path read   4 343120  8    0     78043       4 34311247 direct path read   4 338960  8    0     78043       4 33895247 direct path read   4 337008  8    0     78043       4 33700047 direct path read   4 332688  8    0     78043       4 33268047 direct path read   4 329008  8    0     78043       4 32900047 direct path read   4 325536  8    0     78043       4 32552847 direct path read   4 321488  8    0     78043       4 32148047 direct path read   4 315920  8    0     78043       4 31591247 direct path read   4 306912  8    0     78043       4 306904SQL> select name,a.PARAMETER1,a.PARAMETER2,a.PARAMETER3 from v$event_name a where name='direct path read';NAME       PARAMETER1      PARAMETER2 PARAMETER3------------------------------ --------------- ---------- ----------------------------------------------------------------direct path read       file number     first dba  block cntP1:文件号P2: 第一个数据块P3:总共读了多少块 select owner,segment_name,segment_type from dba_extents      where file_id = 4 and 427264 between block_id and block_id+blocks-1;SQL>   2  OWNER       SEGMENT_NAME SEGMENT_TYPE------------------------------ --------------------------------------------------------------------------------- ------------------TEST       TEST1 TABLE11G中全表扫描也是这个等待事件。