TKPROF: Release 11.2.0.3.0 - Development on Tue Apr 1 10:38:12 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: TEST_ora_40298.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.01 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.01 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 ******************************************************************************** SQL ID: 3nkd3g3ju5ph1 Plan Hash: 2853959010 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 229 0.00 0.00 0 0 0 0 Fetch 229 0.00 0.05 49 916 0 229 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 458 0.01 0.05 49 916 0 229 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: 1mjd9xp80vuqa Plan Hash: 3023518864 select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 26 0.00 0.00 0 0 0 0 Fetch 26 0.00 0.00 10 78 0 26 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 52 0.00 0.00 10 78 0 26 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 38 0.00 0.01 0 0 0 0 Execute 38 0.00 0.03 0 0 0 0 Fetch 196 0.00 0.04 84 669 0 158 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 272 0.01 0.08 84 669 0 158 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=8 pr=1 pw=0 time=3634 us cost=20 size=380 card=5) 1 1 1 NESTED LOOPS OUTER (cr=8 pr=1 pw=0 time=3618 us cost=19 size=380 card=5) 1 1 1 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=4 pr=1 pw=0 time=3582 us cost=4 size=155 card=5) 1 1 1 INDEX RANGE SCAN I_DEPENDENCY1 (cr=3 pr=0 pw=0 time=2750 us cost=3 size=0 card=5)(object id 127) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=32 us cost=3 size=45 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=27 us cost=2 size=0 card=1)(object id 2513190) ******************************************************************************** SQL ID: 4kt3cun8s5fp5 Plan Hash: 2709293936 select name,password,datats#,tempts#,type#,defrole,resource$, ptime, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4, ext_username,spare2 from user$ where user#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 2 12 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 2 12 0 6 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS CLUSTER USER$ (cr=2 pr=0 pw=0 time=22 us cost=1 size=96 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=7 us cost=0 size=0 card=1)(object id 11) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 31 0.00 0.00 0 0 0 0 Fetch 31 0.00 0.00 73 203 0 31 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 62 0.00 0.00 73 203 0 31 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: 7ng34ruy5awxq Plan Hash: 2542797530 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 34 0.00 0.00 0 0 0 0 Fetch 198 0.01 0.07 66 330 0 164 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 233 0.02 0.07 66 330 0 164 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 164 0.00 0.00 0 0 0 0 Fetch 415 0.00 0.04 26 994 0 251 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 580 0.01 0.05 26 994 0 251 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 BY INDEX ROWID ICOL$ (cr=5 pr=1 pw=0 time=8399 us cost=2 size=58 card=2) 1 1 1 INDEX RANGE SCAN I_ICOL1 (cr=4 pr=1 pw=0 time=8398 us cost=1 size=0 card=2)(object id 40) ******************************************************************************** SQL ID: 96g93hntrzjtr Plan Hash: 2239883476 select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 196 0.00 0.00 0 0 0 0 Fetch 196 0.00 0.03 65 788 0 195 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 392 0.01 0.03 65 788 0 195 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 37 0.00 0.00 0 0 0 0 Fetch 2488 0.03 0.02 7 205 0 2451 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2525 0.03 0.02 7 205 0 2451 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: 87gaftwrm2h68 Plan Hash: 1218588913 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 161 0.00 0.00 0 0 0 0 Fetch 161 0.00 0.00 17 644 0 161 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 323 0.01 0.00 17 644 0 161 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 BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=31 us cost=4 size=41 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=29 us cost=3 size=0 card=1)(object id 2513190) ******************************************************************************** SQL ID: bd4bznqbq73hk Plan Hash: 2595917966 select bo#, intcol# from icoldep$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 2 12 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.00 2 12 0 3 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 ICOLDEP$ (cr=4 pr=1 pw=0 time=4095 us cost=2 size=90 card=6) 1 1 1 INDEX RANGE SCAN I_ICOLDEP$_OBJ (cr=3 pr=1 pw=0 time=4092 us cost=1 size=0 card=6)(object id 368) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 180 0.00 0.00 0 0 0 0 Fetch 180 0.00 0.06 80 720 0 180 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 360 0.01 0.07 80 720 0 180 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 38 0.00 0.00 0 0 0 0 Execute 38 0.00 0.00 0 0 0 0 Fetch 155 0.00 0.02 19 348 0 117 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 231 0.00 0.02 19 348 0 117 Misses in library cache during parse: 2 Misses in library cache during execute: 2 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=3 pr=0 pw=0 time=12 us cost=4 size=189 card=7) 0 0 0 INDEX RANGE SCAN I_ACCESS1 (cr=3 pr=0 pw=0 time=11 us cost=3 size=0 card=7)(object id 129) ******************************************************************************** SQL ID: g3wrkmxkxzhf2 Plan Hash: 749386351 select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 4 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 4 6 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: grwydz59pu6mc Plan Hash: 3684871272 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 1 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 1 6 0 3 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=23 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: 2tkw12w5k68vd Plan Hash: 1457651150 select user#,password,datats#,tempts#,type#,defrole,resource$, ptime, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4, ext_username,spare2 from user$ where name=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 12 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 12 0 6 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=12 us cost=1 size=96 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=7 us cost=0 size=0 card=1)(object id 2513196) ******************************************************************************** SQL ID: ga9j9xk5cy9s0 Plan Hash: 1697022209 select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#,length,piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 13 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 29 0.00 0.00 23 87 0 16 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 55 0.00 0.00 23 87 0 16 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ (cr=6 pr=2 pw=0 time=112 us cost=4 size=19 card=1) 2 2 2 INDEX RANGE SCAN I_IDL_SB41 (cr=5 pr=1 pw=0 time=61 us cost=3 size=0 card=1)(object id 123) ******************************************************************************** SQL ID: cvn54b7yz0s8u Plan Hash: 3246118364 select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#,length,piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 13 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 38 0.00 0.00 50 148 0 35 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 64 0.00 0.00 50 148 0 35 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 2 TABLE ACCESS BY INDEX ROWID IDL_UB1$ (cr=5 pr=2 pw=0 time=98 us cost=4 size=22 card=1) 1 1 2 INDEX RANGE SCAN I_IDL_UB11 (cr=4 pr=1 pw=0 time=46 us cost=3 size=0 card=1)(object id 120) ******************************************************************************** SQL ID: c6awqs517jpj0 Plan Hash: 1319326155 select /*+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 13 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 16 0.00 0.00 13 48 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.00 0.00 13 48 0 3 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ (cr=4 pr=1 pw=0 time=73 us cost=4 size=21 card=1) 1 1 1 INDEX RANGE SCAN I_IDL_CHAR1 (cr=4 pr=1 pw=0 time=38 us cost=3 size=0 card=1)(object id 121) ******************************************************************************** SQL ID: 39m4sx9k63ba2 Plan Hash: 2317816222 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 13 0.00 0.00 0 0 0 0 Execute 13 0.00 0.00 0 0 0 0 Fetch 18 0.00 0.00 19 62 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 44 0.00 0.01 19 62 0 8 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 2 3 TABLE ACCESS BY INDEX ROWID IDL_UB2$ (cr=6 pr=2 pw=0 time=114 us cost=4 size=21 card=1) 3 2 3 INDEX RANGE SCAN I_IDL_UB21 (cr=4 pr=1 pw=0 time=45 us cost=3 size=0 card=1)(object id 122) ******************************************************************************** SQL ID: b1wc53ddd6h3p Plan Hash: 1637390370 select audit$,options from procedure$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 13 30 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 30 0.00 0.00 13 30 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ (cr=3 pr=2 pw=0 time=87 us cost=2 size=47 card=1) 1 1 1 INDEX UNIQUE SCAN I_PROCEDURE1 (cr=2 pr=1 pw=0 time=48 us cost=1 size=0 card=1)(object id 115) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 29 0.00 0.00 0 0 0 0 Fetch 29 0.00 0.03 22 90 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 58 0.00 0.03 22 90 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 29 0.00 0.00 0 0 0 0 Fetch 404 0.00 0.02 31 158 0 375 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 433 0.00 0.02 31 158 0 375 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: 7nuw4xwrnuwxq Plan Hash: 1720483994 select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 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 8 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 8 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: 9rfqm06xmuwu0 Plan Hash: 832500465 select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 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 8 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 8 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: f3g84j69n0tjh Plan Hash: 2335623859 select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 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 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: 6qz82dptj0qr7 Plan Hash: 2819763574 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc 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 3 0.00 0.00 0 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 8 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: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 0 1 SORT ORDER BY (cr=4 pr=0 pw=0 time=24 us cost=3 size=106 card=2) 1 0 1 TABLE ACCESS CLUSTER LOB$ (cr=4 pr=0 pw=0 time=14 us cost=2 size=106 card=2) 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: 9g485acn2n30m Plan Hash: 2544153582 select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 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 8 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 8 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: 32bhha21dkv0v Plan Hash: 3765558045 select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 91 0.00 0.00 0 8 0 89 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 93 0.00 0.00 0 8 0 89 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: 0fr8zhn4ymu3v Plan Hash: 1231101765 select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 30 0.00 0.00 0 0 0 0 Fetch 201 0.00 0.00 23 402 0 171 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 231 0.00 0.01 23 402 0 171 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SQL ID: gx4mv66pvj3xz Plan Hash: 2570921597 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 0 0.00 0.00 0 0 0 0 Execute 30 0.00 0.00 0 0 0 0 Fetch 364 0.00 0.01 4 444 0 334 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 394 0.00 0.01 4 444 0 334 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 334 0.00 0.00 0 0 0 0 Fetch 676 0.00 0.02 21 1725 0 342 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1010 0.01 0.02 21 1725 0 342 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 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 1 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 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 PARTOBJ$ (cr=2 pr=1 pw=0 time=80 us cost=1 size=55 card=1) 0 0 0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=2 pr=1 pw=0 time=76 us cost=0 size=0 card=1)(object id 227) ******************************************************************************** SQL ID: 2syvqzbxp4k9z Plan Hash: 1423211129 select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 16 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 0.00 0.00 0 16 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=53 us cost=6 size=60 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=50 us cost=5 size=49 card=1) 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=49 us cost=2 size=17 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=32 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 2513190) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=11 card=1) 0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11) ******************************************************************************** SQL ID: 2xyb5d6xg9srh Plan Hash: 785096182 select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 16 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=20 us cost=2 size=13 card=1) ******************************************************************************** SQL ID: db78fxqxwxt7r Plan Hash: 3312420081 select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 41 0.00 0.00 0 0 0 0 Fetch 41 0.00 0.00 7 123 0 758 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 82 0.00 0.00 7 123 0 758 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** SELECT /*+ hint index(element.print_order) */ distinct xpd.drop_id, xpd.drop_number, xpdcr.element_name, xpdcr.actual_value, nvl(MLN.PARENT_LOT_NUMBER, 0) PARENT_LOT, nvl(WDD.LOT_NUMBER, 0) CHILD_LOT1, nvl(WDD.SHIPPED_QUANTITY2,0) SEC_UOM_PC, nvl(WDD.NET_WEIGHT, 0) NET_WEIGHT, nvl(WND.GROSS_WEIGHT, 0) GROSS_WEIGHT, WDD.WEIGHT_UOM_CODE NET_GROSS_UOM, mdev.element_value Alloy_no, ooha.order_number, ooha.header_id, ooha.sold_to_org_id, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER, ship_cas.party_site_id, xpd.plant_code, element.print_order FROM MTL_SYSTEM_ITEMS_B MSIB, WSH_NEW_DELIVERIES WND, WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA, OE_ORDER_LINES_ALL OOLA, OE_ORDER_HEADERS_ALL OOHA, hz_cust_accounts cust_acct, hz_cust_site_uses_all ship_su, hz_cust_acct_sites_all ship_cas, MTL_LOT_NUMBERS MLN, MTL_DESCR_ELEMENT_VALUES MDEV, -- HR_ORGANIZATION_UNITS hou, -- hr_locations_all hla, org_organization_definitions ood, xxgmd_pm_drops xpd, xxgmd_pm_drop_chem_results xpdcr, xxgmd_pm_cspecs cspec, xxgmd_pm_cspec_elements cspec_el, xxgmd_pm_cspec_element_rules cspec_rule, xxgmd_pm_elements element WHERE 1 = 1 AND WND.DELIVERY_ID = WDA.DELIVERY_ID AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID AND WDD.SOURCE_LINE_ID = OOLA.LINE_ID AND OOLA.HEADER_ID = OOHA.HEADER_ID AND MSIB.INVENTORY_ITEM_ID = OOLA.INVENTORY_ITEM_ID AND MSIB.ORGANIZATION_ID(+) = WDD.ORGANIZATION_ID and msib.inventory_item_id = mdev.inventory_item_id -- AND HOU.LOCATION_ID = HLA.LOCATION_ID(+) AND OOHA.SHIP_FROM_ORG_ID = OOD.ORGANIZATION_ID -- AND OOD.OPERATING_UNIT = HOU.ORGANIZATION_ID AND OOHA.sold_to_org_id = cust_acct.cust_account_id(+) AND MLN.LOT_NUMBER(+) = WDD.LOT_NUMBER AND mln.inventory_item_id(+) = wdd.inventory_item_id --Added on 26-Nov-12 from offshore and mdev.element_name = 'C-ALLOY' and xpd.drop_number = MLN.PARENT_LOT_NUMBER AND xpd.plant_code = ood.organization_code AND xpd.drop_id = xpdcr.drop_id AND wnd.DELIVERY_ID = 189373--199369--704404--:P_DELIVERY_ID -- AND ship_cas.cust_account_id = ooha.sold_to_org_id AND ship_cas.cust_acct_site_id = ship_su.cust_acct_site_id AND ooha.deliver_to_org_id = ship_su.site_use_id AND cspec.cspec_name = mdev.element_value AND cspec.cspec_id = cspec_el.cspec_id AND cspec_rule.cspec_element_id = cspec_el.cspec_element_id and cspec_rule.party_site_id = ship_cas.party_site_id and cspec_rule.print_element = 'Y' and cspec_el.element_id = element.element_id and upper(element.element_name) = upper(xpdcr.element_name) and upper(xpdcr.element_name) <> 'AL' AND SYSDATE BETWEEN cspec.effective_start_date AND NVL (cspec.effective_end_date,SYSDATE + 500 ) order by element.print_order call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.64 0.69 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 25 2.38 33.41 16329 41125 0 360 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 3.03 34.10 16329 41125 0 360 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 360 360 360 SORT UNIQUE (cr=44366 pr=16632 pw=0 time=33707446 us cost=106 size=356 card=1) 360 360 360 NESTED LOOPS (cr=44366 pr=16632 pw=0 time=14092538 us) 360 360 360 NESTED LOOPS (cr=44006 pr=16632 pw=0 time=14089644 us cost=105 size=356 card=1) 360 360 360 NESTED LOOPS (cr=44002 pr=16631 pw=0 time=14086350 us cost=104 size=348 card=1) 360 360 360 NESTED LOOPS (cr=43993 pr=16629 pw=0 time=14077591 us cost=102 size=324 card=1) 360 360 360 NESTED LOOPS (cr=43984 pr=16626 pw=0 time=14037517 us cost=100 size=308 card=1) 480 480 480 NESTED LOOPS (cr=43620 pr=16624 pw=0 time=14014660 us cost=99 size=297 card=1) 504 504 504 NESTED LOOPS (cr=43112 pr=16622 pw=0 time=14001585 us cost=98 size=285 card=1) 24 24 24 NESTED LOOPS (cr=43105 pr=16620 pw=0 time=14446583 us cost=93 size=273 card=1) 24 24 24 NESTED LOOPS (cr=43098 pr=16618 pw=0 time=14428464 us cost=91 size=253 card=1) 48 48 48 NESTED LOOPS (cr=43024 pr=16614 pw=0 time=14151624 us cost=90 size=235 card=1) 24 24 24 NESTED LOOPS (cr=42954 pr=16606 pw=0 time=13929852 us cost=86 size=206 card=1) 24 24 24 NESTED LOOPS (cr=42901 pr=16603 pw=0 time=13910732 us cost=85 size=185 card=1) 24 24 24 NESTED LOOPS OUTER (cr=42867 pr=16600 pw=0 time=13907908 us cost=84 size=176 card=1) 24 24 24 NESTED LOOPS (cr=42819 pr=16598 pw=0 time=13907525 us cost=83 size=166 card=1) 24 24 24 NESTED LOOPS (cr=42788 pr=16596 pw=0 time=13907136 us cost=82 size=157 card=1) 24 24 24 HASH JOIN (cr=42743 pr=16594 pw=0 time=13906583 us cost=81 size=149 card=1) 24 24 24 TABLE ACCESS BY INDEX ROWID WSH_DELIVERY_ASSIGNMENTS (cr=5 pr=5 pw=0 time=38921 us cost=4 size=420 card=42) 24 24 24 INDEX RANGE SCAN WSH_DELIVERY_ASSIGNMENTS_N1 (cr=4 pr=4 pw=0 time=23191 us cost=3 size=0 card=42)(object id 71022) 182534 182534 182534 NESTED LOOPS (cr=42738 pr=16589 pw=0 time=40242701 us) 182534 182534 182534 NESTED LOOPS (cr=22221 pr=2704 pw=0 time=9440725 us cost=77 size=18348 card=132) 7609 7609 7609 NESTED LOOPS (cr=6194 pr=1888 pw=0 time=3502888 us cost=55 size=388 card=4) 31 31 31 HASH JOIN (cr=3628 pr=443 pw=0 time=429933 us cost=49 size=82 card=1) 46 46 46 NESTED LOOPS (cr=3553 pr=369 pw=0 time=399230 us) 46 46 46 NESTED LOOPS (cr=3507 pr=363 pw=0 time=398775 us cost=27 size=61 card=1) 47 47 47 HASH JOIN (cr=3503 pr=362 pw=0 time=398181 us cost=26 size=106 card=2) 811 811 811 NESTED LOOPS (cr=3487 pr=346 pw=0 time=401692 us) 811 811 811 NESTED LOOPS (cr=3100 pr=285 pw=0 time=353275 us cost=16 size=200 card=8) 811 811 811 NESTED LOOPS (cr=3084 pr=282 pw=0 time=347107 us cost=8 size=136 card=8) 1 1 1 TABLE ACCESS BY INDEX ROWID WSH_NEW_DELIVERIES (cr=3 pr=3 pw=0 time=24732 us cost=2 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN WSH_NEW_DELIVERIES_U1 (cr=2 pr=2 pw=0 time=12518 us cost=1 size=0 card=1)(object id 71176) 811 811 811 INDEX SKIP SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=3081 pr=279 pw=0 time=321448 us cost=6 size=56 card=8)(object id 40173) 811 811 811 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=16 pr=3 pw=0 time=3021 us cost=0 size=0 card=1)(object id 40169) 811 811 811 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS (cr=387 pr=61 pw=0 time=47718 us cost=1 size=8 card=1) 47 47 47 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=16 pr=16 pw=0 time=179 us cost=9 size=504 card=18) 47 47 47 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_IX1 (cr=2 pr=2 pw=0 time=111 us cost=1 size=0 card=47)(object id 40574) 46 46 46 INDEX UNIQUE SCAN MTL_PARAMETERS_U1 (cr=4 pr=1 pw=0 time=264 us cost=0 size=0 card=1)(object id 54818) 46 46 46 TABLE ACCESS BY INDEX ROWID MTL_PARAMETERS (cr=46 pr=6 pw=0 time=424 us cost=1 size=8 card=1) 31 31 31 TABLE ACCESS FULL OE_ORDER_HEADERS_ALL (cr=75 pr=74 pw=0 time=27535 us cost=22 size=651 card=31) 7609 7609 7609 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (cr=2566 pr=1445 pw=0 time=4016379 us cost=6 size=180 card=12) 7609 7609 7609 INDEX RANGE SCAN OE_ORDER_LINES_N1 (cr=55 pr=28 pw=0 time=61528 us cost=1 size=0 card=12)(object id 70557) 182534 182534 182534 INDEX RANGE SCAN WSH_DELIVERY_DETAILS_N3 (cr=16027 pr=816 pw=0 time=2753402 us cost=2 size=0 card=41)(object id 71030) 182534 182534 182534 TABLE ACCESS BY INDEX ROWID WSH_DELIVERY_DETAILS (cr=20517 pr=13885 pw=0 time=27595345 us cost=6 size=1428 card=34) 24 24 24 TABLE ACCESS BY INDEX ROWID HZ_CUST_SITE_USES_ALL (cr=45 pr=2 pw=0 time=359 us cost=1 size=8 card=1) 24 24 24 INDEX UNIQUE SCAN HZ_CUST_SITE_USES_U1 (cr=21 pr=1 pw=0 time=206 us cost=0 size=0 card=1)(object id 50470) 24 24 24 TABLE ACCESS BY INDEX ROWID HZ_CUST_ACCT_SITES_ALL (cr=31 pr=2 pw=0 time=247 us cost=1 size=9 card=1) 24 24 24 INDEX UNIQUE SCAN HZ_CUST_ACCT_SITES_U1 (cr=7 pr=1 pw=0 time=117 us cost=0 size=0 card=1)(object id 50441) 24 24 24 TABLE ACCESS BY INDEX ROWID HZ_CUST_ACCOUNTS (cr=48 pr=2 pw=0 time=287 us cost=1 size=10 card=1) 24 24 24 INDEX UNIQUE SCAN HZ_CUST_ACCOUNTS_U1 (cr=24 pr=1 pw=0 time=142 us cost=0 size=0 card=1)(object id 50412) 24 24 24 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (cr=34 pr=3 pw=0 time=2685 us cost=1 size=9 card=1)(object id 54986) 24 24 24 TABLE ACCESS BY INDEX ROWID MTL_DESCR_ELEMENT_VALUES (cr=53 pr=3 pw=0 time=19021 us cost=1 size=21 card=1) 24 24 24 INDEX UNIQUE SCAN MTL_DESCR_ELEMENT_VALUES_U1 (cr=29 pr=2 pw=0 time=3341 us cost=0 size=0 card=1)(object id 54560) 48 48 48 TABLE ACCESS BY INDEX ROWID MTL_LOT_NUMBERS (cr=70 pr=8 pw=0 time=45750 us cost=4 size=29 card=1) 48 48 48 INDEX RANGE SCAN MTL_LOT_NUMBERS_N1 (cr=22 pr=4 pw=0 time=32215 us cost=2 size=0 card=2)(object id 54704) 24 24 24 TABLE ACCESS BY INDEX ROWID XXGMD_PM_DROPS (cr=74 pr=4 pw=0 time=20242 us cost=1 size=18 card=1) 24 24 24 INDEX UNIQUE SCAN XXGMD_PM_DRP_UK (cr=50 pr=3 pw=0 time=10822 us cost=0 size=0 card=1)(object id 2611394) 24 24 24 TABLE ACCESS BY INDEX ROWID XXGMD_PM_CSPECS (cr=7 pr=2 pw=0 time=17623 us cost=2 size=20 card=1) 24 24 24 INDEX RANGE SCAN XXGMD_PM_CSP_UK (cr=6 pr=1 pw=0 time=9518 us cost=1 size=0 card=1)(object id 2611379) 504 504 504 TABLE ACCESS BY INDEX ROWID XXGMD_PM_CSPEC_ELEMENTS (cr=7 pr=2 pw=0 time=10226 us cost=5 size=240 card=20) 504 504 504 INDEX RANGE SCAN XXGMD_PM_CSE_UK (cr=6 pr=1 pw=0 time=8498 us cost=1 size=0 card=20)(object id 2611388) 480 480 480 TABLE ACCESS BY INDEX ROWID XXGMD_PM_ELEMENTS (cr=508 pr=2 pw=0 time=12416 us cost=1 size=12 card=1) 504 504 504 INDEX UNIQUE SCAN XXGMD_PM_ELM_PK (cr=4 pr=1 pw=0 time=4652 us cost=0 size=0 card=1)(object id 2611382) 360 360 360 TABLE ACCESS BY INDEX ROWID XXGMD_PM_CSPEC_ELEMENT_RULES (cr=364 pr=2 pw=0 time=22590 us cost=1 size=11 card=1) 360 360 360 INDEX UNIQUE SCAN XXGMD_PM_CSR_UK (cr=4 pr=1 pw=0 time=6127 us cost=0 size=0 card=1)(object id 2611418) 360 360 360 TABLE ACCESS BY INDEX ROWID XXGMD_PM_DROP_CHEM_RESULTS (cr=9 pr=3 pw=0 time=39523 us cost=2 size=16 card=1) 360 360 360 INDEX RANGE SCAN XXGMD_PM_DCR_UK (cr=8 pr=2 pw=0 time=23150 us cost=1 size=0 card=1)(object id 2611398) 360 360 360 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=9 pr=2 pw=0 time=4997 us cost=2 size=24 card=1) 360 360 360 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=8 pr=2 pw=0 time=2233 us cost=1 size=0 card=1)(object id 298291) 360 360 360 INDEX UNIQUE SCAN GL_LEDGERS_U2 (cr=4 pr=1 pw=0 time=1511 us cost=0 size=0 card=1)(object id 2528940) 360 360 360 TABLE ACCESS BY INDEX ROWID GL_LEDGERS (cr=360 pr=0 pw=0 time=2008 us cost=1 size=8 card=1) ******************************************************************************** SQL ID: dcstr36r0vz0d Plan Hash: 3798950322 select procedure#,procedurename,properties,itypeobj# from procedureinfo$ where obj#=:1 order by procedurename desc, overload# desc 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 25 0.00 0.00 6 52 0 23 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29 0.00 0.00 6 52 0 23 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 ---------- ---------- ---------- --------------------------------------------------- 23 12 23 TABLE ACCESS BY INDEX ROWID PROCEDUREINFO$ (cr=26 pr=3 pw=0 time=85 us cost=5 size=204 card=6) 23 12 23 INDEX RANGE SCAN DESCENDING I_PROCEDUREINFO1 (cr=14 pr=2 pw=0 time=99 us cost=3 size=0 card=6)(object id 116) ******************************************************************************** SQL ID: 32hbap2vtmf53 Plan Hash: 3421168214 select position#,sequence#,level#,argument,type#,charsetid,charsetform, properties,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,type_name,type_subname,type_linkname,pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 23 0.00 0.00 0 0 0 0 Fetch 64 0.00 0.00 5 151 0 41 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 88 0.00 0.00 5 151 0 41 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 ARGUMENT$ (cr=5 pr=3 pw=0 time=134 us cost=4 size=83 card=1) 1 1 1 INDEX RANGE SCAN DESCENDING I_ARGUMENT2 (cr=4 pr=2 pw=0 time=104 us cost=3 size=0 card=1)(object id 118) ******************************************************************************** SQL ID: 8wutkrpf8j81q Plan Hash: 1011998884 select max(procedure#) from procedurec$ 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 SORT AGGREGATE (cr=2 pr=0 pw=0 time=26 us) 0 0 0 FIRST ROW (cr=2 pr=0 pw=0 time=22 us cost=2 size=9 card=1) 0 0 0 INDEX RANGE SCAN (MIN/MAX) I_PROCEDUREC$ (cr=2 pr=0 pw=0 time=18 us cost=2 size=9 card=1)(object id 317) ******************************************************************************** SQL ID: 2xgubd6ayhyb1 Plan Hash: 3418045132 select max(procedure#) from procedureplsql$ 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 2 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 2 6 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 AGGREGATE (cr=3 pr=1 pw=0 time=56 us) 0 0 1 FIRST ROW (cr=3 pr=1 pw=0 time=52 us cost=2 size=9 card=1) 0 0 1 INDEX RANGE SCAN (MIN/MAX) I_PROCEDUREPLSQL$ (cr=3 pr=1 pw=0 time=51 us cost=2 size=9 card=1)(object id 319295) ******************************************************************************** SQL ID: 5km6gkvuh3n43 Plan Hash: 2075413643 select max(procedure#) from procedurejava$ 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 1 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 1 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 AGGREGATE (cr=2 pr=0 pw=0 time=34 us) 0 0 0 FIRST ROW (cr=2 pr=0 pw=0 time=28 us cost=2 size=10 card=1) 0 0 0 INDEX RANGE SCAN (MIN/MAX) I_PROCEDUREJAVA$ (cr=2 pr=0 pw=0 time=28 us cost=2 size=10 card=1)(object id 315) ******************************************************************************** SQL ID: 971vpk0tp7ahm Plan Hash: 726556434 select procedure#,entrypoint# from procedurec$ where obj#=:1 order by procedure# 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 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: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID PROCEDUREC$ (cr=2 pr=0 pw=0 time=10 us cost=3 size=77 card=7) 0 0 0 INDEX RANGE SCAN I_PROCEDUREC$ (cr=2 pr=0 pw=0 time=8 us cost=2 size=0 card=7)(object id 317) ******************************************************************************** SQL ID: bgjhtnqhr5u9h Plan Hash: 4040384485 select procedure#,entrypoint# from procedureplsql$ where obj#=:1 order by procedure# 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 24 0.00 0.00 2 50 0 22 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 28 0.00 0.00 2 50 0 22 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 ---------- ---------- ---------- --------------------------------------------------- 0 11 22 TABLE ACCESS BY INDEX ROWID PROCEDUREPLSQL$ (cr=25 pr=1 pw=0 time=24 us cost=3 size=55 card=5) 0 11 22 INDEX RANGE SCAN I_PROCEDUREPLSQL$ (cr=14 pr=0 pw=0 time=38 us cost=2 size=0 card=5)(object id 319295) ******************************************************************************** SQL ID: 5j4c2v06qdhqq Plan Hash: 423935871 select procedure#,ownerlength,classlength,methodlength,siglength, flagslength, cookiesize from procedurejava$ where obj#=:1 order by procedure# 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 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: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID PROCEDUREJAVA$ (cr=2 pr=0 pw=0 time=8 us cost=4 size=300 card=10) 0 0 0 INDEX RANGE SCAN I_PROCEDUREJAVA$ (cr=2 pr=0 pw=0 time=6 us cost=2 size=0 card=10)(object id 315) ******************************************************************************** SQL ID: 83cq1aqjw5gmg Plan Hash: 0 select ownername,classname,methodname,signature,flags from procedurejava$ where obj#=:1 and procedure#=:2 order by procedure# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 32hbap2vtmf53 Plan Hash: 0 select position#,sequence#,level#,argument,type#,charsetid,charsetform, properties,nvl(length, 0), nvl(precision#, 0),nvl(scale, 0),nvl(radix, 0), type_owner,type_name,type_subname,type_linkname,pls_type from argument$ where obj#=:1 and procedure#=:2 order by sequence# desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 0 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 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 0q8w0cndsp865 Plan Hash: 3430698792 SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 2 5 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.03 2 5 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=5 pr=2 pw=0 time=15859 us cost=4 size=56 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=1 pw=0 time=6961 us cost=2 size=33 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U2 (cr=2 pr=0 pw=0 time=27 us cost=1 size=0 card=1)(object id 37709) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES (cr=2 pr=1 pw=0 time=8893 us cost=2 size=23 card=1) 0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=2 pr=1 pw=0 time=8846 us cost=1 size=0 card=1)(object id 291817) ******************************************************************************** SQL ID: bazquck2vuvm1 Plan Hash: 1353335585 SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ORDER BY PRODUCT_GROUP_ID 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 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 2 2 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=2 pr=2 pw=0 time=763 us cost=4 size=10 card=1) 1 1 1 TABLE ACCESS FULL FND_PRODUCT_GROUPS (cr=2 pr=2 pw=0 time=749 us cost=3 size=10 card=1) ******************************************************************************** SQL ID: 0wmwsjy9kd92f Plan Hash: 1319308958 SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE 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 9 15 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.01 9 15 0 5 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 (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 FND_PROFILE_OPTIONS (cr=3 pr=2 pw=0 time=103 us cost=2 size=69 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U2 (cr=2 pr=1 pw=0 time=60 us cost=1 size=0 card=1)(object id 37709) ******************************************************************************** SQL ID: 7qs7fx89194u1 Plan Hash: 509207570 SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL 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 7 12 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 0.00 7 12 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 (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 FND_PROFILE_OPTION_VALUES (cr=3 pr=2 pw=0 time=714 us cost=3 size=28 card=1) 1 1 1 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=2 pr=1 pw=0 time=52 us cost=2 size=0 card=1)(object id 291817) ******************************************************************************** SQL ID: aw7fu9a9bdyus Plan Hash: 1611973141 SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.01 0.01 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 2 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.02 0.02 2 4 0 2 Misses in library cache during parse: 2 Optimizer mode: ALL_ROWS Parsing user id: 178 (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 PER_SECURITY_PROFILES (cr=2 pr=1 pw=0 time=668 us cost=1 size=265 card=1) 1 1 1 INDEX UNIQUE SCAN PER_SECURITY_PROFILES_PK (cr=1 pr=0 pw=0 time=337 us cost=0 size=0 card=1)(object id 42749) ******************************************************************************** SQL ID: ftj9uawt4wwzb Plan Hash: 1884964958 select condition from cdef$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 26 0.00 0.00 0 0 0 0 Execute 26 0.00 0.00 0 0 0 0 Fetch 26 0.00 0.00 0 52 0 26 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 78 0.00 0.00 0 52 0 26 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: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID CDEF$ (cr=1 pr=0 pw=0 time=5 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: f2tzfzy3qw2bp Plan Hash: 959687402 SELECT DECODE(READ_ONLY_FLAG,'U', 'Y' ,'M', 'Y' ,'K', 'Y' ,'N') SCHEMA_MODE, DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1),' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1, 10)) FROM FND_ORACLE_USERID WHERE ORACLE_USERNAME = USER 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 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 2 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 (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 FND_ORACLE_USERID (cr=2 pr=2 pw=0 time=80 us cost=1 size=7 card=1) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U2 (cr=1 pr=1 pw=0 time=44 us cost=0 size=0 card=1)(object id 37647) ******************************************************************************** SQL ID: 22nharvcdzu2p Plan Hash: 4242499615 SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = :B2 AND LOOKUP_CODE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.02 0.02 0 0 0 0 Fetch 2 0.00 0.00 9 12 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.02 0.03 9 12 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=6 pr=5 pw=0 time=810 us) 1 1 1 NESTED LOOPS (cr=5 pr=4 pw=0 time=762 us cost=5 size=89 card=1) 1 1 1 VIEW VW_NSO_1 (cr=2 pr=1 pw=0 time=505 us cost=2 size=30 card=1) 1 1 1 HASH GROUP BY (cr=2 pr=1 pw=0 time=502 us cost=2 size=27 card=1) 1 1 1 INDEX RANGE SCAN FND_LOOKUP_TYPES_U1 (cr=2 pr=1 pw=0 time=137 us cost=2 size=54 card=2)(object id 37519) 1 1 1 INDEX UNIQUE SCAN FND_LOOKUP_VALUES_U1 (cr=3 pr=3 pw=0 time=253 us cost=1 size=0 card=1)(object id 37524) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=1 pr=1 pw=0 time=42 us cost=2 size=59 card=1) ******************************************************************************** SQL ID: dbmdavb6ydwb4 Plan Hash: 0 ALTER SESSION SET SQL_TRACE=FALSE 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 178 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.65 0.69 0 0 0 0 Execute 3 0.00 0.01 0 0 0 0 Fetch 25 2.38 33.41 16329 41125 0 360 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 30 3.04 34.12 16329 41125 0 360 Misses in library cache during parse: 2 Misses in library cache during execute: 1 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 228 0.06 0.06 0 0 0 0 Execute 1821 0.11 0.13 0 0 0 0 Fetch 6413 0.14 0.54 781 9719 0 6260 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8462 0.32 0.75 781 9719 0 6260 Misses in library cache during parse: 37 Misses in library cache during execute: 31 11 user SQL statements in session. 85 internal SQL statements in session. 96 SQL statements in session. ******************************************************************************** Trace file: TEST_ora_40298.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 11 user SQL statements in trace file. 85 internal SQL statements in trace file. 96 SQL statements in trace file. 57 unique SQL statements in trace file. 11036 lines in trace file. 363 elapsed seconds in trace file.