OWI之direct path read

<pre name="code" class="sql"> select sid,event,p1,p2,p3 from v$session_wait where sid=9;
       SID        event                 p1      p2      p3
 1	9	direct path read	13	1535744	128

p1 要读取的绝对文件号

p2 读取的起始块号

p3 要读的块数

SQL> select * from v$mystat where rownum<2;

       SID STATISTIC#	   VALUE
---------- ---------- ----------
      1427	    0	       0

SQL> select count(*) from F_AGT_COMR_INTDIST_H;


SQL> select sid,event,p1,p2,p3 from v$session_wait where sid=1427;

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    18	   907780	 124

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    29	   920324	 124

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    24	  1141376	 128

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    19	   426884	 124

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    12	  1010945	 127

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    44	    87296	 128

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    26	   420356	 124

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    22	   857856	 128

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    16	  1462016	 128

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    14	   972288	 128

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    10	   864130	 126

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							     7	   991880	 120

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							     7	   997632	 128

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							     5	  1409024	 128

SQL> /

       SID EVENT								    P1	       P2	  P3
---------- ---------------------------------------------------------------- ---------- ---------- ----------
      1427 direct path read							    51	   747648	 128


正常情况下P3值约等于多块读的块数