Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> questions about cbo explain plan

questions about cbo explain plan

From: lsllcm <lsllcm_at_gmail.com>
Date: 28 Nov 2005 18:58:56 -0800
Message-ID: <1133233136.244935.207750@f14g2000cwb.googlegroups.com> 





I have oracle 9.2.0.7 running on windows 2003 server.



The init parameter:


hash_area_size 4M
sort_area_size 2M
optimizer_index_caching=90
optimizer_index_cost_adj=10
optimizer_mode=first_rows_100





I have use the following command to gather the stats



exec


dbms_stats.gather_schema_stats('USER1',estimate_percent=>99.99,cascade=>
TRUE);


But the result of rbo and cbo is very different. There are a lot of
direct path write/reads wait events under cbo case.  Can anyone help on
this one? Thanks in advance!



    
  
  1.   running on rbo
PARSING IN CURSOR #1 len=1122 dep=0 uid=51 oct=3 lid=51 tim=7211444956
hv=1684894810 ad='30a3440c'
SELECT /*+ rule */ * FROM (SELECT DISTINCT
    T1.ID1, T1.ID2, T1.ID3
    T2.COL1, T2.COL2

  FROM T1, T2

  WHERE  T1.ID1 = T2.ID1(+)

   AND   T1.ID2 = T2.ID2(+)

   AND   T1.ID3 = T2.ID3(+)

  ORDER BY  T1.CREATED_DATE DESC, T1.ID2 ASC, T1.ID3 ASC

  )
  WHERE ROWNUM < 101
END OF STMT

PARSE #1:c=0,e=179,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=3,tim=7211444948
BINDS #1:

EXEC #1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=3,tim=7211445786
WAIT #1: nam='SQL*Net message to client' ela= 11 p1=1413697536 p2=1
p3=0
FETCH


    
#1:c=7640625,e=7960634,p=0,cr=687954,cu=0,mis=0,r=1,dep=0,og=3,tim=7219406609
    
WAIT #1: nam='SQL*Net message from client' ela= 1201 p1=1413697536 p2=1
p3=0
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=158,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=3,tim=7219408306
WAIT #1: nam='SQL*Net message from client' ela= 1553491 p1=1413697536
p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=168,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=3,tim=7220962195
WAIT #1: nam='SQL*Net message from client' ela= 85009 p1=1413697536
p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=102,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=3,tim=7221047445
WAIT #1: nam='SQL*Net message from client' ela= 77434 p1=1413697536
p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 1 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=104,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=3,tim=7221125072
WAIT #1: nam='SQL*Net message from client' ela= 79064 p1=1413697536
p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=116,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=3,tim=7221204362
WAIT #1: nam='SQL*Net message from client' ela= 79272 p1=1413697536
p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=88,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=3,tim=7221283816
WAIT #1: nam='SQL*Net message from client' ela= 76961 p1=1413697536
p2=1 p3=0
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=215,p=0,cr=0,cu=0,mis=0,r=9,dep=0,og=3,tim=7221361096
*** 2005-11-29 10:54:43.567
WAIT #1: nam='SQL*Net message from client' ela= 39940276 p1=1413697536
p2=1 p3=0
STAT #1 id=1 cnt=100 pid=0 pos=1 obj=0 op='COUNT STOPKEY '
STAT #1 id=2 cnt=100 pid=1 pos=1 obj=0 op='VIEW  '
STAT #1 id=3 cnt=100 pid=2 pos=1 obj=0 op='SORT UNIQUE STOPKEY '
STAT #1 id=4 cnt=314262 pid=3 pos=1 obj=0 op='NESTED LOOPS OUTER '
STAT #1 id=5 cnt=311885 pid=4 pos=1 obj=29707 op='TABLE ACCESS BY INDEX
ROWID T1 '

STAT #1 id=6 cnt=312443 pid=5 pos=1 obj=29713 op='INDEX RANGE SCAN
T1_APPSTATUS_IX '

STAT #1 id=7 cnt=40825 pid=4 pos=2 obj=29720 op='TABLE ACCESS BY INDEX
ROWID T2 '

STAT #1 id=8 cnt=40825 pid=7 pos=1 obj=29722 op='INDEX RANGE SCAN T2_PK
'

  
  2.   running on cbo






PARSING IN CURSOR #1 len=1110 dep=0 uid=51 oct=3 lid=51 tim=5423708260
hv=2634529737 ad='304af7f0'


