| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: questions about cbo explain plan
It looks as if the text you've supplied isn't the text you ran - unless T1 and T2 are views and there's a lot of whitespace in the text.
Rule based did what it did because there
were relevant indexes and it used them,
and can't do hash join.
Cost based did what it did because you had told it that indexed access paths were very cheap, but it used a hash join because even with very cheap indexed access paths a nested loop over 300,000 rows made the hash join seem more desirable.
The direct path writes are a consequence of Oracle dumping the build (first) table to disc because there isn't enough memory to hold the data from all the required rows in memory, followed by a matching dump of the probe (second) table.
The direct path reads are those partitions being re-read in pairs for subsequent 'partition-wise' joins. (Oracle uses the word 'partition' in too many cases - in this case it has nothing to do with 'partitioned tables').
The break between reading the build and hash tables is obscured by the fact that both tables appear to be completely cache in the db buffer before you start; so none of the usual db file scattered reads and db file sequential reads that you would normally expect to see in the earlier stages of a hash join have appeared. This also explains why the two options performed at similar speeds, even though the nested loop was vastly more CPU intensive
NL resource usage 7.6 seconds CPU
> #1:c=7640625,e=7960634,p=0,cr=687954,cu=0,mis=0,r=1,dep=0,og=3,tim=7219406609
Hash resource usage 3.4 seconds CPU
> #1:c=3406250,e=8140028,p=5644,cr=45104,cu=0,mis=0,r=1,dep=0,og=2,tim=5431849053
explain plan for {query};
select * from table(dbms_xplan.display);
under the CBO, and take a look at the costs - then repeat with a set of hints that makes the CBO use the nested loop and see what happens to the cost.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 4th Nov 2005 "lsllcm" <lsllcm_at_gmail.com> wrote in message news:1133233136.244935.207750_at_f14g2000cwb.googlegroups.com...Received on Tue Nov 29 2005 - 02:48:00 CST
>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
> '
>
 |
 |