TKPROF: Release 11.2.0.3.0 - Development on Wed Sep 25 16:08:18 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: INDIGO_WS1_ora_26942.trc Sort options: default ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** SQL ID: 4kvc1pjyh5n7x Plan Hash: 0 ALTER SESSION SET SQL_TRACE=TRUE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS ******************************************************************************** select serialnumber from product where productid in (select /*+ full parallel(producttask 16) */productid from producttask where startedtimestamp > to_date(:"SYS_B_0", :"SYS_B_1") and startedtimestamp < to_date(:"SYS_B_2", :"SYS_B_3") and producttasktypeid in (select producttasktypeid from producttasktype where producttaskname=:"SYS_B_4" or producttaskname=:"SYS_B_5" or producttaskname=:"SYS_B_6" ) and modelid in (select modelid from modeltable where familyid in (select familyid from family where familytypecode=:"SYS_B_7" or familytypecode=:"SYS_B_8") ) and rownum < :"SYS_B_9" ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 5.60 0 0 0 0 Execute 1 0.44 0.44 0 0 0 0 Fetch 1 661.91 701.28 1672046 310701053 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 662.36 707.33 1672046 310701053 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 FILTER (cr=0 pr=0 pw=0 time=9 us) 68230949 68230949 68230949 PARTITION RANGE ALL PARTITION: 1 6821 (cr=1672822 pr=1672046 pw=0 time=40641571 us cost=6321336 size=21417975172 card=738550868) 68230949 68230949 68230949 TABLE ACCESS STORAGE FULL PRODUCT PARTITION: 1 6821 (cr=1672822 pr=1672046 pw=0 time=31767603 us cost=6321336 size=21417975172 card=738550868) 0 0 0 FILTER (cr=309028231 pr=0 pw=0 time=601541841 us) 0 0 0 COUNT STOPKEY (cr=309028231 pr=0 pw=0 time=578495556 us) 0 0 0 NESTED LOOPS (cr=309028231 pr=0 pw=0 time=498997266 us) 0 0 0 NESTED LOOPS (cr=309028231 pr=0 pw=0 time=473112582 us cost=13 size=235 card=5) 0 0 0 NESTED LOOPS (cr=309028231 pr=0 pw=0 time=450928696 us cost=7 size=56 card=2) 0 0 0 VIEW VW_NSO_1 (cr=309028231 pr=0 pw=0 time=430191927 us cost=4 size=13 card=1) 0 0 0 FILTER (cr=309028231 pr=0 pw=0 time=408059385 us) 0 0 0 NESTED LOOPS (cr=309028231 pr=0 pw=0 time=383692985 us cost=3 size=18 card=1) 68230949 68230949 68230949 TABLE ACCESS BY INDEX ROWID MODELTABLE (cr=172566333 pr=0 pw=0 time=193414182 us cost=2 size=9 card=1) 68230949 68230949 68230949 INDEX UNIQUE SCAN MODELTABLE_MODELID (cr=104335384 pr=0 pw=0 time=116918887 us cost=1 size=0 card=1)(object id 134228) 0 0 0 TABLE ACCESS BY INDEX ROWID FAMILY (cr=136461898 pr=0 pw=0 time=154077043 us cost=1 size=36 card=4) 68230949 68230949 68230949 INDEX UNIQUE SCAN FAMILY_FAMILYID (cr=68230949 pr=0 pw=0 time=74243893 us cost=0 size=0 card=1)(object id 134196) 0 0 0 TABLE ACCESS STORAGE FULL FIRST ROWS PRODUCTTASKTYPE (cr=0 pr=0 pw=0 time=0 us cost=3 size=30 card=2) 0 0 0 PARTITION RANGE ITERATOR PARTITION: KEY KEY (cr=0 pr=0 pw=0 time=0 us cost=64 size=0 card=2) 0 0 0 PARTITION HASH ALL PARTITION: 1 32 (cr=0 pr=0 pw=0 time=0 us cost=64 size=0 card=2) 0 0 0 INDEX RANGE SCAN PT_RESULT_TASKTYPE_START_P PARTITION: KEY KEY (cr=0 pr=0 pw=0 time=0 us cost=64 size=0 card=2)(object id 4894371) 0 0 0 TABLE ACCESS BY LOCAL INDEX ROWID PRODUCTTASK PARTITION: 1 1 (cr=0 pr=0 pw=0 time=0 us cost=67 size=38 card=2) ******************************************************************************** SQL ID: 1gu8t96d0bdmu Plan Hash: 2035254952 select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols, nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans, t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln, t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1), nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0), nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 19 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 0 19 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN OUTER (cr=34 pr=2 pw=0 time=28959 us cost=2 size=191 card=1) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=33 pr=2 pw=0 time=28907 us cost=2 size=139 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=840 us cost=1 size=0 card=1)(object id 3) 0 0 0 BUFFER SORT (cr=1 pr=0 pw=0 time=43 us cost=0 size=52 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=1 pr=0 pw=0 time=12 us cost=0 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=1 pr=0 pw=0 time=11 us cost=0 size=0 card=1)(object id 431) ******************************************************************************** SQL ID: 7bd391hat42zk Plan Hash: 906473769 select /*+ rule */ name,file#,block#,status$,user#,undosqn,xactsqn,scnbas, scnwrp,DECODE(inst#,0,NULL,inst#),ts#,spare1 from undo$ where us#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.01 0.01 2 15 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.01 0.02 2 15 0 5 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID UNDO$ (cr=3 pr=0 pw=0 time=5059 us) 1 1 1 INDEX UNIQUE SCAN I_UNDO1 (cr=2 pr=0 pw=0 time=78 us)(object id 34) ******************************************************************************** SQL ID: 7ng34ruy5awxq Plan Hash: 3992920156 select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property, i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey, i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256), i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null, null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 9 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.00 0 9 0 7 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 7 7 7 SORT ORDER BY (cr=9 pr=0 pw=0 time=3926 us cost=7 size=374 card=2) 7 7 7 HASH JOIN OUTER (cr=9 pr=0 pw=0 time=3909 us cost=6 size=374 card=2) 7 7 7 NESTED LOOPS OUTER (cr=5 pr=0 pw=0 time=435 us cost=2 size=288 card=2) 7 7 7 TABLE ACCESS CLUSTER IND$ (cr=4 pr=0 pw=0 time=27 us cost=2 size=184 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=8 us cost=1 size=0 card=1)(object id 3) 0 0 0 TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 time=399 us cost=0 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=396 us cost=0 size=0 card=1)(object id 433) 1 1 1 VIEW (cr=4 pr=0 pw=0 time=3003 us cost=3 size=43 card=1) 1 1 1 SORT GROUP BY (cr=4 pr=0 pw=0 time=3003 us cost=3 size=16 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=4 pr=0 pw=0 time=2962 us cost=2 size=16 card=1) 4 4 4 INDEX RANGE SCAN I_CDEF2 (cr=2 pr=0 pw=0 time=1747 us cost=1 size=0 card=3)(object id 54) ******************************************************************************** SQL ID: 5n1fs4m2n2y0r Plan Hash: 299250003 select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 17 0.00 0.00 0 34 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 25 0.00 0.00 0 34 0 10 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID ICOL$ (cr=4 pr=0 pw=0 time=398 us cost=2 size=58 card=2) 1 1 1 INDEX RANGE SCAN I_ICOL1 (cr=3 pr=0 pw=0 time=398 us cost=1 size=0 card=2)(object id 42) ******************************************************************************** SQL ID: 83taa7kaw59c1 Plan Hash: 3765558045 select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2, nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182, scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$, rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2, nvl(spare3,0) from col$ where obj#=:1 order by intcol# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 41 0.00 0.00 0 5 0 40 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 43 0.00 0.00 0 5 0 40 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 40 40 40 SORT ORDER BY (cr=4 pr=0 pw=0 time=68 us cost=3 size=649 card=11) 40 40 40 TABLE ACCESS CLUSTER COL$ (cr=4 pr=0 pw=0 time=13 us cost=2 size=649 card=11) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=6 us cost=1 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: 9gkq7rruycsjp Plan Hash: 3362549386 select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=2 pr=0 pw=0 time=360 us cost=1 size=50 card=1) 1 1 1 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=1 pr=0 pw=0 time=111 us cost=0 size=0 card=1)(object id 565) ******************************************************************************** SQL ID: cbdfcfcp1pgtp Plan Hash: 142600749 select intcol#, col# , type#, spare1, segcol#, charsetform from partcol$ where obj# = :1 order by pos# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 4 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=2 pr=0 pw=0 time=204 us cost=3 size=24 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID PARTCOL$ (cr=2 pr=0 pw=0 time=193 us cost=2 size=24 card=1) 1 1 1 INDEX RANGE SCAN I_PARTCOL$ (cr=1 pr=0 pw=0 time=116 us cost=1 size=0 card=1)(object id 567) ******************************************************************************** SQL ID: 130dvvr5s8bgn Plan Hash: 1160622595 select obj#, dataobj#, part#, hiboundlen, hiboundval, ts#, file#, block#, pctfree$, pctused$, initrans, maxtrans, flags, analyzetime, samplesize, rowcnt, blkcnt, empcnt, avgspc, chncnt, avgrln, length(bhiboundval), bhiboundval from tabpart$ where bo# = :1 order by part# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.07 0.15 1 7525 0 6821 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.07 0.15 1 7525 0 6821 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 6821 6821 6821 TABLE ACCESS BY INDEX ROWID TABPART$ (cr=704 pr=1 pw=0 time=10785 us cost=14 size=62160 card=336) 6821 6821 6821 INDEX RANGE SCAN I_TABPART_BOPART$ (cr=30 pr=1 pw=0 time=1730 us cost=3 size=0 card=336)(object id 571) ******************************************************************************** SQL ID: 9tgj4g8y4rwy8 Plan Hash: 3755742892 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0), NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 0 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.00 0 20 0 5 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS CLUSTER SEG$ (cr=4 pr=0 pw=0 time=691 us cost=3 size=72 card=1) 1 1 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=3 pr=0 pw=0 time=475 us cost=2 size=0 card=1)(object id 9) ******************************************************************************** SQL ID: 3ktacv9r56b51 Plan Hash: 4184428695 select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT ORDER BY (cr=2 pr=0 pw=0 time=998 us cost=13 size=372 card=3) 0 0 0 NESTED LOOPS OUTER (cr=2 pr=0 pw=0 time=988 us cost=12 size=372 card=3) 0 0 0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=2 pr=0 pw=0 time=986 us cost=3 size=90 card=3) 0 0 0 INDEX RANGE SCAN I_DEPENDENCY1 (cr=2 pr=0 pw=0 time=985 us cost=2 size=0 card=3)(object id 106) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=94 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 36) ******************************************************************************** SQL ID: 8swypbbr0m372 Plan Hash: 893970548 select order#,columns,types from access$ where d_obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=2 pr=0 pw=0 time=874 us cost=3 size=190 card=5) 0 0 0 INDEX RANGE SCAN I_ACCESS1 (cr=2 pr=0 pw=0 time=873 us cost=2 size=0 card=5)(object id 108) ******************************************************************************** SQL ID: c3zymn7x3k6wy Plan Hash: 3446064519 select obj#, dataobj#, part#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, pctthres$, length(bhiboundval), bhiboundval from indpart$ where bo# = :1 order by part# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.06 0.14 0 7451 0 6821 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.06 0.14 0 7451 0 6821 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 6821 6821 6821 TABLE ACCESS BY INDEX ROWID INDPART$ (cr=630 pr=0 pw=0 time=128087 us cost=10 size=44528 card=242) 6821 6821 6821 INDEX RANGE SCAN I_INDPART_BOPART$ (cr=29 pr=0 pw=0 time=2005 us cost=2 size=0 card=242)(object id 576) ******************************************************************************** SQL ID: 6aq34nj2zb2n7 Plan Hash: 2874733959 select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT GROUP BY (cr=2 pr=0 pw=0 time=616 us cost=4 size=16 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=0 pw=0 time=603 us cost=3 size=16 card=1) 0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=602 us cost=2 size=0 card=1)(object id 62) ******************************************************************************** SQL ID: 2q93zsrvbdw48 Plan Hash: 2874733959 select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 6 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.00 0 6 0 7 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 7 7 7 SORT GROUP BY (cr=6 pr=0 pw=0 time=586 us cost=4 size=32 card=2) 7 7 7 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=6 pr=0 pw=0 time=200 us cost=3 size=32 card=2) 7 7 7 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=14 us cost=2 size=0 card=2)(object id 62) ******************************************************************************** SQL ID: 3w4qs0tbpmxr6 Plan Hash: 1224215794 select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3 from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=3 pr=0 pw=0 time=569 us cost=2 size=102 card=3) 1 1 1 INDEX RANGE SCAN I_CDEF3 (cr=2 pr=0 pw=0 time=14 us cost=1 size=0 card=1)(object id 55) ******************************************************************************** SQL ID: gx4mv66pvj3xz Plan Hash: 1932954096 select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0),spare2,spare3 from cdef$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 0 10 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 10 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 4 4 4 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=10 pr=0 pw=0 time=17 us cost=2 size=156 card=3) 4 4 4 INDEX RANGE SCAN I_CDEF2 (cr=6 pr=0 pw=0 time=24 us cost=1 size=0 card=3)(object id 54) ******************************************************************************** SQL ID: 53saa2zkr6wc3 Plan Hash: 3954488388 select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.00 0 16 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID CCOL$ (cr=4 pr=0 pw=0 time=301 us cost=3 size=17 card=1) 1 1 1 INDEX RANGE SCAN I_CCOL1 (cr=3 pr=0 pw=0 time=298 us cost=2 size=0 card=1)(object id 57) ******************************************************************************** SQL ID: dbmdavb6ydwb4 Plan Hash: 0 ALTER SESSION SET SQL_TRACE=FALSE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 6.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 6.02 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 11.62 0 0 0 0 Execute 3 0.44 0.44 0 0 0 0 Fetch 1 661.91 701.28 1672046 310701053 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 662.36 713.36 1672046 310701053 0 0 Misses in library cache during parse: 2 Misses in library cache during execute: 2 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 23 0.00 0.00 0 0 0 0 Execute 36 0.01 0.01 0 0 0 0 Fetch 113 0.16 0.33 3 15127 0 13730 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 172 0.18 0.35 3 15127 0 13730 Misses in library cache during parse: 17 Misses in library cache during execute: 17 3 user SQL statements in session. 21 internal SQL statements in session. 24 SQL statements in session. ******************************************************************************** Trace file: INDIGO_WS1_ora_26942.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 3 user SQL statements in trace file. 21 internal SQL statements in trace file. 24 SQL statements in trace file. 20 unique SQL statements in trace file. 440 lines in trace file. 773 elapsed seconds in trace file.