SELECT * FROM (SELECT DISTINCT



    T1.ID1, T1.ID2, T1.ID3


    T2.COL1, T2.COL2



  FROM T1, T2


  WHERE  T1.ID1 = T2.ID1(+)
   AND   T1.ID2 = T2.ID2(+)
   AND   T1.ID3 = T2.ID3(+)




  ORDER BY  T1.CREATED_DATE DESC, T1.ID2 ASC, T1.ID3 ASC

  )


  WHERE ROWNUM < 101


END OF STMT



PARSE



#1:c=15625,e=8442,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=2,tim=5423708244

BINDS #1:


EXEC #1:c=0,e=205,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=2,tim=5423708896
WAIT #1: nam='SQL*Net message to client' ela= 8 p1=1413697536 p2=1 p3=0
WAIT #1: nam='direct path write' ela= 10159 p1=201 p2=58761 p3=34
WAIT #1: nam='direct path write' ela= 7556 p1=201 p2=58829 p3=34
WAIT #1: nam='direct path write' ela= 6408 p1=201 p2=136235 p3=34
WAIT #1: nam='direct path write' ela= 63 p1=201 p2=114057 p3=34
WAIT #1: nam='direct path write' ela= 9468 p1=201 p2=58795 p3=34
WAIT #1: nam='direct path write' ela= 8242 p1=201 p2=114091 p3=34
WAIT #1: nam='direct path write' ela= 10514 p1=201 p2=136269 p3=34
WAIT #1: nam='direct path write' ela= 10131 p1=201 p2=137293 p3=34
WAIT #1: nam='direct path write' ela= 9989 p1=201 p2=82441 p3=34
WAIT #1: nam='direct path write' ela= 14339 p1=201 p2=136201 p3=34
WAIT #1: nam='direct path write' ela= 17328 p1=201 p2=117513 p3=34
WAIT #1: nam='direct path write' ela= 61 p1=201 p2=117547 p3=34
WAIT #1: nam='direct path write' ela= 6224 p1=201 p2=137225 p3=34
WAIT #1: nam='direct path write' ela= 9798 p1=201 p2=114125 p3=34
WAIT #1: nam='direct path write' ela= 8807 p1=201 p2=85837 p3=34
WAIT #1: nam='direct path write' ela= 9748 p1=201 p2=117581 p3=34
WAIT #1: nam='direct path write' ela= 11846 p1=201 p2=137259 p3=34
WAIT #1: nam='direct path write' ela= 13700 p1=201 p2=134409 p3=34
WAIT #1: nam='direct path write' ela= 15249 p1=201 p2=82509 p3=34
WAIT #1: nam='direct path write' ela= 73 p1=201 p2=83593 p3=34
WAIT #1: nam='direct path write' ela= 3329 p1=201 p2=85769 p3=34
WAIT #1: nam='direct path write' ela= 10377 p1=201 p2=134443 p3=34
WAIT #1: nam='direct path write' ela= 10051 p1=201 p2=83661 p3=34
WAIT #1: nam='direct path write' ela= 10588 p1=201 p2=85803 p3=34
WAIT #1: nam='direct path write' ela= 9167 p1=201 p2=134477 p3=34
WAIT #1: nam='direct path write' ela= 18047 p1=201 p2=82475 p3=34
WAIT #1: nam='direct path write' ela= 26920 p1=201 p2=124749 p3=34
WAIT #1: nam='direct path write' ela= 69 p1=201 p2=83627 p3=34
WAIT #1: nam='direct path write' ela= 2401 p1=201 p2=80905 p3=34
WAIT #1: nam='direct path write' ela= 8933 p1=201 p2=124681 p3=34
WAIT #1: nam='direct path write' ela= 7982 p1=201 p2=80939 p3=34
WAIT #1: nam='direct path write' ela= 9480 p1=201 p2=80973 p3=34
WAIT #1: nam='direct path write' ela= 10124 p1=201 p2=124715 p3=34
WAIT #1: nam='direct path write' ela= 16581 p1=201 p2=109355 p3=34
WAIT #1: nam='direct path write' ela= 16857 p1=201 p2=109321 p3=34
WAIT #1: nam='direct path write' ela= 69 p1=201 p2=20361 p3=34
WAIT #1: nam='direct path write' ela= 2255 p1=201 p2=109389 p3=34
WAIT #1: nam='direct path write' ela= 7922 p1=201 p2=38187 p3=34
WAIT #1: nam='direct path write' ela= 6497 p1=201 p2=38153 p3=34
WAIT #1: nam='direct path write' ela= 9849 p1=201 p2=20395 p3=34
WAIT #1: nam='direct path write' ela= 10449 p1=201 p2=35337 p3=34
WAIT #1: nam='direct path write' ela= 9712 p1=201 p2=35371 p3=34
WAIT #1: nam='direct path write' ela= 9657 p1=201 p2=52045 p3=34
WAIT #1: nam='direct path write' ela= 58 p1=201 p2=27469 p3=34
WAIT #1: nam='direct path write' ela= 900 p1=201 p2=20429 p3=34
WAIT #1: nam='direct path write' ela= 9190 p1=201 p2=51977 p3=34
WAIT #1: nam='direct path write' ela= 6487 p1=201 p2=52011 p3=34
WAIT #1: nam='direct path write' ela= 9695 p1=201 p2=20873 p3=34
WAIT #1: nam='direct path write' ela= 9862 p1=201 p2=27435 p3=34
WAIT #1: nam='direct path write' ela= 9337 p1=201 p2=81579 p3=34
WAIT #1: nam='direct path write' ela= 8513 p1=201 p2=27401 p3=34
WAIT #1: nam='direct path write' ela= 69 p1=201 p2=22921 p3=34
WAIT #1: nam='direct path write' ela= 58 p1=201 p2=20907 p3=34
WAIT #1: nam='direct path write' ela= 9198 p1=201 p2=20941 p3=34
WAIT #1: nam='direct path write' ela= 7933 p1=201 p2=81545 p3=34
WAIT #1: nam='direct path write' ela= 9949 p1=201 p2=22989 p3=34
WAIT #1: nam='direct path write' ela= 8911 p1=201 p2=81613 p3=34
WAIT #1: nam='direct path write' ela= 8959 p1=201 p2=38221 p3=34
WAIT #1: nam='direct path write' ela= 10607 p1=201 p2=39373 p3=34
WAIT #1: nam='direct path write' ela= 71 p1=201 p2=22955 p3=34
WAIT #1: nam='direct path write' ela= 60 p1=201 p2=102793 p3=34
WAIT #1: nam='direct path write' ela= 9144 p1=201 p2=102861 p3=34
WAIT #1: nam='direct path write' ela= 5609 p1=201 p2=102827 p3=34
WAIT #1: nam='direct path write' ela= 10468 p1=201 p2=39339 p3=34
WAIT #1: nam='direct path write' ela= 9820 p1=201 p2=39305 p3=34
WAIT #1: nam='direct path write' ela= 9457 p1=201 p2=37385 p3=34
WAIT #1: nam='direct path write' ela= 8032 p1=201 p2=54187 p3=34
WAIT #1: nam='direct path write' ela= 71 p1=201 p2=37419 p3=34
WAIT #1: nam='direct path write' ela= 56 p1=201 p2=37453 p3=34
WAIT #1: nam='direct path write' ela= 8701 p1=201 p2=52105 p3=34
WAIT #1: nam='direct path write' ela= 5239 p1=201 p2=52139 p3=34
WAIT #1: nam='direct path write' ela= 9276 p1=201 p2=54221 p3=34
WAIT #1: nam='direct path write' ela= 9586 p1=201 p2=52173 p3=34
WAIT #1: nam='direct path write' ela= 9900 p1=201 p2=54153 p3=34
WAIT #1: nam='direct path write' ela= 9662 p1=201 p2=92041 p3=34
WAIT #1: nam='direct path write' ela= 65 p1=201 p2=35405 p3=34
WAIT #1: nam='direct path write' ela= 1866 p1=201 p2=92075 p3=34
WAIT #1: nam='direct path write' ela= 7399 p1=201 p2=92109 p3=34
WAIT #1: nam='direct path write' ela= 8339 p1=201 p2=30601 p3=34
WAIT #1: nam='direct path write' ela= 8127 p1=201 p2=30635 p3=34
WAIT #1: nam='direct path write' ela= 9374 p1=201 p2=30669 p3=34
WAIT #1: nam='direct path write' ela= 6944 p1=201 p2=117129 p3=34
WAIT #1: nam='direct path write' ela= 7517 p1=201 p2=117163 p3=34
WAIT #1: nam='direct path write' ela= 67 p1=201 p2=117197 p3=34
WAIT #1: nam='direct path write' ela= 4261 p1=201 p2=113033 p3=34
WAIT #1: nam='direct path write' ela= 1881 p1=201 p2=113067 p3=34
WAIT #1: nam='direct path write' ela= 10370 p1=201 p2=49161 p3=34
WAIT #1: nam='direct path write' ela= 7531 p1=201 p2=113101 p3=34
WAIT #1: nam='direct path write' ela= 8250 p1=201 p2=49195 p3=34
WAIT #1: nam='direct path write' ela= 6905 p1=201 p2=49229 p3=34
WAIT #1: nam='direct path write' ela= 9689 p1=201 p2=50185 p3=34
WAIT #1: nam='direct path write' ela= 71 p1=201 p2=50219 p3=34
WAIT #1: nam='direct path write' ela= 54 p1=201 p2=50253 p3=34
WAIT #1: nam='direct path write' ela= 4069 p1=201 p2=39561 p3=34
WAIT #1: nam='direct path write' ela= 9939 p1=201 p2=39629 p3=34
WAIT #1: nam='direct path write' ela= 3547 p1=201 p2=39595 p3=34
WAIT #1: nam='direct path write' ela= 9832 p1=201 p2=42027 p3=34
WAIT #1: nam='direct path write' ela= 9649 p1=201 p2=41993 p3=34
WAIT #1: nam='direct path write' ela= 8878 p1=201 p2=42061 p3=34
WAIT #1: nam='direct path write' ela= 69 p1=201 p2=31113 p3=34
WAIT #1: nam='direct path write' ela= 61 p1=201 p2=31147 p3=34
WAIT #1: nam='direct path write' ela= 3658 p1=201 p2=31181 p3=34
WAIT #1: nam='direct path write' ela= 10315 p1=201 p2=129417 p3=34
WAIT #1: nam='direct path write' ela= 7471 p1=201 p2=129451 p3=34
WAIT #1: nam='direct path write' ela= 9735 p1=201 p2=48393 p3=34
WAIT #1: nam='direct path write' ela= 7546 p1=201 p2=48427 p3=34
WAIT #1: nam='direct path write' ela= 9962 p1=201 p2=48461 p3=34
WAIT #1: nam='direct path write' ela= 161129 p1=201 p2=129485 p3=34
WAIT #1: nam='direct path write' ela= 3 p1=201 p2=43179 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=47275 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=43213 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=47241 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=47309 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=42795 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=43145 p3=34
WAIT #1: nam='direct path write' ela= 13 p1=201 p2=42761 p3=34
WAIT #1: nam='direct path write' ela= 10 p1=201 p2=42829 p3=34
WAIT #1: nam='direct path write' ela= 19 p1=201 p2=41353 p3=34
WAIT #1: nam='direct path write' ela= 6 p1=201 p2=41387 p3=34
WAIT #1: nam='direct path write' ela= 8 p1=201 p2=41421 p3=34
WAIT #1: nam='direct path write' ela= 59223 p1=201 p2=40073 p3=34
WAIT #1: nam='direct path write' ela= 8 p1=201 p2=40141 p3=34
WAIT #1: nam='direct path write' ela= 12 p1=201 p2=38955 p3=34
WAIT #1: nam='direct path write' ela= 13 p1=201 p2=37513 p3=34
WAIT #1: nam='direct path write' ela= 11 p1=201 p2=37581 p3=34
WAIT #1: nam='direct path write' ela= 13686 p1=201 p2=96427 p3=34
WAIT #1: nam='direct path write' ela= 8 p1=201 p2=31625 p3=34
WAIT #1: nam='direct path write' ela= 13 p1=201 p2=31693 p3=34
WAIT #1: nam='direct path write' ela= 10 p1=201 p2=38989 p3=34
WAIT #1: nam='direct path write' ela= 9 p1=201 p2=38921 p3=34
WAIT #1: nam='direct path write' ela= 222491 p1=201 p2=96393 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=40107 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=37547 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=31659 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=96461 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=44331 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=22281 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=22315 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=44365 p3=34
WAIT #1: nam='direct path write' ela= 2 p1=201 p2=102989 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=44297 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=102921 p3=34
WAIT #1: nam='direct path write' ela= 1 p1=201 p2=102955 p3=34
WAIT #1: nam='direct path read' ela= 49256 p1=201 p2=137293 p3=34
WAIT #1: nam='direct path read' ela= 32036 p1=201 p2=82441 p3=34
WAIT #1: nam='direct path read' ela= 2596 p1=201 p2=82475 p3=34
WAIT #1: nam='direct path read' ela= 28719 p1=201 p2=124749 p3=34
WAIT #1: nam='direct path read' ela= 35610 p1=201 p2=109321 p3=34
WAIT #1: nam='direct path read' ela= 25698 p1=201 p2=35405 p3=34
WAIT #1: nam='direct path read' ela= 33619 p1=201 p2=117197 p3=34
WAIT #1: nam='direct path read' ela= 21653 p1=201 p2=50219 p3=34
WAIT #1: nam='direct path read' ela= 34271 p1=201 p2=40073 p3=34
WAIT #1: nam='direct path read' ela= 48 p1=201 p2=40107 p3=34
WAIT #1: nam='direct path read' ela= 14859 p1=201 p2=102955 p3=34
WAIT #1: nam='direct path read' ela= 13 p1=201 p2=31113 p3=34
WAIT #1: nam='direct path read' ela= 34510 p1=201 p2=48461 p3=34
WAIT #1: nam='direct path read' ela= 16520 p1=201 p2=42761 p3=34
WAIT #1: nam='direct path read' ela= 5843 p1=201 p2=42829 p3=34
WAIT #1: nam='direct path read' ela= 15019 p1=201 p2=41353 p3=34
WAIT #1: nam='direct path read' ela= 9871 p1=201 p2=41387 p3=34
WAIT #1: nam='direct path read' ela= 18165 p1=201 p2=41421 p3=34
WAIT #1: nam='direct path read' ela= 21434 p1=201 p2=40073 p3=34
WAIT #1: nam='direct path read' ela= 46 p1=201 p2=40107 p3=34
WAIT #1: nam='direct path read' ela= 25333 p1=201 p2=102955 p3=34
WAIT #1: nam='direct path read' ela= 30247 p1=201 p2=85837 p3=34
WAIT #1: nam='direct path read' ela= 33495 p1=201 p2=134409 p3=34
WAIT #1: nam='direct path read' ela= 26308 p1=201 p2=83593 p3=34
WAIT #1: nam='direct path read' ela= 8676 p1=201 p2=83661 p3=34
WAIT #1: nam='direct path read' ela= 32905 p1=201 p2=80973 p3=34
WAIT #1: nam='direct path read' ela= 32896 p1=201 p2=38221 p3=34
WAIT #1: nam='direct path read' ela= 16538 p1=201 p2=39373 p3=34
WAIT #1: nam='direct path read' ela= 21191 p1=201 p2=37385 p3=34
WAIT #1: nam='direct path read' ela= 34708 p1=201 p2=37581 p3=34
WAIT #1: nam='direct path read' ela= 22679 p1=201 p2=96393 p3=34
WAIT #1: nam='direct path read' ela= 27822 p1=201 p2=102921 p3=34
WAIT #1: nam='direct path read' ela= 13 p1=201 p2=54187 p3=34
WAIT #1: nam='direct path read' ela= 16223 p1=201 p2=54221 p3=34
WAIT #1: nam='direct path read' ela= 26746 p1=201 p2=30635 p3=34
WAIT #1: nam='direct path read' ela= 16358 p1=201 p2=49161 p3=34
WAIT #1: nam='direct path read' ela= 22471 p1=201 p2=39595 p3=34
WAIT #1: nam='direct path read' ela= 28856 p1=201 p2=129451 p3=34
WAIT #1: nam='direct path read' ela= 28634 p1=201 p2=43145 p3=34
WAIT #1: nam='direct path read' ela= 16156 p1=201 p2=37581 p3=34
WAIT #1: nam='direct path read' ela= 23888 p1=201 p2=96393 p3=34
WAIT #1: nam='direct path read' ela= 28218 p1=201 p2=102921 p3=34
WAIT #1: nam='direct path read' ela= 25223 p1=201 p2=20361 p3=34
WAIT #1: nam='direct path read' ela= 3333 p1=201 p2=20395 p3=34
WAIT #1: nam='direct path read' ela= 14234 p1=201 p2=52045 p3=34
WAIT #1: nam='direct path read' ela= 22517 p1=201 p2=27469 p3=34
WAIT #1: nam='direct path read' ela= 16964 p1=201 p2=20873 p3=34
WAIT #1: nam='direct path read' ela= 21360 p1=201 p2=81579 p3=34
WAIT #1: nam='direct path read' ela= 24258 p1=201 p2=22921 p3=34
WAIT #1: nam='direct path read' ela= 14410 p1=201 p2=22989 p3=34
WAIT #1: nam='direct path read' ela= 29549 p1=201 p2=31693 p3=34
WAIT #1: nam='direct path read' ela= 15916 p1=201 p2=44297 p3=34
WAIT #1: nam='direct path read' ela= 12 p1=201 p2=39305 p3=34
WAIT #1: nam='direct path read' ela= 17315 p1=201 p2=54153 p3=34
WAIT #1: nam='direct path read' ela= 20002 p1=201 p2=117129 p3=34
WAIT #1: nam='direct path read' ela= 24517 p1=201 p2=49229 p3=34
WAIT #1: nam='direct path read' ela= 16994 p1=201 p2=42027 p3=34
WAIT #1: nam='direct path read' ela= 25079 p1=201 p2=129485 p3=34
WAIT #1: nam='direct path read' ela= 29065 p1=201 p2=42795 p3=34
WAIT #1: nam='direct path read' ela= 16178 p1=201 p2=31693 p3=34
WAIT #1: nam='direct path read' ela= 15052 p1=201 p2=44297 p3=34
WAIT #1: nam='direct path read' ela= 37026 p1=201 p2=117513 p3=34
WAIT #1: nam='direct path read' ela= 11935 p1=201 p2=117547 p3=34
WAIT #1: nam='direct path read' ela= 26184 p1=201 p2=117581 p3=34
WAIT #1: nam='direct path read' ela= 33110 p1=201 p2=134443 p3=34
WAIT #1: nam='direct path read' ela= 30424 p1=201 p2=80939 p3=34
WAIT #1: nam='direct path read' ela= 28921 p1=201 p2=38187 p3=34
WAIT #1: nam='direct path read' ela= 19864 p1=201 p2=51977 p3=34
WAIT #1: nam='direct path read' ela= 18277 p1=201 p2=20941 p3=34
WAIT #1: nam='direct path read' ela= 70517 p1=201 p2=37513 p3=34
WAIT #1: nam='direct path read' ela= 1669 p1=201 p2=37547 p3=34
WAIT #1: nam='direct path read' ela= 25063 p1=201 p2=102989 p3=34
WAIT #1: nam='direct path read' ela= 13 p1=201 p2=102827 p3=34
WAIT #1: nam='direct path read' ela= 33319 p1=201 p2=52139 p3=34
WAIT #1: nam='direct path read' ela= 14959 p1=201 p2=30601 p3=34
WAIT #1: nam='direct path read' ela= 27198 p1=201 p2=113101 p3=34
WAIT #1: nam='direct path read' ela= 19937 p1=201 p2=39629 p3=34
WAIT #1: nam='direct path read' ela= 36453 p1=201 p2=129417 p3=34
WAIT #1: nam='direct path read' ela= 33434 p1=201 p2=47309 p3=34
WAIT #1: nam='direct path read' ela= 15663 p1=201 p2=37513 p3=34
WAIT #1: nam='direct path read' ela= 5783 p1=201 p2=37547 p3=34
WAIT #1: nam='direct path read' ela= 29128 p1=201 p2=102989 p3=34
WAIT #1: nam='direct path read' ela= 26962 p1=201 p2=114057 p3=34
WAIT #1: nam='direct path read' ela= 10291 p1=201 p2=114091 p3=34
WAIT #1: nam='direct path read' ela= 31943 p1=201 p2=137225 p3=34
WAIT #1: nam='direct path read' ela= 27988 p1=201 p2=85769 p3=34
WAIT #1: nam='direct path read' ela= 11053 p1=201 p2=80905 p3=34
WAIT #1: nam='direct path read' ela= 32026 p1=201 p2=109389 p3=34
WAIT #1: nam='direct path read' ela= 20664 p1=201 p2=20429 p3=34
WAIT #1: nam='direct path read' ela= 19436 p1=201 p2=20907 p3=34
WAIT #1: nam='direct path read' ela= 54401 p1=201 p2=40141 p3=34
WAIT #1: nam='direct path read' ela= 10863 p1=201 p2=38921 p3=34
WAIT #1: nam='direct path read' ela= 7818 p1=201 p2=44365 p3=34
WAIT #1: nam='direct path read' ela= 12 p1=201 p2=102793 p3=34
WAIT #1: nam='direct path read' ela= 19980 p1=201 p2=37453 p3=34
WAIT #1: nam='direct path read' ela= 24345 p1=201 p2=92075 p3=34
WAIT #1: nam='direct path read' ela= 25020 p1=201 p2=113033 p3=34
WAIT #1: nam='direct path read' ela= 28521 p1=201 p2=50253 p3=34
WAIT #1: nam='direct path read' ela= 13115 p1=201 p2=31147 p3=34
WAIT #1: nam='direct path read' ela= 17371 p1=201 p2=47241 p3=34
WAIT #1: nam='direct path read' ela= 16084 p1=201 p2=40141 p3=34
WAIT #1: nam='direct path read' ela= 12953 p1=201 p2=38921 p3=34
WAIT #1: nam='direct path read' ela= 7331 p1=201 p2=44365 p3=34
WAIT #1: nam='direct path read' ela= 32768 p1=201 p2=136235 p3=34
WAIT #1: nam='direct path read' ela= 4664 p1=201 p2=136269 p3=34
WAIT #1: nam='direct path read' ela= 13282 p1=201 p2=137259 p3=34
WAIT #1: nam='direct path read' ela= 17531 p1=201 p2=134477 p3=34
WAIT #1: nam='direct path read' ela= 16944 p1=201 p2=124715 p3=34
WAIT #1: nam='direct path read' ela= 32594 p1=201 p2=35337 p3=34
WAIT #1: nam='direct path read' ela= 13620 p1=201 p2=27401 p3=34
WAIT #1: nam='direct path read' ela= 19706 p1=201 p2=22955 p3=34
WAIT #1: nam='direct path read' ela= 38392 p1=201 p2=96427 p3=34
WAIT #1: nam='direct path read' ela= 361 p1=201 p2=96461 p3=34
WAIT #1: nam='direct path read' ela= 21870 p1=201 p2=22315 p3=34
WAIT #1: nam='direct path read' ela= 13 p1=201 p2=37419 p3=34
WAIT #1: nam='direct path read' ela= 21954 p1=201 p2=92041 p3=34
WAIT #1: nam='direct path read' ela= 24409 p1=201 p2=117163 p3=34
WAIT #1: nam='direct path read' ela= 28091 p1=201 p2=50185 p3=34
WAIT #1: nam='direct path read' ela= 13505 p1=201 p2=42061 p3=34
WAIT #1: nam='direct path read' ela= 17606 p1=201 p2=48427 p3=34
WAIT #1: nam='direct path read' ela= 16072 p1=201 p2=43213 p3=34
WAIT #1: nam='direct path read' ela= 24113 p1=201 p2=96427 p3=34
WAIT #1: nam='direct path read' ela= 6253 p1=201 p2=96461 p3=34
WAIT #1: nam='direct path read' ela= 21208 p1=201 p2=22315 p3=34
WAIT #1: nam='direct path read' ela= 15481 p1=201 p2=58761 p3=34
WAIT #1: nam='direct path read' ela= 2868 p1=201 p2=58795 p3=34
WAIT #1: nam='direct path read' ela= 29105 p1=201 p2=114125 p3=34
WAIT #1: nam='direct path read' ela= 37853 p1=201 p2=85803 p3=34
WAIT #1: nam='direct path read' ela= 33184 p1=201 p2=124681 p3=34
WAIT #1: nam='direct path read' ela= 43041 p1=201 p2=38153 p3=34
WAIT #1: nam='direct path read' ela= 30276 p1=201 p2=52011 p3=34
WAIT #1: nam='direct path read' ela= 30523 p1=201 p2=81545 p3=34
WAIT #1: nam='direct path read' ela= 57816 p1=201 p2=31625 p3=34
WAIT #1: nam='direct path read' ela= 45 p1=201 p2=31659 p3=34
WAIT #1: nam='direct path read' ela= 17631 p1=201 p2=22281 p3=34
WAIT #1: nam='direct path read' ela= 13 p1=201 p2=102861 p3=34
WAIT #1: nam='direct path read' ela= 17768 p1=201 p2=52105 p3=34
WAIT #1: nam='direct path read' ela= 23961 p1=201 p2=92109 p3=34
WAIT #1: nam='direct path read' ela= 30998 p1=201 p2=113067 p3=34
WAIT #1: nam='direct path read' ela= 17280 p1=201 p2=39561 p3=34
WAIT #1: nam='direct path read' ela= 17971 p1=201 p2=31181 p3=34
WAIT #1: nam='direct path read' ela= 17784 p1=201 p2=47275 p3=34
WAIT #1: nam='direct path read' ela= 17072 p1=201 p2=31625 p3=34
WAIT #1: nam='direct path read' ela= 1985 p1=201 p2=31659 p3=34
WAIT #1: nam='direct path read' ela= 15788 p1=201 p2=22281 p3=34
WAIT #1: nam='direct path read' ela= 15069 p1=201 p2=58829 p3=34
WAIT #1: nam='direct path read' ela= 28831 p1=201 p2=136201 p3=34
WAIT #1: nam='direct path read' ela= 35621 p1=201 p2=82509 p3=34
WAIT #1: nam='direct path read' ela= 12090 p1=201 p2=83627 p3=34
WAIT #1: nam='direct path read' ela= 42804 p1=201 p2=109355 p3=34
WAIT #1: nam='direct path read' ela= 28549 p1=201 p2=35371 p3=34
WAIT #1: nam='direct path read' ela= 20917 p1=201 p2=27435 p3=34
WAIT #1: nam='direct path read' ela= 21801 p1=201 p2=81613 p3=34
WAIT #1: nam='direct path read' ela= 42926 p1=201 p2=38955 p3=34
WAIT #1: nam='direct path read' ela= 1332 p1=201 p2=38989 p3=34
WAIT #1: nam='direct path read' ela= 10474 p1=201 p2=44331 p3=34
WAIT #1: nam='direct path read' ela= 12 p1=201 p2=39339 p3=34
WAIT #1: nam='direct path read' ela= 17612 p1=201 p2=52173 p3=34
WAIT #1: nam='direct path read' ela= 18774 p1=201 p2=30669 p3=34
WAIT #1: nam='direct path read' ela= 14935 p1=201 p2=49195 p3=34
WAIT #1: nam='direct path read' ela= 22362 p1=201 p2=41993 p3=34
WAIT #1: nam='direct path read' ela= 18474 p1=201 p2=48393 p3=34
WAIT #1: nam='direct path read' ela= 16769 p1=201 p2=43179 p3=34
WAIT #1: nam='direct path read' ela= 25504 p1=201 p2=38955 p3=34
WAIT #1: nam='direct path read' ela= 6552 p1=201 p2=38989 p3=34
WAIT #1: nam='direct path read' ela= 10252 p1=201 p2=44331 p3=34


FETCH



#1:c=3406250,e=8140028,p=5644,cr=45104,cu=0,mis=0,r=1,dep=0,og=2,tim=5431849053

WAIT #1: nam='SQL*Net message from client' ela= 1380 p1=1413697536 p2=1
p3=0


WAIT #1: nam='SQL*Net message to client' ela= 9 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=253,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=2,tim=5431851415
WAIT #1: nam='SQL*Net message from client' ela= 2914727 p1=1413697536
p2=1 p3=0


WAIT #1: nam='SQL*Net message to client' ela= 8 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=224,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=2,tim=5434766818
WAIT #1: nam='SQL*Net message from client' ela= 1242698 p1=1413697536
p2=1 p3=0


WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=150,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=2,tim=5436009935
WAIT #1: nam='SQL*Net message from client' ela= 77000 p1=1413697536
p2=1 p3=0


WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=149,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=2,tim=5436087259
WAIT #1: nam='SQL*Net message from client' ela= 76692 p1=1413697536
p2=1 p3=0


WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=125,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=2,tim=5436164231
WAIT #1: nam='SQL*Net message from client' ela= 76598 p1=1413697536
p2=1 p3=0


WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=130,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=2,tim=5436241128
WAIT #1: nam='SQL*Net message from client' ela= 77731 p1=1413697536
p2=1 p3=0


WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1413697536 p2=1 p3=0
FETCH #1:c=0,e=384,p=0,cr=0,cu=0,mis=0,r=9,dep=0,og=2,tim=5436319417
WAIT #1: nam='SQL*Net message from client' ela= 3853338 p1=1413697536
p2=1 p3=0

STAT #1 id=1 cnt=100 pid=0 pos=1 obj=0 op='COUNT STOPKEY '
STAT #1 id=2 cnt=100 pid=1 pos=1 obj=0 op='VIEW  '
STAT #1 id=3 cnt=100 pid=2 pos=1 obj=0 op='SORT UNIQUE STOPKEY '
STAT #1 id=4 cnt=314248 pid=3 pos=1 obj=0 op='HASH JOIN OUTER '
STAT #1 id=5 cnt=311871 pid=4 pos=1 obj=29707 op='TABLE ACCESS BY INDEX


ROWID T1 '



STAT #1 id=6 cnt=312429 pid=5 pos=1 obj=29713 op='INDEX RANGE SCAN
T1_APPSTATUS_IX '



STAT #1 id=7 cnt=40819 pid=4 pos=2 obj=29720 op='TABLE ACCESS BY INDEX
ROWID T2 '



STAT #1 id=8 cnt=41455 pid=7 pos=1 obj=29722 op='INDEX RANGE SCAN T2_PK
'
Received on Mon Nov 28 2005 - 20:58:56 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US