TKPROF: Release 8.1.7.4.0 - Production on Fri Jun 26 07:04:30 2009 (c) Copyright 2000 Oracle Corporation. All rights reserved. Trace file: cost_ora_8499_REDDYS_CR54518907.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 ******************************************************************************** alter session set events='10046 trace name context forever, level 8' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 4.93 0 0 0 0 Execute 2 100.00 25.35 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 100.00 30.28 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** 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 9 0.00 19.78 0 0 0 0 Execute 9 0.00 12.29 0 0 0 0 Fetch 25 200.00 1554.72 19 76 0 16 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 43 200.00 1586.79 19 76 0 16 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID IDL_SB4$ 2 INDEX RANGE SCAN I_IDL_SB41 (object id 103) ******************************************************************************** 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 9 0.00 19.22 0 0 0 0 Execute 9 0.00 10.00 0 0 0 0 Fetch 24 200.00 2292.87 31 82 0 17 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 200.00 2322.09 31 82 0 17 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID IDL_UB1$ 1 INDEX RANGE SCAN I_IDL_UB11 (object id 100) ******************************************************************************** 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 9 0.00 17.99 0 0 0 0 Execute 9 100.00 9.62 0 0 0 0 Fetch 16 100.00 927.53 18 49 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 34 200.00 955.14 18 49 0 7 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID IDL_CHAR$ 1 INDEX RANGE SCAN I_IDL_CHAR1 (object id 101) ******************************************************************************** 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 9 0.00 18.50 0 0 0 0 Execute 9 0.00 9.78 0 0 0 0 Fetch 20 300.00 1905.15 27 82 0 18 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 38 300.00 1933.43 27 82 0 18 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID IDL_UB2$ 2 INDEX RANGE SCAN I_IDL_UB21 (object id 102) ******************************************************************************** begin fnd_conc_stat.store_initial; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 200.00 124.32 0 0 0 0 Execute 2 800.00 1491.30 26 83 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 1000.00 1615.62 26 83 0 2 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 4 0.00 5.42 0 0 0 0 Fetch 4 0.00 12.00 3 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 17.42 3 12 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** 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 0 0.00 0.00 0 0 0 0 Execute 8 0.00 7.73 0 0 0 0 Fetch 8 0.00 7.13 1 18 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.00 14.86 1 18 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 2 0.00 1.73 0 0 0 0 Fetch 2 0.00 0.88 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 2.61 0 4 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** BEGIN PWR_WB_INV_TURNS_PKG.PWR_WB_MAIN(:errbuf,:rc,:A0,:A1); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 15.12 0 0 0 0 Execute 13121497.4428444674.75 77301122 1228690652 27384225 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23121497.4428444689.87 77301122 1228690652 27384225 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** select audit$,options from procedure$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 7.67 0 0 0 0 Execute 5 0.00 5.43 0 0 0 0 Fetch 5 0.00 849.89 10 15 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.00 862.99 10 15 0 5 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID PROCEDURE$ 1 INDEX UNIQUE SCAN I_PROCEDURE1 (object id 97) ******************************************************************************** select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname, o.dataobj#,o.flags from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 11 100.00 28.95 0 0 0 0 Execute 49 100.00 49.97 0 0 0 0 Fetch 49 100.00 1167.03 52 196 0 49 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 109 300.00 1245.95 52 196 0 49 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 12 0.00 13.92 0 0 0 0 Execute 12 0.00 18.46 0 0 0 0 Fetch 132 400.00 4931.47 110 436 0 120 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 156 400.00 4963.85 110 436 0 120 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY 1 NESTED LOOPS OUTER 1 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ 1 INDEX RANGE SCAN I_DEPENDENCY1 (object id 106) 1 TABLE ACCESS BY INDEX ROWID OBJ$ 1 INDEX UNIQUE SCAN I_OBJ1 (object id 31) ******************************************************************************** select order#,columns,types from access$ where d_obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 12 0.00 14.47 0 0 0 0 Execute 12 0.00 13.91 0 0 0 0 Fetch 72 400.00 2709.10 30 157 0 60 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 96 400.00 2737.48 30 157 0 60 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID ACCESS$ 0 INDEX RANGE SCAN I_ACCESS1 (object id 108) ******************************************************************************** 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 8 0.00 10.47 0 0 0 0 Execute 31 0.00 40.12 0 0 0 0 Fetch 31 200.00 2597.94 55 124 0 31 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 70 200.00 2648.53 55 124 0 31 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 4 TABLE ACCESS BY INDEX ROWID OBJ#(18) 4 INDEX RANGE SCAN OBJ#(32) (object id 32) ******************************************************************************** select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 9 0.00 8.46 0 0 0 0 Execute 14 0.00 18.70 0 0 0 0 Fetch 14 0.00 1450.90 33 42 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 37 0.00 1478.06 33 42 0 14 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ#(56) 1 INDEX UNIQUE SCAN OBJ#(88) (object id 88) ******************************************************************************** select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0), audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt, avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1), nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0) ,nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 100.00 10.67 0 0 0 0 Execute 25 0.00 32.14 0 0 0 0 Fetch 25 300.00 1623.85 64 99 0 25 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 60 400.00 1666.66 64 99 0 25 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER OBJ#(4) 1 INDEX UNIQUE SCAN OBJ#(3) (object id 3) ******************************************************************************** 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,spare2,spare6, decode(i.pctthres$,null, null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (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.bo#= :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 9 100.00 9.52 0 0 0 0 Execute 30 100.00 60.90 0 0 0 0 Fetch 170 1300.00 5381.67 120 260 0 140 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 209 1500.00 5452.09 120 260 0 140 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 HASH JOIN OUTER 2 TABLE ACCESS CLUSTER OBJ#(19) 1 INDEX UNIQUE SCAN OBJ#(3) (object id 3) 0 VIEW 0 SORT GROUP BY 0 TABLE ACCESS CLUSTER OBJ#(26) 1 INDEX UNIQUE SCAN OBJ#(25) (object id 25) ******************************************************************************** select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7 0.00 6.05 0 0 0 0 Execute 140 200.00 136.65 0 0 0 0 Fetch 370 500.00 3799.68 67 740 0 230 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 517 700.00 3942.38 67 740 0 230 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 4 TABLE ACCESS BY INDEX ROWID OBJ#(20) 4 INDEX RANGE SCAN OBJ#(35) (object id 35) ******************************************************************************** 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 5 0.00 4.17 0 0 0 0 Execute 37 200.00 63.30 0 0 0 0 Fetch 2408 1100.00 2687.61 36 208 0 2371 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2450 1300.00 2755.08 36 208 0 2371 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 444 SORT ORDER BY 444 TABLE ACCESS CLUSTER OBJ#(21) 8 INDEX UNIQUE SCAN OBJ#(3) (object id 3) ******************************************************************************** select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 7.39 0 0 0 0 Execute 25 0.00 26.92 0 0 0 0 Fetch 29 100.00 448.25 26 58 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 62 100.00 482.56 26 58 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID OBJ#(26) 0 INDEX RANGE SCAN OBJ#(47) (object id 47) ******************************************************************************** select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 7.06 0 0 0 0 Execute 25 0.00 26.71 0 0 0 0 Fetch 190 200.00 123.34 5 244 0 165 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 223 200.00 157.11 5 244 0 165 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS CLUSTER OBJ#(26) 1 INDEX UNIQUE SCAN OBJ#(25) (object id 25) ******************************************************************************** select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 9 0.00 6.35 0 0 0 0 Execute 165 200.00 135.55 0 0 0 0 Fetch 339 500.00 2438.52 40 843 0 174 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 513 700.00 2580.42 40 843 0 174 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID OBJ#(27) 2 INDEX RANGE SCAN OBJ#(49) (object id 49) ******************************************************************************** select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 34 100.00 29.55 0 0 0 0 Execute 34 0.00 40.63 0 0 0 0 Fetch 34 100.00 2260.85 60 102 0 34 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 102 200.00 2331.03 60 102 0 34 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER SEG$ 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (object id 9) ******************************************************************************** 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 7 0.00 6.67 0 0 0 0 Execute 19 0.00 31.37 0 0 0 0 Fetch 19 100.00 1743.12 35 57 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 45 100.00 1781.16 35 57 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY 0 TABLE ACCESS BY INDEX ROWID OBJ#(71) 0 INDEX RANGE SCAN OBJ#(90) (object id 90) ******************************************************************************** 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 7 0.00 5.94 0 0 0 0 Execute 19 0.00 26.41 0 0 0 0 Fetch 358 900.00 6925.73 76 191 0 339 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 384 900.00 6958.08 76 191 0 339 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 77 SORT GROUP BY 77 TABLE ACCESS BY INDEX ROWID OBJ#(71) 77 INDEX RANGE SCAN OBJ#(90) (object id 90) ******************************************************************************** select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# and bitand(property,16)=0 and bitand(property,8)=0 order by o.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 8.03 0 0 0 0 Execute 4 100.00 7.69 0 0 0 0 Fetch 4 0.00 20.28 6 8 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 100.00 36.00 6 8 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY 0 NESTED LOOPS 0 NESTED LOOPS 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ 0 INDEX RANGE SCAN I_TRIGGER1 (object id 109) 0 TABLE ACCESS BY INDEX ROWID OBJ$ 0 INDEX UNIQUE SCAN I_OBJ1 (object id 31) 0 TABLE ACCESS CLUSTER USER$ 0 INDEX UNIQUE SCAN I_USER# (object id 11) ******************************************************************************** DELETE FROM PWR_WB_INV_TURNS WHERE PROCESS_TYPE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 500.00 843.04 4 15 0 0 Execute 13672200.00 7164135.32 224206 150536 10040935 1206699 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23672700.00 7164978.36 224210 150551 10040935 1206699 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE 1206699 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** 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 10 0.00 10.53 0 0 0 0 Execute 311 700.00 299.75 0 0 0 0 Fetch 311 500.00 6009.42 103 1248 0 299 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 632 1200.00 6319.70 103 1248 0 299 Misses in library cache during parse: 0 Optimizer goal: RULE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ#(169) 1 INDEX RANGE SCAN OBJ#(171) (object id 171) ******************************************************************************** select file# from file$ where ts#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 782 1400.00 989.90 0 0 0 0 Execute 782 1900.00 1024.77 0 0 0 0 Fetch 10948 10600.00 11307.94 2126 17986 0 10166 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12512 13900.00 13322.61 2126 17986 0 10166 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 13 TABLE ACCESS FULL FILE$ ******************************************************************************** select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 56 0.00 43.78 0 0 0 0 Execute 56 100.00 58.68 0 0 0 0 Fetch 56 400.00 1126.30 30 112 0 56 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 168 500.00 1228.76 30 112 0 56 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID VIEW$ ******************************************************************************** select sumobj#, inline#, textspos, textlen, instance# from suminline$ where hashval=:1 order by inline# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 200.00 169.43 3 4 0 0 Execute 2 100.00 78.52 0 0 0 0 Fetch 2 0.00 14.68 4 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 300.00 262.63 7 8 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID SUMINLINE$ 63 INDEX FULL SCAN I_SUMINLINE$_2 (object id 2749827) ******************************************************************************** select distinct obj#,containerobj#,pflags,xpflags,mflags from sum$, suminline$ where sumobj#=obj# and inline#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 100.00 101.66 0 20 0 0 Execute 2 100.00 57.11 0 0 0 0 Fetch 2 0.00 1.79 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 200.00 160.56 0 22 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT UNIQUE 0 NESTED LOOPS 0 TABLE ACCESS BY INDEX ROWID SUMINLINE$ 0 INDEX RANGE SCAN I_SUMINLINE$_2 (object id 2749827) 0 TABLE ACCESS BY INDEX ROWID SUM$ 0 INDEX UNIQUE SCAN I_SUM$_1 (object id 258272) ******************************************************************************** select dimobj#, col# from dimattr$ where detailobj#=:1 union select dimobj#, col# from dimjoinkey$ where detailobj#=:1 union select dimobj#, col# from dimlevelkey$ where detailobj#=:1 order by 2, 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 27 0.00 28.24 0 0 0 0 Execute 27 0.00 45.34 0 0 0 0 Fetch 27 200.00 122.48 30 81 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 81 200.00 196.06 30 81 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT UNIQUE 0 UNION-ALL 0 TABLE ACCESS BY INDEX ROWID DIMATTR$ 0 INDEX RANGE SCAN I_DIMATTR$_2 (object id 258294) 0 TABLE ACCESS BY INDEX ROWID DIMJOINKEY$ 0 INDEX RANGE SCAN I_DIMJOINKEY$_2 (object id 258291) 0 TABLE ACCESS BY INDEX ROWID DIMLEVELKEY$ 0 INDEX RANGE SCAN I_DIMLEVELKEY$_2 (object id 258288) ******************************************************************************** select distinct obj#,containerobj#,pflags,xpflags,mflags from sum$, sumdetail$ where detailobj#=:1 and sumobj#=obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 27 100.00 18.39 0 0 0 0 Execute 27 0.00 31.06 0 0 0 0 Fetch 31 300.00 1029.44 33 69 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 85 400.00 1078.89 33 69 0 4 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT UNIQUE 0 NESTED LOOPS 0 TABLE ACCESS BY INDEX ROWID SUMDETAIL$ 0 INDEX RANGE SCAN I_SUMDETAIL$_2 (object id 258275) 0 TABLE ACCESS BY INDEX ROWID SUM$ 0 INDEX UNIQUE SCAN I_SUM$_1 (object id 258272) ******************************************************************************** select condition from cdef$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 16 0.00 11.17 0 0 0 0 Execute 16 0.00 13.27 0 0 0 0 Fetch 16 100.00 104.01 5 32 0 16 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 48 100.00 128.45 5 32 0 16 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID CDEF$ ******************************************************************************** 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 1 100.00 4.07 0 0 0 0 Execute 2 0.00 2.59 0 0 0 0 Fetch 2 0.00 79.10 3 6 0 36 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 100.00 85.76 3 6 0 36 Misses in library cache during parse: 0 Optimizer goal: RULE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 36 SORT ORDER BY 36 TABLE ACCESS CLUSTER OBJ#(167) 2 INDEX UNIQUE SCAN OBJ#(166) (object id 166) ******************************************************************************** SELECT MSI.INVENTORY_ITEM_ID INV_ITEM_ID, MSI.SEGMENT1 PART_NUMBER, MSI.ORGANIZATION_ID INV_ORG_ID, MP.ORGANIZATION_CODE INV_ORG_CODE, MSI.ITEM_TYPE ITEM_TYPE, MSI.INVENTORY_ITEM_STATUS_CODE ITEM_STATUS, PP.FULL_NAME BUYER,MC.SEGMENT1 ENG_DIVISION, NVL (MSI.STD_LOT_SIZE, 0) LOT_SIZE, NVL (MSI.FIXED_DAYS_SUPPLY, 0) FDS, NVL (MSI.MINIMUM_ORDER_QUANTITY, 0) MIN_ORD_QUAN, MSI.PLANNER_CODE PLANNER_CODE, ROUND (NVL (CIS.ITEM_COST, 0), 4) FROZEN_COST, SUM (CURR_DEMAND) CURR_DEMAND, SUM (OH_QTY) OH_QTY, SUM (PAST_USAGE) PAST_USAGE FROM MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP, PER_PEOPLE_V7 PP, CST_ITEM_COSTS CIS, MTL_ITEM_CATEGORIES MIC, MTL_CATEGORIES MC, ( SELECT MOQ.INVENTORY_ITEM_ID, MOQ.ORGANIZATION_ID, NVL (SUM (MOQ.TRANSACTION_QUANTITY), 0) OH_QTY, 0 PAST_USAGE, 0 CURR_DEMAND, 0 SFT_STK FROM MTL_ONHAND_QUANTITIES MOQ,MTL_SECONDARY_INVENTORIES MSI WHERE MOQ.SUBINVENTORY_CODE = MSI.SECONDARY_INVENTORY_NAME AND MOQ.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND ((NVL(MSI.DISABLE_DATE, SYSDATE +10) > SYSDATE) AND (MSI.ASSET_INVENTORY = 1 AND MSI.AVAILABILITY_TYPE = 1)) GROUP BY MOQ.INVENTORY_ITEM_ID, MOQ.ORGANIZATION_ID UNION SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, 0 OH_QTY, ABS (NVL (ROUND (SUM (MMT.TRANSACTION_QUANTITY), 0 ), 0 ) ) * 4 PAST_USAGE, 0 CURR_DEMAND, 0 SFT_STK FROM MTL_MATERIAL_TRANSACTIONS MMT WHERE MMT.TRANSACTION_TYPE_ID IN ( SELECT LOOKUP_CODE FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'PWR_MINMAX_TRANS_TYPE_ID' AND ENABLED_FLAG = 'Y') AND MMT.TRANSACTION_DATE BETWEEN ADD_MONTHS (TRUNC (SYSDATE), -3) AND TRUNC (SYSDATE) GROUP BY INVENTORY_ITEM_ID, ORGANIZATION_ID UNION SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, 0 OH_QTY, 0 PAST_USAGE, NVL (SUM (USING_REQUIREMENTS_QUANTITY), 0 ) * 4 CURR_DEMAND, 0 SFT_STK FROM MRP_GROSS_REQUIREMENTS WHERE COMPILE_DESIGNATOR = 'P1-MRP' AND USING_ASSEMBLY_DEMAND_DATE BETWEEN TRUNC (SYSDATE) AND ADD_MONTHS (TRUNC (SYSDATE), 3 ) GROUP BY INVENTORY_ITEM_ID, ORGANIZATION_ID) X WHERE MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MSI.BUYER_ID = PP.PERSON_ID(+) AND MSI.INVENTORY_ITEM_ID = X.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = X.ORGANIZATION_ID AND CIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND CIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CIS.COST_TYPE_ID = 1 AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIC.ORGANIZATION_ID = 86 AND MIC.CATEGORY_SET_ID = 65 AND MC.CATEGORY_ID = MIC.CATEGORY_ID GROUP BY MSI.INVENTORY_ITEM_ID, MSI.SEGMENT1, MSI.ORGANIZATION_ID, MP.ORGANIZATION_CODE, MSI.ITEM_TYPE, MSI.INVENTORY_ITEM_STATUS_CODE, PP.FULL_NAME, MC.SEGMENT1, NVL (MSI.STD_LOT_SIZE, 0), NVL (MSI.FIXED_DAYS_SUPPLY, 0), NVL (MSI.MINIMUM_ORDER_QUANTITY, 0), MSI.PLANNER_CODE, ROUND (NVL (CIS.ITEM_COST, 0), 4) ORDER BY 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 32500.00 42122.55 213 967 0 0 Execute 1 100.00 16.75 0 0 0 0 Fetch 802097477900.00 9827430.67 1674306 8832719 0 80208 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 802117510500.00 9869569.97 1674519 8833686 0 80208 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 80208 SORT GROUP BY 144639 HASH JOIN OUTER 144639 NESTED LOOPS 144669 NESTED LOOPS 144669 HASH JOIN 21 TABLE ACCESS FULL MTL_PARAMETERS 144669 HASH JOIN 12092 TABLE ACCESS FULL MTL_CATEGORIES_B 144669 HASH JOIN 312930 INDEX RANGE SCAN MTL_ITEM_CATEGORIES_U1 (object id 541812) 145438 HASH JOIN 145438 VIEW 145438 SORT UNIQUE 145438 UNION-ALL 74081 SORT GROUP BY 230145 TABLE ACCESS BY INDEX ROWID MTL_ONHAND_QUANTITIES_DETAIL 230461 NESTED LOOPS 315 TABLE ACCESS FULL MTL_SECONDARY_INVENTORIES 230145 INDEX RANGE SCAN MTL_ONHAND_QUANTITIES_N5 (object id 857067) 35803 SORT GROUP BY 678387 TABLE ACCESS BY INDEX ROWID MTL_MATERIAL_TRANSACTIONS 18352881 NESTED LOOPS 16 VIEW 16 SORT UNIQUE 16 FILTER 16 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 16 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 18352864 INDEX RANGE SCAN MTL_MATERIAL_TRANSACTIONS_N5 (object id 3350660) 35554 SORT GROUP BY 614514 FILTER 614514 TABLE ACCESS FULL MRP_GROSS_REQUIREMENTS 1570822 TABLE ACCESS FULL MTL_SYSTEM_ITEMS_B 144669 INDEX UNIQUE SCAN MTL_CATEGORIES_TL_U1 (object id 492009) 144639 TABLE ACCESS BY INDEX ROWID CST_ITEM_COSTS 144639 INDEX UNIQUE SCAN CST_ITEM_COSTS_U1 (object id 3350616) 19260 VIEW 19260 FILTER 28947 NESTED LOOPS OUTER 28947 NESTED LOOPS OUTER 28947 NESTED LOOPS OUTER 28947 NESTED LOOPS OUTER 28947 NESTED LOOPS OUTER 28947 NESTED LOOPS OUTER 28745 NESTED LOOPS 28745 NESTED LOOPS 28745 TABLE ACCESS FULL PER_ALL_PEOPLE_F 28745 INDEX UNIQUE SCAN PER_PERSON_TYPES_PK (object id 142488) 28745 INDEX UNIQUE SCAN PER_PERSON_TYPES_TL_PK (object id 496505) 21825 TABLE ACCESS BY INDEX ROWID PER_PERIODS_OF_SERVICE 21825 INDEX RANGE SCAN PER_PERIODS_OF_SERVICE_N3 (object id 137559) 403 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 403 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 862 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 862 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 17102 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 17140 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 18871 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 18872 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 27903 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 27903 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 21034 SORT AGGREGATE 21197 TABLE ACCESS BY INDEX ROWID PER_PERIODS_OF_SERVICE 21197 INDEX RANGE SCAN PER_PERIODS_OF_SERVICE_N3 (object id 137559) 28246 SORT AGGREGATE 50319 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 50319 INDEX RANGE SCAN PER_PEOPLE_F_PK (object id 142418) ******************************************************************************** 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 4.87 0 0 0 0 Execute 2 0.00 3.22 0 0 0 0 Fetch 2 0.00 7.58 2 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 15.67 2 4 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID 2 INDEX UNIQUE SCAN FND_ORACLE_USERID_U2 (object id 136142) ******************************************************************************** SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 100.00 5.32 0 0 0 0 Execute 5 0.00 11.59 0 0 0 0 Fetch 5 0.00 11.18 2 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 100.00 28.09 2 6 0 3 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID PER_SECURITY_PROFILES 2 INDEX UNIQUE SCAN PER_SECURITY_PROFILES_PK (object id 142515) ******************************************************************************** SELECT MESSAGE_TEXT, MESSAGE_NUMBER, TYPE, FND_LOG_SEVERITY, CATEGORY, SEVERITY FROM FND_NEW_MESSAGES M, FND_APPLICATION A WHERE :B3 = M.MESSAGE_NAME AND :B2 = M.LANGUAGE_CODE AND :B1 = A.APPLICATION_SHORT_NAME AND M.APPLICATION_ID = A.APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.66 0 0 0 0 Execute 1 0.00 2.70 0 0 0 0 Fetch 1 0.00 6.16 2 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 11.52 2 6 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (object id 135899) 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (object id 136139) ******************************************************************************** SELECT LEGISLATION_CODE FROM PER_BUSINESS_GROUPS_PERF WHERE BUSINESS_GROUP_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.83 0 0 0 0 Execute 1 0.00 2.99 0 0 0 0 Fetch 1 0.00 7.73 2 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 13.55 2 8 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION 2 NESTED LOOPS 1 NESTED LOOPS 1 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (object id 142268) 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (object id 3347785) 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (object id 3347785) ******************************************************************************** SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = :B2 AND LOOKUP_CODE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 2.99 0 0 0 0 Execute 2 0.00 2.82 0 0 0 0 Fetch 2 0.00 15.09 5 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 100.00 20.90 5 8 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) ******************************************************************************** SELECT PP.FULL_NAME FROM MTL_PLANNERS MPL, PER_PEOPLE_V7 PP WHERE MPL.PLANNER_CODE = :B2 AND MPL.ORGANIZATION_ID = :B1 AND MPL.EMPLOYEE_ID = PP.PERSON_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 700.00 1295.95 15 30 0 0 Execute 80208 425800.00 434473.35 0 0 0 0 Fetch 802082103600.00 2055506.35 219 1817471 0 77111 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1604172530100.00 2491275.65 234 1817501 0 77111 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 77111 FILTER 77112 NESTED LOOPS OUTER 77112 NESTED LOOPS OUTER 77112 NESTED LOOPS OUTER 77112 NESTED LOOPS OUTER 77112 NESTED LOOPS OUTER 77112 NESTED LOOPS OUTER 77111 NESTED LOOPS 77111 NESTED LOOPS 77111 NESTED LOOPS 77111 TABLE ACCESS BY INDEX ROWID MTL_PLANNERS 77204 INDEX UNIQUE SCAN MTL_PLANNERS_U1 (object id 139932) 77111 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 77111 INDEX RANGE SCAN PER_PEOPLE_F_PK (object id 142418) 77111 SORT AGGREGATE 92940 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 92940 INDEX RANGE SCAN PER_PEOPLE_F_PK (object id 142418) 77111 INDEX UNIQUE SCAN PER_PERSON_TYPES_PK (object id 142488) 77111 INDEX UNIQUE SCAN PER_PERSON_TYPES_TL_PK (object id 496505) 77112 TABLE ACCESS BY INDEX ROWID PER_PERIODS_OF_SERVICE 77112 INDEX RANGE SCAN PER_PERIODS_OF_SERVICE_N3 (object id 137559) 5395 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 5395 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 15932 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 15932 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 0 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 0 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 77112 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 77112 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 1911 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 1911 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 77111 SORT AGGREGATE 77112 TABLE ACCESS BY INDEX ROWID PER_PERIODS_OF_SERVICE 77112 INDEX RANGE SCAN PER_PERIODS_OF_SERVICE_N3 (object id 137559) ******************************************************************************** SELECT SAFETY_STOCK_QUANTITY FROM MTL_SAFETY_STOCKS WHERE INVENTORY_ITEM_ID = :B3 AND ORGANIZATION_ID = :B2 AND EFFECTIVITY_DATE <= :B1 ORDER BY EFFECTIVITY_DATE DESC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 300.00 250.99 0 0 0 0 Execute 80208 104500.00 103078.10 0 0 0 0 Fetch 80208 66400.00 142877.99 1550 173225 0 10409 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 160417 171200.00 246207.08 1550 173225 0 10409 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 10409 TABLE ACCESS BY INDEX ROWID MTL_SAFETY_STOCKS 10409 INDEX RANGE SCAN DESCENDING MTL_SAFETY_STOCKS_U1 (object id 744748) ******************************************************************************** SELECT GSB.CURRENCY_CODE FROM ORG_ORGANIZATION_DEFINITIONS OOD, GL_SETS_OF_BOOKS GSB WHERE OOD.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID AND OOD.ORGANIZATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 129.15 0 0 0 0 Execute 80208 221900.00 211117.12 0 0 0 0 Fetch 802082594300.00 2563801.71 248 4198042 0 80208 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1604172816300.00 2775047.98 248 4198042 0 80208 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 80208 MERGE JOIN CARTESIAN 80208 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION 2807280 NESTED LOOPS 1363536 NESTED LOOPS 1363536 MERGE JOIN CARTESIAN 80208 NESTED LOOPS 80208 NESTED LOOPS 80208 NESTED LOOPS 80208 INDEX UNIQUE SCAN MTL_PARAMETERS_U1 (object id 139915) 80208 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (object id 496503) 80208 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS 80208 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (object id 142268) 80208 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION 136696 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (object id 3347785) 1363536 BUFFER SORT 1363536 INDEX FULL SCAN GL_SETS_OF_BOOKS_U2 (object id 136592) 1363536 TABLE ACCESS BY INDEX ROWID GL_SETS_OF_BOOKS 1363536 INDEX UNIQUE SCAN GL_SETS_OF_BOOKS_U2 (object id 136592) 1363536 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (object id 3347785) 80208 BUFFER SORT 80208 TABLE ACCESS FULL FND_PRODUCT_GROUPS ******************************************************************************** INSERT INTO PWR_WB_INV_TURNS (PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, PLANNER, BUYER, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, ATTRIBUTE31, ATTRIBUTE32, ATTRIBUTE33, ATTRIBUTE34, ATTRIBUTE35, ATTRIBUTE36, ATTRIBUTE37, ATTRIBUTE38, ATTRIBUTE39, ATTRIBUTE40, ATTRIBUTE41, ATTRIBUTE42, ATTRIBUTE43, ATTRIBUTE44, ATTRIBUTE1, CREATION_DATE, CREATED_BY ) VALUES (:B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B5 , :B7 , :B6 , :B11 , :B10 , :B9 , :B8 , :B3 , :B7 * :B3 , :B6 * :B3 , :B5 * :B3 , :B4 , :B4 * :B3 ,:B2 , SYSDATE, :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 37.09 0 0 0 0 Execute 80208 561500.00 638418.19 9144 9770 673651 80208 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 80209 561500.00 638455.28 9144 9770 673651 80208 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** SELECT ROUND (CONVERSION_RATE, 5) FROM GL_DAILY_RATES WHERE FROM_CURRENCY = :B1 AND TO_CURRENCY = 'USD' AND CONVERSION_TYPE = 'Corporate' AND TRUNC (CONVERSION_DATE) = TRUNC (SYSDATE) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 100.00 29.99 0 0 0 0 Execute 59104 67800.00 70184.35 0 0 0 0 Fetch 591049258600.00 9145254.73 654 1642187 0 59104 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1182109326500.00 9215469.07 654 1642187 0 59104 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 59089 TABLE ACCESS BY INDEX ROWID GL_DAILY_RATES 59089 INDEX RANGE SCAN GL_DAILY_RATES_U1 (object id 136499) ******************************************************************************** SELECT MCS.CATEGORY_SET_ID , MCS.STRUCTURE_ID FROM MTL_CATEGORY_SETS MCS WHERE MCS.CATEGORY_SET_NAME = 'PWR SBU ITEMS' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 100.00 157.92 2 4 0 0 Execute 3 0.00 3.44 0 0 0 0 Fetch 3 0.00 1211.67 42 48 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 100.00 1373.03 44 52 0 3 Misses in library cache during parse: 2 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS FULL MTL_CATEGORY_SETS_TL 1 TABLE ACCESS BY INDEX ROWID MTL_CATEGORY_SETS_B 1 INDEX UNIQUE SCAN MTL_CATEGORY_SETS_B_U1 (object id 139753) ******************************************************************************** SELECT MCS.CATEGORY_SET_ID , MCS.STRUCTURE_ID FROM MTL_CATEGORY_SETS MCS WHERE MCS.CATEGORY_SET_NAME = 'PWR CATEGORIES' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 200.00 106.53 0 0 0 0 Execute 3 0.00 2.51 0 0 0 0 Fetch 3 0.00 10.54 0 48 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 200.00 119.58 0 48 0 3 Misses in library cache during parse: 2 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS FULL MTL_CATEGORY_SETS_TL 1 TABLE ACCESS BY INDEX ROWID MTL_CATEGORY_SETS_B 1 INDEX UNIQUE SCAN MTL_CATEGORY_SETS_B_U1 (object id 139753) ******************************************************************************** SELECT INVENTORY_ITEM_ID,INV_ORG_ID FROM CUSTOM.PWR_WB_INV_TURNS WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 100.00 45.70 0 0 0 0 Execute 3 0.00 14.97 0 0 0 0 Fetch 841142 776900.00 937381.17 108334 1051720 0 841139 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 841148 777000.00 937441.84 108334 1051720 0 841139 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 80208 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** SELECT SEGMENT2 PRODUCT_SEGMENT FROM MTL_CATEGORIES_B MC, MTL_ITEM_CATEGORIES MIC WHERE MC.CATEGORY_ID = MIC.CATEGORY_ID AND MIC.CATEGORY_SET_ID = :B4 AND MC.STRUCTURE_ID = :B3 AND MIC.INVENTORY_ITEM_ID = :B2 AND MIC.ORGANIZATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 47.74 0 0 0 0 Execute 841139 911300.00 858411.32 0 0 0 0 Fetch 8411391390100.00 6523945.35 88731 5047448 0 841128 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16822812301400.00 7382404.41 88731 5047448 0 841128 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 80203 NESTED LOOPS 80203 INDEX RANGE SCAN MTL_ITEM_CATEGORIES_U1 (object id 541812) 80203 TABLE ACCESS BY INDEX ROWID MTL_CATEGORIES_B 80203 INDEX UNIQUE SCAN MTL_CATEGORIES_B_U1 (object id 139745) ******************************************************************************** SELECT SEGMENT2 PRODUCT_GROUP,SEGMENT3 PRODUCT_FAMILY,SEGMENT4 PRODUCT_SERIES FROM MTL_CATEGORIES_B MC, MTL_ITEM_CATEGORIES MIC WHERE MC.CATEGORY_ID = MIC.CATEGORY_ID AND MIC.CATEGORY_SET_ID = :B4 AND MC.STRUCTURE_ID = :B3 AND MIC.INVENTORY_ITEM_ID = :B2 AND MIC.ORGANIZATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 43.89 0 0 0 0 Execute 841139 793100.00 752865.59 0 0 0 0 Fetch 8411391046000.00 1030890.64 660 5048029 0 841139 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16822811839100.00 1783800.12 660 5048029 0 841139 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 80208 NESTED LOOPS 80208 INDEX RANGE SCAN MTL_ITEM_CATEGORIES_U1 (object id 541812) 80208 TABLE ACCESS BY INDEX ROWID MTL_CATEGORIES_B 80208 INDEX UNIQUE SCAN MTL_CATEGORIES_B_U1 (object id 139745) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE45 = :B7 , ATTRIBUTE46 = :B6 , ATTRIBUTE47 = :B5 , ATTRIBUTE48 = :B4 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = :B3 AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 20.00 0 0 0 0 Execute 80208 450600.00 478563.06 4380 325946 161990 80208 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 80209 450600.00 478583.06 4380 325946 161990 80208 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 80208 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 80208 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT MAX (W12_START_DT) FROM PWR_WB_INV_HIS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 300.00 180.91 43 82 0 0 Execute 1 0.00 0.86 0 0 0 0 Fetch 1 120600.00 249182.73 51699 78153 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 120900.00 249364.50 51742 78235 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE 181471 TABLE ACCESS FULL PWR_WB_INV_HIS ******************************************************************************** SELECT TO_CHAR (SYSDATE, 'DAY') FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 300.00 316.30 0 0 0 0 Execute 1 0.00 1.56 0 0 0 0 Fetch 1 100.00 7.24 1 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 400.00 325.10 1 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL DUAL ******************************************************************************** SELECT TRUNC ((NEXT_DAY (SYSDATE, 'MONDAY') - 7)) FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 26.35 0 0 0 0 Execute 1 0.00 1.50 0 0 0 0 Fetch 1 0.00 2.18 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 30.03 0 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL DUAL ******************************************************************************** SELECT PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, PLANNER, BUYER, ATTRIBUTE1, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, ATTRIBUTE31, ATTRIBUTE32, ATTRIBUTE33, ATTRIBUTE34, ATTRIBUTE35, ATTRIBUTE36, ATTRIBUTE37, ATTRIBUTE38, ATTRIBUTE39, ATTRIBUTE40, ATTRIBUTE41, ATTRIBUTE42, ATTRIBUTE43, ATTRIBUTE44, ATTRIBUTE45, ATTRIBUTE46, ATTRIBUTE47, ATTRIBUTE48, ATTRIBUTE49, ATTRIBUTE50 FROM PWR_WB_INV_TURNS WHERE ATTRIBUTE_CONTEXT = 'INVENTORY CONTROL' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 218.51 0 0 0 0 Execute 1 0.00 1.25 0 0 0 0 Fetch 80209 106600.00 126712.94 39802 116694 0 80208 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 80211 106700.00 126932.70 39802 116694 0 80208 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** UPDATE PWR_WB_INV_HIS SET ITEM_TYPE = :B33 , ITEM_STATUS = :B32 , PLANNER = :B31 , BUYER = :B30 , W12_START_DT = :B29 , W12_A1 = :B28 , W12_A2 = :B27 , W12_A3 = :B26 , W12_A4 = :B25 , W12_A5 = :B24 , W12_A6 = :B23 , W12_A7 = :B22 , W12_A8 = :B21 , W12_A9 = :B20 , W12_A10 = :B19 , W12_A11 = :B18 , W12_A12 = :B17 , W12_A13 = :B16 , W12_A14 = :B15 , W12_A15 = :B14 , W12_A16 = :B13 , W12_A17 = :B12 , W12_A18 = :B11 , W12_A19 = :B10 , W12_A20 = :B9 , W12_A21 = :B8 , W12_A22 = :B7 , W12_A23 = :B6 , W12_A24 = :B5 , W12_A25 = :B4 , ATTRIBUTE1=:B3 WHERE INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 54.10 0 0 0 0 Execute 80208 446300.00 584016.69 28055 242100 174101 80206 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 80209 446400.00 584070.79 28055 242100 174101 80206 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 74632 INDEX RANGE SCAN PWR_WB_INV_HIS_N1 (object id 2032992) ******************************************************************************** INSERT INTO PWR_WB_INV_HIS (PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, PLANNER, BUYER, PROC_FLAG, W12_START_DT, W12_A1, W12_A2, W12_A3, W12_A4, W12_A5, W12_A6, W12_A7, W12_A8, W12_A9, W12_A10, W12_A11, W12_A12, W12_A13, W12_A14, W12_A15, W12_A16, W12_A17, W12_A18, W12_A19, W12_A20, W12_A21, W12_A22, W12_A23, W12_A24, W12_A25,ATTRIBUTE1 ) VALUES (:B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , 'NEW', :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 ,:B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 400.00 381.67 0 0 0 0 Execute 2 100.00 41.23 1 1 10 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 500.00 422.90 1 1 10 2 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** SELECT ORGANIZATION_ID, ORGANIZATION_CODE FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE <> 'GLO' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 44.24 0 0 0 0 Execute 1 0.00 0.83 0 0 0 0 Fetch 21 100.00 120.50 41 22 0 20 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23 200.00 165.57 41 22 0 20 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** INSERT INTO CUSTOM.PWR_WB_INV_TURNS (PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, BUYER, PLANNER, ATTRIBUTE1, ATTRIBUTE4, ATTRIBUTE6, CREATION_DATE, CREATED_BY) (SELECT :B5 , :B4 , MSI.INVENTORY_ITEM_ID , MSI.SEGMENT1 , :B3 , :B2 , MSI.ITEM_TYPE , MSI.INVENTORY_ITEM_STATUS_CODE , MSI.BUYER_ID , MSI.PLANNER_CODE , MC.SEGMENT1 , ROUND (NVL (CIS.ITEM_COST, 0), 2) , NULL , TRUNC (SYSDATE), :B1 FROM MTL_SYSTEM_ITEMS_B MSI, CST_ITEM_COSTS CIS, MTL_CATEGORIES MC, MTL_ITEM_CATEGORIES MIC WHERE CIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND CIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CIS.COST_TYPE_ID = 1 AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIC.ORGANIZATION_ID = 86 AND MIC.CATEGORY_SET_ID = 65 AND MC.CATEGORY_ID = MIC.CATEGORY_ID AND MSI.ORGANIZATION_ID = :B3 GROUP BY :B5 , :B4 , MSI.INVENTORY_ITEM_ID, MSI.SEGMENT1, :B3 , :B2 , MSI.ITEM_TYPE, MSI.INVENTORY_ITEM_STATUS_CODE, MSI.BUYER_ID, MSI.PLANNER_CODE, MC.SEGMENT1, ROUND (NVL (CIS.ITEM_COST, 0), 2), TRUNC (SYSDATE), :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 122.78 1 2 0 0 Execute 2014100000.0015995940.18 5508464 10662586 8836011 1080054 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2114100000.0015996062.96 5508465 10662588 8836011 1080054 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1080054 SORT GROUP BY 1080054 NESTED LOOPS 1080054 HASH JOIN 1080054 NESTED LOOPS 1089922 HASH JOIN 1089934 TABLE ACCESS BY INDEX ROWID CST_ITEM_COSTS 1089934 INDEX RANGE SCAN CST_ITEM_COSTS_N2 (object id 140576) 1253911 TABLE ACCESS FULL MTL_SYSTEM_ITEMS_B 1080054 INDEX RANGE SCAN MTL_ITEM_CATEGORIES_U1 (object id 541812) 241840 TABLE ACCESS FULL MTL_CATEGORIES_B 1080054 INDEX UNIQUE SCAN MTL_CATEGORIES_TL_U1 (object id 492009) ******************************************************************************** INSERT INTO CUSTOM.PWR_WB_INV_TURNS (PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, BUYER, PLANNER, ATTRIBUTE1, ATTRIBUTE4, ATTRIBUTE6, CREATION_DATE, CREATED_BY) (SELECT :B5 , :B4 , MSI.INVENTORY_ITEM_ID , MSI.SEGMENT1 , :B3 , :B2 , MSI.ITEM_TYPE , MSI.INVENTORY_ITEM_STATUS_CODE , MSI.BUYER_ID , MSI.PLANNER_CODE , MC.SEGMENT1 , ROUND (NVL (CIS.ITEM_COST, 0), 2) , NULL , TRUNC (SYSDATE), :B1 FROM MTL_SYSTEM_ITEMS_B MSI, CST_ITEM_COSTS CIS, MTL_CATEGORIES MC, MTL_ITEM_CATEGORIES MIC WHERE CIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND CIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CIS.COST_TYPE_ID = 1 AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIC.ORGANIZATION_ID = 86 AND MIC.CATEGORY_SET_ID = 65 AND MC.CATEGORY_ID = MIC.CATEGORY_ID AND MSI.ORGANIZATION_ID = :B3 AND NOT EXISTS ( SELECT 1 FROM CUSTOM.PWR_WB_INV_TURNS X WHERE X.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND X.INV_ORG_ID = MSI.ORGANIZATION_ID AND X.PROCESS_TYPE = 'BACKGROUND' AND X.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK') GROUP BY :B5 , :B4 , MSI.INVENTORY_ITEM_ID, MSI.SEGMENT1, :B3 , :B2 , MSI.ITEM_TYPE, MSI.INVENTORY_ITEM_STATUS_CODE, MSI.BUYER_ID, MSI.PLANNER_CODE, MC.SEGMENT1, ROUND (NVL (CIS.ITEM_COST, 0), 2), TRUNC (SYSDATE), :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 149.71 1 2 0 0 Execute 201866300.00 2203716.99 320718 5565232 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 211866400.00 2203866.70 320719 5565234 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 9868 HASH JOIN 173857 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B 173857 INDEX RANGE SCAN MTL_SYTEM_ITEMS_2 (object id 139985) 1080054 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 1120843 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) 1089891 TABLE ACCESS BY INDEX ROWID CST_ITEM_COSTS 1089891 INDEX RANGE SCAN CST_ITEM_COSTS_N2 (object id 140576) 0 INDEX RANGE SCAN MTL_ITEM_CATEGORIES_U1 (object id 541812) 0 TABLE ACCESS BY INDEX ROWID MTL_CATEGORIES_B 0 INDEX UNIQUE SCAN MTL_CATEGORIES_B_U1 (object id 139745) 0 INDEX UNIQUE SCAN MTL_CATEGORIES_TL_U1 (object id 492009) ******************************************************************************** INSERT INTO CUSTOM.PWR_WB_INV_TURNS (PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, BUYER, PLANNER, ATTRIBUTE1, ATTRIBUTE4, ATTRIBUTE6, CREATION_DATE, CREATED_BY) (SELECT :B5 , :B4 , MSI.INVENTORY_ITEM_ID , MSI.SEGMENT1 , :B3 , :B2 , MSI.ITEM_TYPE , MSI.INVENTORY_ITEM_STATUS_CODE , MSI.BUYER_ID , MSI.PLANNER_CODE , MC.SEGMENT1 , ROUND (NVL (CIS.ITEM_COST, 0), 2) , NULL , TRUNC (SYSDATE), :B1 FROM MTL_SYSTEM_ITEMS_B MSI, CST_ITEM_COSTS CIS, MTL_CATEGORIES MC, MTL_ITEM_CATEGORIES MIC, MRP_GROSS_REQUIREMENTS MGR WHERE CIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND CIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CIS.COST_TYPE_ID = 1 AND MGR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MGR.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIC.ORGANIZATION_ID = 86 AND MIC.CATEGORY_SET_ID = 65 AND MC.CATEGORY_ID = MIC.CATEGORY_ID AND MSI.ORGANIZATION_ID = :B3 AND UPPER (COMPILE_DESIGNATOR) = 'P1-MRP' AND USING_ASSEMBLY_DEMAND_DATE BETWEEN SYSDATE AND SYSDATE + 42 AND NOT EXISTS ( SELECT 1 FROM CUSTOM.PWR_WB_INV_TURNS X WHERE X.INVENTORY_ITEM_ID = MGR.INVENTORY_ITEM_ID AND X.INV_ORG_ID = MGR.ORGANIZATION_ID AND X.PROCESS_TYPE = 'BACKGROUND' AND X.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK') GROUP BY :B5 , :B4 , MSI.INVENTORY_ITEM_ID, MSI.SEGMENT1, :B3 , :B2 , MSI.ITEM_TYPE, MSI.INVENTORY_ITEM_STATUS_CODE, MSI.BUYER_ID, MSI.PLANNER_CODE, MC.SEGMENT1, ROUND (NVL (CIS.ITEM_COST, 0), 2), TRUNC (SYSDATE), :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 200.00 175.12 0 0 0 0 Execute 20 377800.00 1227089.13 56141 183422 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 378000.00 1227264.25 56141 183422 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY 0 FILTER 0 NESTED LOOPS 4 NESTED LOOPS 4 NESTED LOOPS 4 NESTED LOOPS 721 NESTED LOOPS 721 INDEX RANGE SCAN MRP_GROSS_REQUIREMENTS_N1 (object id 140703) 29474 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 44887 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) 721 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B 721 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (object id 139976) 4 INDEX RANGE SCAN MTL_ITEM_CATEGORIES_U1 (object id 541812) 4 TABLE ACCESS BY INDEX ROWID MTL_CATEGORIES_B 4 INDEX UNIQUE SCAN MTL_CATEGORIES_B_U1 (object id 139745) 4 INDEX UNIQUE SCAN MTL_CATEGORIES_TL_U1 (object id 492009) 0 TABLE ACCESS BY INDEX ROWID CST_ITEM_COSTS 0 INDEX UNIQUE SCAN CST_ITEM_COSTS_U1 (object id 3350616) ******************************************************************************** INSERT INTO CUSTOM.PWR_WB_INV_TURNS (PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, BUYER, PLANNER, ATTRIBUTE1, ATTRIBUTE4, ATTRIBUTE6, CREATION_DATE, CREATED_BY) (SELECT :B5 , :B4 , MSI.INVENTORY_ITEM_ID , MSI.SEGMENT1 , :B3 , :B2 , MSI.ITEM_TYPE , MSI.INVENTORY_ITEM_STATUS_CODE , MSI.BUYER_ID , MSI.PLANNER_CODE , MC.SEGMENT1 , ROUND (NVL (CIS.ITEM_COST, 0), 2) , NULL , TRUNC (SYSDATE), :B1 FROM MTL_SYSTEM_ITEMS_B MSI, CST_ITEM_COSTS CIS, MTL_CATEGORIES MC, MTL_ITEM_CATEGORIES MIC, MTL_MATERIAL_TRANSACTIONS MMT WHERE CIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND CIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CIS.COST_TYPE_ID = 1 AND MMT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MMT.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIC.ORGANIZATION_ID = 86 AND MIC.CATEGORY_SET_ID = 65 AND MC.CATEGORY_ID = MIC.CATEGORY_ID AND MSI.ORGANIZATION_ID = :B3 AND NOT EXISTS ( SELECT 1 FROM CUSTOM.PWR_WB_INV_TURNS X WHERE X.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID AND X.INV_ORG_ID = MMT.ORGANIZATION_ID AND X.PROCESS_TYPE = 'BACKGROUND' AND X.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK') AND MMT.TRANSACTION_TYPE_ID IN ( SELECT LOOKUP_CODE FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'PWR_MINMAX_TRANS_TYPE_ID' AND ENABLED_FLAG = 'Y') AND MMT.TRANSACTION_DATE BETWEEN ADD_MONTHS (SYSDATE, -6) AND SYSDATE GROUP BY :B5 , :B4 , MSI.INVENTORY_ITEM_ID, MSI.SEGMENT1, :B3 , :B2 , MSI.ITEM_TYPE, MSI.INVENTORY_ITEM_STATUS_CODE, MSI.BUYER_ID, MSI.PLANNER_CODE, MC.SEGMENT1, ROUND (NVL (CIS.ITEM_COST, 0), 2), TRUNC (SYSDATE), :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 300.00 209.78 0 0 0 0 Execute 2020135500.0023458747.57 4494495 42958416 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2120135800.0023458957.35 4494495 42958416 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY 0 FILTER 1886315 FILTER 1886315 NESTED LOOPS 1886342 NESTED LOOPS 1886342 NESTED LOOPS 1886342 NESTED LOOPS 1889890 NESTED LOOPS 1889890 NESTED LOOPS 320 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 320 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 1889890 TABLE ACCESS BY INDEX ROWID MTL_MATERIAL_TRANSACTIONS 52073776 INDEX RANGE SCAN MTL_MATERIAL_TRANSACTIONS_N25 (object id 3394372) 1889890 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B 1889890 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (object id 139976) 1886342 INDEX RANGE SCAN MTL_ITEM_CATEGORIES_U1 (object id 541812) 1886342 TABLE ACCESS BY INDEX ROWID MTL_CATEGORIES_B 1886342 INDEX UNIQUE SCAN MTL_CATEGORIES_B_U1 (object id 139745) 1886342 INDEX UNIQUE SCAN MTL_CATEGORIES_TL_U1 (object id 492009) 1886315 TABLE ACCESS BY INDEX ROWID CST_ITEM_COSTS 1886315 INDEX UNIQUE SCAN CST_ITEM_COSTS_U1 (object id 3350616) 1740824 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 2700225 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT INV_ORG_ID ORG_ID, GSB.CURRENCY_CODE FROM CUSTOM.PWR_WB_INV_TURNS ITR, ORG_ORGANIZATION_DEFINITIONS OOD, GL_SETS_OF_BOOKS GSB WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND INV_ORG_ID = OOD.ORGANIZATION_ID AND OOD.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID GROUP BY INV_ORG_ID, GSB.CURRENCY_CODE ORDER BY 1, 2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 2200.00 3062.70 2 4 0 0 Execute 1 0.00 3.56 0 0 0 0 Fetch 21 229000.00 249321.64 38761 39967 0 20 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23 231200.00 252387.90 38763 39971 0 20 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 20 SORT GROUP BY 1080054 HASH JOIN 17 TABLE ACCESS FULL GL_SETS_OF_BOOKS 1080054 HASH JOIN 17 INDEX FULL SCAN GL_SETS_OF_BOOKS_U2 (object id 136592) 1080054 HASH JOIN 21 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION 43 NESTED LOOPS 21 NESTED LOOPS 21 NESTED LOOPS 21 NESTED LOOPS 21 MERGE JOIN CARTESIAN 1 TABLE ACCESS FULL FND_PRODUCT_GROUPS 21 BUFFER SORT 21 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION 23 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_IX1 (object id 547481) 21 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS 21 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (object id 142268) 21 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (object id 496503) 21 INDEX UNIQUE SCAN MTL_PARAMETERS_U1 (object id 139915) 21 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (object id 3347785) 1080054 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE20 = :B3 , ATTRIBUTE3 = :B2 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 300.00 313.18 0 0 0 0 Execute 202305200.00 2328488.18 761675 797736 1106834 1080054 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 212305500.00 2328801.36 761675 797736 1106834 1080054 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 1080054 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** SELECT MSS1.SAFETY_STOCK_QUANTITY SAFETY_STOCK_QTY, ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID FROM MTL_SAFETY_STOCKS MSS1, CUSTOM.PWR_WB_INV_TURNS ITR WHERE ITR.PROCESS_TYPE = 'BACKGROUND' AND ITR.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND MSS1.INVENTORY_ITEM_ID = ITR.INVENTORY_ITEM_ID AND MSS1.ORGANIZATION_ID = ITR.INV_ORG_ID AND (MSS1.EFFECTIVITY_DATE, MSS1.INVENTORY_ITEM_ID, MSS1.ORGANIZATION_ID ) IN ( SELECT MAX (EFFECTIVITY_DATE), MSS.INVENTORY_ITEM_ID, MSS.ORGANIZATION_ID FROM MTL_SAFETY_STOCKS MSS, CUSTOM.PWR_WB_INV_TURNS ITR WHERE MSS.ORGANIZATION_ID = ITR.INV_ORG_ID AND MSS.INVENTORY_ITEM_ID = ITR.INVENTORY_ITEM_ID AND MSS.EFFECTIVITY_DATE <= SYSDATE GROUP BY MSS.INVENTORY_ITEM_ID, MSS.ORGANIZATION_ID) AND SAFETY_STOCK_QUANTITY <> 0 GROUP BY SAFETY_STOCK_QUANTITY, ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 500.00 768.91 5 6 0 0 Execute 1 0.00 2.17 0 0 0 0 Fetch 4946 232900.00 426702.35 42302 454405 0 4945 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4948 233400.00 427473.43 42307 454411 0 4945 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 4945 SORT GROUP BY 4945 VIEW 4945 FILTER 44243 SORT GROUP BY 259785 NESTED LOOPS 191025 HASH JOIN 197110 HASH JOIN 95192 TABLE ACCESS FULL MTL_SAFETY_STOCKS 45658 TABLE ACCESS FULL MTL_SAFETY_STOCKS 1080054 TABLE ACCESS FULL PWR_WB_INV_TURNS 259785 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE5 = :B3 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 21.05 0 0 0 0 Execute 4945 31700.00 41646.73 4240 24751 5062 4945 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4946 31700.00 41667.78 4240 24751 5062 4945 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 4945 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 9849 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT NVL (SUM (MOQ.TRANSACTION_QUANTITY), 0) ONHAND_QTY, ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID FROM MTL_ONHAND_QUANTITIES MOQ, CUSTOM.PWR_WB_INV_TURNS ITR WHERE MOQ.INVENTORY_ITEM_ID = ITR.INVENTORY_ITEM_ID AND MOQ.ORGANIZATION_ID = ITR.INV_ORG_ID AND ITR.PROCESS_TYPE = 'BACKGROUND' AND ITR.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND NOT EXISTS ( SELECT 1 FROM MTL_ITEM_SUB_INVENTORIES WHERE SECONDARY_INVENTORY = MOQ.SUBINVENTORY_CODE AND INVENTORY_ITEM_ID = MOQ.INVENTORY_ITEM_ID AND ORGANIZATION_ID = MOQ.ORGANIZATION_ID AND MIN_MINMAX_QUANTITY IS NOT NULL AND MAX_MINMAX_QUANTITY IS NOT NULL) GROUP BY ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 900.00 685.12 0 0 0 0 Execute 1 0.00 1.71 0 0 0 0 Fetch 80138 206500.00 244956.14 53976 341301 0 80137 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 80140 207400.00 245642.97 53976 341301 0 80137 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE7 = :B3 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 20.65 0 0 0 0 Execute 80137 385100.00 415266.17 16710 395354 81966 80137 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 80138 385100.00 415286.82 16710 395354 81966 80137 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 80137 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 154159 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT NVL (SUM (MOQ.TRANSACTION_QUANTITY), 0) ONHAND_QTY1, ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID FROM MTL_ONHAND_QUANTITIES MOQ, CUSTOM.PWR_WB_INV_TURNS ITR WHERE MOQ.INVENTORY_ITEM_ID = ITR.INVENTORY_ITEM_ID AND MOQ.ORGANIZATION_ID = ITR.INV_ORG_ID AND ITR.PROCESS_TYPE = 'BACKGROUND' AND ITR.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND EXISTS ( SELECT 1 FROM MTL_ITEM_SUB_INVENTORIES WHERE SECONDARY_INVENTORY = MOQ.SUBINVENTORY_CODE AND INVENTORY_ITEM_ID = MOQ.INVENTORY_ITEM_ID AND ORGANIZATION_ID = MOQ.ORGANIZATION_ID AND MIN_MINMAX_QUANTITY IS NOT NULL AND MAX_MINMAX_QUANTITY IS NOT NULL) GROUP BY ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 161.44 1 2 0 0 Execute 1 0.00 2.22 0 0 0 0 Fetch 1042 35000.00 34531.91 16194 30108 0 1041 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1044 35100.00 34695.57 16195 30110 0 1041 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1041 SORT GROUP BY 3683 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 10913 NESTED LOOPS 3718 HASH JOIN SEMI 254220 TABLE ACCESS FULL MTL_ONHAND_QUANTITIES_DETAIL 6831 TABLE ACCESS FULL MTL_ITEM_SUB_INVENTORIES 7194 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE18 = :B3 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 19.78 0 0 0 0 Execute 1041 4100.00 4370.86 1 5129 1069 1041 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1042 4100.00 4390.64 1 5129 1069 1041 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 1041 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 2003 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT SUM(NVL (MISI.MIN_MINMAX_QUANTITY, 0)) MIN_QTY, SUM(NVL (MISI.MAX_MINMAX_QUANTITY, 0)) MAX_QTY, ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID FROM MTL_ITEM_SUB_INVENTORIES MISI, CUSTOM.PWR_WB_INV_TURNS ITR WHERE MISI.INVENTORY_ITEM_ID = ITR.INVENTORY_ITEM_ID AND MISI.ORGANIZATION_ID = ITR.INV_ORG_ID AND ITR.PROCESS_TYPE = 'BACKGROUND' AND ITR.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' GROUP BY ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 82.03 0 0 0 0 Execute 1 0.00 1.54 0 0 0 0 Fetch 6475 84100.00 103748.89 37911 49159 0 6474 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6477 84100.00 103832.46 37911 49159 0 6474 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE8 = NVL (:B4 , 0), ATTRIBUTE9 = NVL (:B3 , 0) WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 22.36 0 0 0 0 Execute 6474 36000.00 53528.08 3197 28271 6634 6474 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6475 36000.00 53550.44 3197 28271 6634 6474 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 6474 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 8794 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT NVL (SUM (USING_REQUIREMENTS_QUANTITY), 0) MRP_DEMAND, ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID FROM MRP_GROSS_REQUIREMENTS MGR, CUSTOM.PWR_WB_INV_TURNS ITR WHERE MGR.COMPILE_DESIGNATOR = 'P1-MRP' AND MGR.USING_ASSEMBLY_DEMAND_DATE BETWEEN SYSDATE AND SYSDATE + 42 AND MGR.INVENTORY_ITEM_ID = ITR.INVENTORY_ITEM_ID AND MGR.ORGANIZATION_ID = ITR.INV_ORG_ID AND ITR.PROCESS_TYPE = 'BACKGROUND' AND ITR.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' GROUP BY ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 103.93 0 0 0 0 Execute 1 0.00 1.88 0 0 0 0 Fetch 29475 368000.00 477959.58 132282 133972 0 29474 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29477 368100.00 478065.39 132282 133972 0 29474 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 29474 SORT GROUP BY 254741 FILTER 254741 HASH JOIN 255462 TABLE ACCESS FULL MRP_GROSS_REQUIREMENTS 1080054 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE10 = NVL (:B3 , 0) WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 200.00 255.52 0 0 0 0 Execute 29474 154500.00 167153.33 10838 147673 30162 29474 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29475 154700.00 167408.85 10838 147673 30162 29474 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 29474 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 58948 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT ROUND (ABS (NVL (SUM (MMT.TRANSACTION_QUANTITY), 0)) / 6, 0 ) AVG_USAGE, ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID FROM MTL_MATERIAL_TRANSACTIONS MMT, CUSTOM.PWR_WB_INV_TURNS ITR WHERE MMT.TRANSACTION_TYPE_ID IN ( SELECT LOOKUP_CODE FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'PWR_MINMAX_TRANS_TYPE_ID' AND ENABLED_FLAG = 'Y') AND MMT.ORGANIZATION_ID = ITR.INV_ORG_ID AND MMT.INVENTORY_ITEM_ID = ITR.INVENTORY_ITEM_ID AND MMT.TRANSACTION_DATE BETWEEN ADD_MONTHS (SYSDATE, -6) AND SYSDATE AND ITR.PROCESS_TYPE = 'BACKGROUND' AND ITR.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' GROUP BY ITR.INVENTORY_ITEM_ID, ITR.INV_ORG_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 500.00 414.43 1 2 0 0 Execute 1 0.00 3.12 0 0 0 0 Fetch 5252411174500.0011522375.24 2547019 10599871 0 52523 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5252611175000.0011522792.79 2547020 10599873 0 52523 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE11 = NVL (:B3 , 0) WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 22.46 0 0 0 0 Execute 52523 273700.00 311355.63 16073 255750 53728 52523 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 52524 273700.00 311378.09 16073 255750 53728 52523 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 52523 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 97683 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE2 = NVL (DECODE (ATTRIBUTE20, 'USD', ATTRIBUTE4, ROUND (ATTRIBUTE4 * ATTRIBUTE3, 2) ), 0 ), ATTRIBUTE12 = NVL ( ATTRIBUTE5 * DECODE (ATTRIBUTE20, 'USD', ATTRIBUTE4, ROUND (ATTRIBUTE4 * ATTRIBUTE3, 2) ), 0 ), ATTRIBUTE13 = NVL ( ATTRIBUTE7 * DECODE (ATTRIBUTE20, 'USD', ATTRIBUTE4, ROUND (ATTRIBUTE4 * ATTRIBUTE3, 2) ) , 0 ), ATTRIBUTE14 = NVL (LEAST (NVL (ATTRIBUTE7, 0) - NVL (ATTRIBUTE10, 0), NVL (ATTRIBUTE7, 0) - NVL (ATTRIBUTE11, 0) ), 0 ), ATTRIBUTE15 = NVL ( LEAST (NVL (ATTRIBUTE7, 0) - NVL (ATTRIBUTE10, 0), NVL (ATTRIBUTE7, 0) - NVL (ATTRIBUTE11, 0) ) * DECODE (ATTRIBUTE20, 'USD', ATTRIBUTE4, ROUND (ATTRIBUTE4 * ATTRIBUTE3, 2) ), 0 ), ATTRIBUTE16 = NVL ( NVL (ATTRIBUTE8, 0) * DECODE (ATTRIBUTE20, 'USD', ATTRIBUTE4, ROUND (ATTRIBUTE4 * ATTRIBUTE3, 2) ), 0 ), ATTRIBUTE17 = NVL ( NVL (ATTRIBUTE9, 0) * DECODE (ATTRIBUTE20, 'USD', ATTRIBUTE4, ROUND (ATTRIBUTE4 * ATTRIBUTE3, 2) ), 0 ), ATTRIBUTE19 = NVL ( ATTRIBUTE18 * DECODE (ATTRIBUTE20, 'USD', ATTRIBUTE4, ROUND (ATTRIBUTE4 * ATTRIBUTE3, 2) ), 0 ) WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 300.00 237.74 0 0 0 0 Execute 11782400.00 1835293.37 39797 52234 1122225 1080054 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21782700.00 1835531.11 39797 52234 1122225 1080054 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 1080054 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** SELECT PP.FULL_NAME, A.BUYER FROM CUSTOM.PWR_WB_INV_TURNS A, PER_ALL_PEOPLE_F PP WHERE PP.PERSON_ID = A.BUYER AND A.PROCESS_TYPE = 'BACKGROUND' AND A.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND A.BUYER IS NOT NULL AND PP.BUSINESS_GROUP_ID = 21 GROUP BY PP.FULL_NAME, A.BUYER call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 700.00 694.03 0 0 0 0 Execute 1 0.00 2.53 0 0 0 0 Fetch 222 148500.00 321451.38 40356 71306 0 221 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 224 149200.00 322147.94 40356 71306 0 221 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 221 SORT GROUP BY 1225944 HASH JOIN 5323 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 5323 INDEX RANGE SCAN PER_PEOPLE_F_FK1 (object id 137359) 772856 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET BUYER = :B2 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND BUYER = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 21.47 0 0 0 0 Execute 22115726600.0015915847.79 8518082 8824496 877419 772856 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22215726600.0015915869.26 8518082 8824496 877419 772856 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** SELECT PP.FULL_NAME, A.PLANNER, A.INV_ORG_ID FROM MTL_PLANNERS MPL, PER_ALL_PEOPLE_F PP, CUSTOM.PWR_WB_INV_TURNS A WHERE MPL.PLANNER_CODE = A.PLANNER AND MPL.ORGANIZATION_ID = A.INV_ORG_ID AND MPL.EMPLOYEE_ID = PP.PERSON_ID AND A.PROCESS_TYPE = 'BACKGROUND' AND A.ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND PP.BUSINESS_GROUP_ID = 21 AND A.PLANNER IS NOT NULL GROUP BY PP.FULL_NAME, A.PLANNER, A.INV_ORG_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 200.00 136.10 0 0 0 0 Execute 1 0.00 2.30 0 0 0 0 Fetch 1310 176300.00 407860.89 39631 70638 0 1309 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1312 176500.00 407999.29 39631 70638 0 1309 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1309 SORT GROUP BY 935115 HASH JOIN 5323 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 5323 INDEX RANGE SCAN PER_PEOPLE_F_FK1 (object id 137359) 649415 HASH JOIN 3088 TABLE ACCESS FULL MTL_PLANNERS 680370 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET PLANNER = :B3 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'VALUE OF CODED SAFETY STOCK' AND PLANNER = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 20.97 0 0 0 0 Execute 13092334554.08 957414.72 49322276 52183441 837575 649326 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13102334554.08 957435.69 49322276 52183441 837575 649326 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 542 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE21 = :B7 , ATTRIBUTE22 = :B6 , ATTRIBUTE23 = :B5 , ATTRIBUTE24 = :B4 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = :B3 AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 19.07 0 0 0 0 Execute 7446044701100.00 4788981.24 102170 3092930 1824131 744604 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7446054701100.00 4789000.31 102170 3092930 1824131 744604 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 744604 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 781461 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** select containerobj#,containertype,containernam,fullrefreshtim,increfreshtim, lastrefreshdate,lastrefreshscn,refreshmode,pflags,xpflags, mflags, numdetailtab,numaggregates,numkeycolumns,numjoins, numinlines,numwhrnodes, numhavnodes,sumtextlen,fromoffset,fromlen,objcount, metaversion,s.rowid from sum$ s, obj$ o where s.obj#=:1 and s.obj#=o.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 200.00 120.31 4 16 0 0 Execute 4 0.00 175.99 0 0 0 0 Fetch 4 0.00 104.35 5 24 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 200.00 400.65 9 40 0 4 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 INDEX UNIQUE SCAN I_OBJ1 (object id 31) 1 TABLE ACCESS BY INDEX ROWID SUM$ 1 INDEX UNIQUE SCAN I_SUM$_1 (object id 258272) ******************************************************************************** select p_obj#,p_type,inline#,instance# from sumdep$ where sumobj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 100.00 125.39 4 28 0 0 Execute 4 0.00 49.18 0 0 0 0 Fetch 14 100.00 275.85 9 28 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22 200.00 450.42 13 56 0 10 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID SUMDEP$ 1 INDEX RANGE SCAN I_SUMDEP$_1 (object id 258300) ******************************************************************************** select sumtext from sum$ where rowid = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 100.00 15.57 0 0 0 0 Execute 4 0.00 15.91 0 0 0 0 Fetch 4 0.00 2.81 0 8 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 100.00 34.29 0 8 0 4 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID SUM$ ******************************************************************************** select s1.detailobj#, s1.detaileut, s2.detailcol#, s2.sumcolpos#, s2.groupingpos#, s2.detailcolfunction from sumdetail$ s1, sumkey$ s2 where s1.sumobj# = :1 and s1.sumobj# = s2.sumobj# and s1.detailobj# = s2.detailobj# and (s2.detailcolfunction=1 or s2.detailcolfunction=2) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 200.00 235.19 11 70 0 0 Execute 4 100.00 93.08 0 0 0 0 Fetch 4 300.00 1120.81 15 34 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 600.00 1449.08 26 104 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID SUMKEY$ 15 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID SUMDETAIL$ 1 INDEX RANGE SCAN I_SUMDETAIL$_1 (object id 258274) 13 INDEX RANGE SCAN I_SUMKEY$_1 (object id 2749894) ******************************************************************************** select sumobj#, clauseid, nodeid, pnodeid, nodetype, numchild, relop, loptype, roptype, ldobj#, rdobj#, lcolid, rcolid, laggtype, raggtype, lcanotxt, rcanotxt, lcanotxtlen, rcanotxtlen, ltxt, rtxt, ltxtlen, rtxtlen, rowid, valuelen, colpos, numval, lflags, rflags, linline#, rinline#, linstance#, rinstance# from sumpred$ where sumobj#=:1 and bitand(clauseid,:2) > 0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 200.00 146.63 4 22 0 0 Execute 8 200.00 226.31 0 0 0 0 Fetch 30 0.00 608.16 9 60 0 22 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 46 400.00 981.10 13 82 0 22 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID SUMPRED$ 0 INDEX RANGE SCAN I_SUMPRED$_1 (object id 2749824) ******************************************************************************** select value from sumpred$ where rowid = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 19.65 0 0 0 0 Execute 22 0.00 25.95 0 0 0 0 Fetch 22 0.00 8.52 0 26 0 22 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 52 0.00 54.12 0 26 0 22 Misses in library cache during parse: 1 Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select inline#, textspos, textlen, hashval, instance# from suminline$ where sumobj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 17.41 0 0 0 0 Execute 4 0.00 32.65 0 0 0 0 Fetch 4 0.00 8.17 2 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 58.23 2 4 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID SUMINLINE$ 0 INDEX RANGE SCAN I_SUMINLINE$_1 (object id 2749826) ******************************************************************************** select tab1obj#, tab1col#, tab2obj#, tab2col#, joinop, flags, inline1#, inline2#, instance1#, instance2# from sumjoin$ where sumobj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 100.00 111.32 4 30 0 0 Execute 4 100.00 80.01 0 0 0 0 Fetch 10 100.00 347.10 7 20 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 300.00 538.43 11 50 0 6 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID SUMJOIN$ 0 INDEX RANGE SCAN I_SUMJOIN$_1 (object id 258281) ******************************************************************************** select sumcolpos#, containercol#, aggfunction, flags, textlen, rowid, exprlen, expression, agginfolen, agginfo from sumagg$ where sumobj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 100.00 105.24 3 29 0 0 Execute 4 0.00 79.31 0 0 0 0 Fetch 4 0.00 341.65 6 8 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 100.00 526.20 9 37 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID SUMAGG$ 0 INDEX RANGE SCAN I_SUMAGG$_1 (object id 258279) ******************************************************************************** select aggtext from sumagg$ where rowid = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 18.30 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 4 0.00 18.30 0 0 0 0 Misses in library cache during parse: 1 Parsing user id: SYS (recursive depth: 2) ******************************************************************************** select sumcolpos#, containercol#, detailobj#, detailobjtype, detailcol#, groupingpos#, textlen, rowid, exprlen, expression, detailcolfunction, nodetype, ordinalpos, parentpos, inline#, instance# from sumkey$ where sumobj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 18.94 0 0 0 0 Execute 4 100.00 85.02 0 0 0 0 Fetch 55 0.00 34.61 0 110 0 51 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 63 100.00 138.57 0 110 0 51 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 13 TABLE ACCESS BY INDEX ROWID SUMKEY$ 13 INDEX RANGE SCAN I_SUMKEY$_1 (object id 2749894) ******************************************************************************** select text from sumkey$ where rowid = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 14.84 0 0 0 0 Execute 51 100.00 38.14 0 0 0 0 Fetch 51 0.00 29.44 0 102 0 51 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 106 100.00 82.42 0 102 0 51 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 13 TABLE ACCESS BY USER ROWID SUMKEY$ ******************************************************************************** select detailobj#, detailobjtype, detailalias, refreshscn, detaileut, spare4, inline#, instance#, dataless from sumdetail$ where sumobj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 17.51 0 0 0 0 Execute 4 100.00 59.31 0 0 0 0 Fetch 14 0.00 7.58 0 28 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22 100.00 84.40 0 28 0 10 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID SUMDETAIL$ 1 INDEX RANGE SCAN I_SUMDETAIL$_1 (object id 258274) ******************************************************************************** SELECT MSI.SEGMENT1 PART_NUMBER, MSI.INVENTORY_ITEM_ID ITEM_ID, MSI.DESCRIPTION DESCRIPTION, MSI.INVENTORY_ITEM_STATUS_CODE ITEM_STATUS, MSI.ORGANIZATION_ID ORG_ID, MP.ORGANIZATION_CODE ORG_CODE, MSI.BUYER_ID BUYER,MC.SEGMENT1 ENG_DIVISION,MSI.ITEM_TYPE ITEM_TYPE, NVL (MSI.FULL_LEAD_TIME, 0) LEAD_TIME, MSI.PLANNER_CODE PLANNER_CODE, MOQ.SUBINVENTORY_CODE, MOQ.ONHAND_QTY, ROUND (NVL (CIS.ITEM_COST, 0), 2) ITEM_COST FROM MTL_SYSTEM_ITEMS_B MSI, MTL_ITEM_CATEGORIES MIC, MTL_CATEGORIES MC, MTL_PARAMETERS MP, CST_ITEM_COSTS CIS, ( SELECT MOQ.INVENTORY_ITEM_ID, MOQ.ORGANIZATION_ID,MOQ.SUBINVENTORY_CODE, NVL (SUM (MOQ.TRANSACTION_QUANTITY), 0) ONHAND_QTY FROM MTL_ONHAND_QUANTITIES MOQ, MTL_SECONDARY_INVENTORIES MSI WHERE MOQ.SUBINVENTORY_CODE = MSI.SECONDARY_INVENTORY_NAME AND MOQ.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND ((MSI.DISABLE_DATE IS NOT NULL) OR (MSI.ASSET_INVENTORY = 2) OR (MSI.ASSET_INVENTORY = 1 AND MSI.AVAILABILITY_TYPE = 2)) GROUP BY MOQ.INVENTORY_ITEM_ID, MOQ.ORGANIZATION_ID,MOQ.SUBINVENTORY_CODE HAVING SUM (MOQ.TRANSACTION_QUANTITY) > 0) MOQ WHERE MP.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MOQ.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MOQ.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIC.ORGANIZATION_ID = 86 AND MIC.CATEGORY_SET_ID = 65 AND MC.CATEGORY_ID = MIC.CATEGORY_ID AND CIS.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND CIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND CIS.COST_TYPE_ID = 1 ORDER BY 2, 4 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 8200.00 9324.22 112 1011 0 0 Execute 1 0.00 2.76 0 0 0 0 Fetch 163282315200.00 3581166.22 647726 3492111 0 16327 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 163302323400.00 3590493.20 647838 3493122 0 16327 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 16327 FILTER 16352 SORT GROUP BY 23826 NESTED LOOPS 23826 HASH JOIN 12092 TABLE ACCESS FULL MTL_CATEGORIES_B 23826 HASH JOIN 21 TABLE ACCESS FULL MTL_PARAMETERS 23826 HASH JOIN 23826 HASH JOIN 275 TABLE ACCESS FULL MTL_SECONDARY_INVENTORIES 253260 HASH JOIN 254220 TABLE ACCESS FULL MTL_ONHAND_QUANTITIES_DETAIL 1556403 HASH JOIN 312930 INDEX RANGE SCAN MTL_ITEM_CATEGORIES_U1 (object id 541812) 1570822 TABLE ACCESS FULL MTL_SYSTEM_ITEMS_B 1357716 TABLE ACCESS BY INDEX ROWID CST_ITEM_COSTS 1357716 INDEX SKIP SCAN CST_ITEM_COSTS_N2 (object id 140576) 23826 INDEX UNIQUE SCAN MTL_CATEGORIES_TL_U1 (object id 492009) ******************************************************************************** INSERT INTO CUSTOM.PWR_WB_INV_TURNS (PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, BUYER, PLANNER, ATTRIBUTE51, ATTRIBUTE57, ATTRIBUTE58, ATTRIBUTE59, ATTRIBUTE1, ATTRIBUTE4, CREATION_DATE, CREATED_BY ) VALUES (:B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , SYSDATE, :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 33.03 0 0 0 0 Execute 16327 95500.00 117391.48 2051 1337 138864 16327 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16328 95500.00 117424.51 2051 1337 138864 16327 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** SELECT GSB.CURRENCY_CODE FROM ORG_ORGANIZATION_DEFINITIONS OOD, GL_SETS_OF_BOOKS GSB WHERE OOD.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID AND OOD.ORGANIZATION_ID=:B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 200.00 387.80 2 4 0 0 Execute 16327 40500.00 38909.35 0 0 0 0 Fetch 32654 531100.00 518907.56 91 943086 0 16327 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 48982 571800.00 558204.71 93 943090 0 16327 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 16327 MERGE JOIN CARTESIAN 16327 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION 571445 NESTED LOOPS 277559 NESTED LOOPS 277559 MERGE JOIN CARTESIAN 16327 NESTED LOOPS 16327 NESTED LOOPS 16327 NESTED LOOPS 16327 INDEX UNIQUE SCAN MTL_PARAMETERS_U1 (object id 139915) 16327 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (object id 496503) 16327 TABLE ACCESS BY INDEX ROWID HR_ALL_ORGANIZATION_UNITS 16327 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (object id 142268) 16327 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION 30538 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (object id 3347785) 277559 BUFFER SORT 277559 INDEX FULL SCAN GL_SETS_OF_BOOKS_U2 (object id 136592) 277559 TABLE ACCESS BY INDEX ROWID GL_SETS_OF_BOOKS 277559 INDEX UNIQUE SCAN GL_SETS_OF_BOOKS_U2 (object id 136592) 277559 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (object id 3347785) 16327 BUFFER SORT 16327 TABLE ACCESS FULL FND_PRODUCT_GROUPS ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE20 = :B5 , ATTRIBUTE3 = :B3 , ATTRIBUTE2=ROUND (:B4 * :B3 , 4) WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = 'DAYS WORTH OF SUPPLY' AND INV_ORG_ID = :B2 AND INVENTORY_ITEM_ID=:B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 17.17 0 0 0 0 Execute 16327 113000.00 159779.03 7081 93757 17789 17357 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16328 113000.00 159796.20 7081 93757 17789 17357 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 17357 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 43766 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT ROUND (CONVERSION_RATE, 4) FROM GL_DAILY_RATES WHERE FROM_CURRENCY = :B1 AND TO_CURRENCY = 'USD' AND CONVERSION_TYPE = 'Corporate' AND TRUNC (CONVERSION_DATE) = TRUNC (SYSDATE) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 30.43 0 0 0 0 Execute 15445 16000.00 16986.48 0 0 0 0 Fetch 154452384500.00 2351255.52 161 422315 0 15445 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 308912400500.00 2368272.43 161 422315 0 15445 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 15445 TABLE ACCESS BY INDEX ROWID GL_DAILY_RATES 15445 INDEX RANGE SCAN GL_DAILY_RATES_U1 (object id 136499) ******************************************************************************** SELECT INVENTORY_ITEM_ID, INV_ORG_ID FROM CUSTOM.PWR_WB_INV_TURNS WHERE PROCESS_TYPE = :B2 AND ATTRIBUTE_CONTEXT = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 100.00 77.45 5 5 0 0 Execute 2 0.00 17.55 0 0 0 0 Fetch 32656 178000.00 206251.48 79547 124167 0 32654 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 32660 178100.00 206346.48 79552 124172 0 32654 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 16327 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** SELECT NVL (SUM (USING_REQUIREMENTS_QUANTITY) * 4, 0) FROM MRP_GROSS_REQUIREMENTS WHERE UPPER (COMPILE_DESIGNATOR) = 'P1-MRP' AND USING_ASSEMBLY_DEMAND_DATE BETWEEN SYSDATE AND ADD_MONTHS (SYSDATE, 3) AND INVENTORY_ITEM_ID = :B2 AND ORGANIZATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 26.48 0 0 0 0 Execute 16327 20100.00 22125.76 0 0 0 0 Fetch 16327 306700.00 2753210.98 52991 164339 0 16327 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 32655 326900.00 2775363.22 52991 164339 0 16327 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 16327 SORT AGGREGATE 150365 FILTER 150365 TABLE ACCESS BY INDEX ROWID MRP_GROSS_REQUIREMENTS 1134936 INDEX RANGE SCAN MRP_GROSS_REQUIREMENTS_10 (object id 140707) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE53 = :B5 WHERE INVENTORY_ITEM_ID = :B4 AND INV_ORG_ID = :B3 AND PROCESS_TYPE = :B2 AND ATTRIBUTE_CONTEXT = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 14.99 0 0 0 0 Execute 16327 103200.00 103960.03 8577 93689 19215 18387 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16328 103200.00 103975.02 8577 93689 19215 18387 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 18387 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 44796 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** SELECT ROUND (ABS (NVL (SUM (MMT.TRANSACTION_QUANTITY) * 4, 0)), 0) FROM MTL_MATERIAL_TRANSACTIONS MMT WHERE MMT.TRANSACTION_TYPE_ID IN ( SELECT LOOKUP_CODE FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'PWR_MINMAX_TRANS_TYPE_ID' AND ENABLED_FLAG = 'Y') AND MMT.ORGANIZATION_ID = :B2 AND MMT.INVENTORY_ITEM_ID = :B1 AND MMT.TRANSACTION_DATE BETWEEN ADD_MONTHS (SYSDATE, -6) AND SYSDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 700.00 670.06 0 0 0 0 Execute 16327 30100.00 26795.78 0 0 0 0 Fetch 163272380100.00 7789556.87 380279 3604747 0 16327 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 326552410900.00 7817022.71 380279 3604747 0 16327 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 16327 SORT AGGREGATE 606474 FILTER 606474 NESTED LOOPS SEMI 1062881 TABLE ACCESS BY INDEX ROWID MTL_MATERIAL_TRANSACTIONS 1062881 INDEX RANGE SCAN MTL_MATERIAL_TRANSACTIONS_N1 (object id 139889) 606474 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 606474 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE52 = :B5 WHERE INVENTORY_ITEM_ID = :B4 AND INV_ORG_ID = :B3 AND PROCESS_TYPE = :B2 AND ATTRIBUTE_CONTEXT = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 18.10 0 0 0 0 Execute 16327 115000.00 115799.39 9756 93665 19308 18387 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16328 115000.00 115817.49 9756 93665 19308 18387 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 18387 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 44796 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE54 = ROUND (GREATEST (TO_NUMBER(ATTRIBUTE52), TO_NUMBER(ATTRIBUTE53)) / 365), ATTRIBUTE55 = DECODE (ROUND (GREATEST (TO_NUMBER(ATTRIBUTE52), TO_NUMBER(ATTRIBUTE53)) / 365), 0, 0, ROUND ( TO_NUMBER(ATTRIBUTE51) / ROUND ( GREATEST (TO_NUMBER(ATTRIBUTE52), TO_NUMBER(ATTRIBUTE53) ) / 365 ) ) ), ATTRIBUTE56 = DECODE (ROUND (GREATEST (TO_NUMBER(ATTRIBUTE52), TO_NUMBER(ATTRIBUTE53)) / 365), 0, 0, ROUND ( ( TO_NUMBER(ATTRIBUTE51) - ( ROUND ( GREATEST (TO_NUMBER(ATTRIBUTE52), TO_NUMBER(ATTRIBUTE53) ) / 365 ) * TO_NUMBER(ATTRIBUTE58) ) ) / ROUND ( GREATEST (TO_NUMBER(ATTRIBUTE52), TO_NUMBER(ATTRIBUTE53)) / 365 ) / 5 ) ) WHERE PROCESS_TYPE = :B2 AND ATTRIBUTE_CONTEXT = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 31.55 0 0 0 0 Execute 1 101200.00 99785.20 39308 39932 17028 16327 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 101200.00 99816.75 39308 39932 17028 16327 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 16327 TABLE ACCESS FULL PWR_WB_INV_TURNS ******************************************************************************** select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 3.30 0 0 0 0 Execute 3 0.00 4.34 0 0 0 0 Fetch 3 0.00 346.81 7 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 354.45 7 9 0 3 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID OBJ#(57) 2 INDEX UNIQUE SCAN OBJ#(86) (object id 86) ******************************************************************************** select bo#, intcol# from icoldep$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 100.00 328.78 8 20 0 0 Execute 7 200.00 43.40 0 0 0 0 Fetch 18 0.00 148.35 5 36 0 11 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 300.00 520.53 13 56 0 11 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 4 TABLE ACCESS BY INDEX ROWID OBJ#(258244) 4 INDEX RANGE SCAN OBJ#(258245) (object id 258245) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS P1 SET BUYER = (SELECT FULL_NAME FROM PER_PEOPLE_V7 WHERE PERSON_ID = TO_NUMBER (P1.BUYER) AND BUSINESS_GROUP_ID = 21) WHERE P1.PROCESS_TYPE = :B2 AND P1.ATTRIBUTE_CONTEXT = :B1 AND P1.BUYER IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 2000.00 2322.52 229 931 0 0 Execute 2 224600.00 253576.72 80051 100323 83833 41156 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 226600.00 255899.24 80280 101254 83833 41156 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 13876 TABLE ACCESS FULL PWR_WB_INV_TURNS 804 FILTER 805 NESTED LOOPS OUTER 805 NESTED LOOPS OUTER 805 NESTED LOOPS OUTER 805 NESTED LOOPS OUTER 805 NESTED LOOPS OUTER 805 NESTED LOOPS OUTER 804 NESTED LOOPS 804 NESTED LOOPS 804 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 804 INDEX RANGE SCAN PER_PEOPLE_F_PK (object id 142418) 141 SORT AGGREGATE 217 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 217 INDEX RANGE SCAN PER_PEOPLE_F_PK (object id 142418) 804 INDEX UNIQUE SCAN PER_PERSON_TYPES_PK (object id 142488) 804 INDEX UNIQUE SCAN PER_PERSON_TYPES_TL_PK (object id 496505) 805 TABLE ACCESS BY INDEX ROWID PER_PERIODS_OF_SERVICE 805 INDEX RANGE SCAN PER_PERIODS_OF_SERVICE_N3 (object id 137559) 129 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 129 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 175 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 175 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 0 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 0 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 805 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 805 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 3 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 3 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 141 SORT AGGREGATE 142 TABLE ACCESS BY INDEX ROWID PER_PERIODS_OF_SERVICE 142 INDEX RANGE SCAN PER_PERIODS_OF_SERVICE_N3 (object id 137559) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS SET ATTRIBUTE60 = :B7 , ATTRIBUTE61 = :B6 , ATTRIBUTE62 = :B5 , ATTRIBUTE63 = :B4 WHERE PROCESS_TYPE = 'BACKGROUND' AND ATTRIBUTE_CONTEXT = :B3 AND INVENTORY_ITEM_ID = :B2 AND INV_ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 23.98 0 0 0 0 Execute 16327 125400.00 122181.09 9073 93737 36131 18387 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16328 125400.00 122205.07 9073 93737 36131 18387 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 18387 TABLE ACCESS BY INDEX ROWID PWR_WB_INV_TURNS 44796 INDEX RANGE SCAN PWR_INVTRN_ITMORG (object id 1854910) ******************************************************************************** UPDATE CUSTOM.PWR_WB_INV_TURNS P1 SET PLANNER = (SELECT PP.FULL_NAME FROM MTL_PLANNERS MPL, PER_PEOPLE_V7 PP WHERE MPL.PLANNER_CODE = P1.PLANNER AND PP.PERSON_ID = MPL.EMPLOYEE_ID AND MPL.ORGANIZATION_ID = P1.INV_ORG_ID AND PP.BUSINESS_GROUP_ID = 21) WHERE PROCESS_TYPE = :B2 AND ATTRIBUTE_CONTEXT = :B1 AND P1.PLANNER IS NOT NULL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 400.00 520.89 6 19 0 0 Execute 2 260200.00 262302.15 79951 141999 94324 44878 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 260600.00 262823.04 79957 142018 94324 44878 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 15820 TABLE ACCESS FULL PWR_WB_INV_TURNS 2094 FILTER 2094 NESTED LOOPS OUTER 2094 NESTED LOOPS OUTER 2094 NESTED LOOPS OUTER 2094 NESTED LOOPS OUTER 2094 NESTED LOOPS OUTER 2094 NESTED LOOPS OUTER 2094 NESTED LOOPS 2094 NESTED LOOPS 2094 NESTED LOOPS 2094 TABLE ACCESS BY INDEX ROWID MTL_PLANNERS 2150 INDEX UNIQUE SCAN MTL_PLANNERS_U1 (object id 139932) 2094 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 2094 INDEX RANGE SCAN PER_PEOPLE_F_PK (object id 142418) 434 SORT AGGREGATE 497 TABLE ACCESS BY INDEX ROWID PER_ALL_PEOPLE_F 497 INDEX RANGE SCAN PER_PEOPLE_F_PK (object id 142418) 2094 INDEX UNIQUE SCAN PER_PERSON_TYPES_PK (object id 142488) 2094 INDEX UNIQUE SCAN PER_PERSON_TYPES_TL_PK (object id 496505) 2094 TABLE ACCESS BY INDEX ROWID PER_PERIODS_OF_SERVICE 2094 INDEX RANGE SCAN PER_PERIODS_OF_SERVICE_N3 (object id 137559) 122 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 122 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 290 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 290 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 0 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 0 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 2094 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 2094 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 31 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 31 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 434 SORT AGGREGATE 434 TABLE ACCESS BY INDEX ROWID PER_PERIODS_OF_SERVICE 434 INDEX RANGE SCAN PER_PERIODS_OF_SERVICE_N3 (object id 137559) ******************************************************************************** SELECT NEXT_DAY (SYSDATE, 'SUN') FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 24.02 0 0 0 0 Execute 1 0.00 1.52 0 0 0 0 Fetch 1 0.00 4.17 1 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 29.71 1 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL DUAL ******************************************************************************** select default$ from col$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 9 0.00 12.26 0 0 0 0 Execute 9 0.00 9.07 0 0 0 0 Fetch 9 0.00 17.60 4 18 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 0.00 38.93 4 18 0 9 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID COL$ ******************************************************************************** select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP', defschclass) from user$ where user#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 19.98 0 0 0 0 Execute 2 100.00 83.89 0 0 0 0 Fetch 2 0.00 115.32 3 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 100.00 219.19 3 6 0 2 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER USER$ 1 INDEX UNIQUE SCAN I_USER# (object id 11) ******************************************************************************** SELECT DISTINCT PL.ITEM_ID, PD.DESTINATION_ORGANIZATION_ID DEST_ORG_ID, PH.SEGMENT1 PO_NO, PH.VENDOR_ID, PV.VENDOR_NAME, MSI.SEGMENT1 PART_NUMBER, MSI.INVENTORY_ITEM_STATUS_CODE ITEM_STATUS, MP.ORGANIZATION_CODE ORG_CODE, MSI.ITEM_TYPE ITEM_TYPE, MSI.BUYER_ID BUYER_ID, MSI.PLANNER_CODE PLANNER_CODE FROM PO_HEADERS_ALL PH, PO_LINES_ALL PL, PO_DISTRIBUTIONS_ALL PD, PO_VENDORS PV, MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP WHERE PD.PO_HEADER_ID = PL.PO_HEADER_ID AND PD.PO_LINE_ID = PL.PO_LINE_ID AND PD.PO_HEADER_ID = PH.PO_HEADER_ID AND PL.PO_HEADER_ID = PH.PO_HEADER_ID AND PH.TYPE_LOOKUP_CODE = 'STANDARD' AND PH.CLOSED_CODE = 'OPEN' AND PH.AUTHORIZATION_STATUS = 'APPROVED' AND PL.CLOSED_CODE = 'OPEN' AND PV.VENDOR_ID = PH.VENDOR_ID AND MP.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MSI.ORGANIZATION_ID = PD.DESTINATION_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = PL.ITEM_ID ORDER BY 1, 2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 6200.00 14717.36 159 997 0 0 Execute 1 0.00 2.63 0 0 0 0 Fetch 31576 563200.00 2277011.68 125438 602846 0 31575 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31578 569400.00 2291731.67 125597 603843 0 31575 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 31575 SORT UNIQUE 37386 NESTED LOOPS 37386 NESTED LOOPS 37561 NESTED LOOPS 37561 NESTED LOOPS 65859 HASH JOIN 43848 TABLE ACCESS FULL PO_LINES_ALL 1093744 TABLE ACCESS FULL PO_DISTRIBUTIONS_ALL 37561 TABLE ACCESS BY INDEX ROWID PO_HEADERS_ALL 65855 INDEX UNIQUE SCAN PO_HEADERS_U1 (object id 140162) 37561 TABLE ACCESS BY INDEX ROWID PO_VENDORS 37561 INDEX UNIQUE SCAN PO_VENDORS_U1 (object id 140304) 37386 TABLE ACCESS BY INDEX ROWID MTL_SYSTEM_ITEMS_B 37386 INDEX UNIQUE SCAN MTL_SYSTEM_ITEMS_B_U1 (object id 139976) 37386 TABLE ACCESS BY INDEX ROWID MTL_PARAMETERS 37386 INDEX UNIQUE SCAN MTL_PARAMETERS_U1 (object id 139915) ******************************************************************************** SELECT ROUND (NVL ( SUM ( PD.QUANTITY_ORDERED - ( PD.QUANTITY_DELIVERED + PD.QUANTITY_CANCELLED ) ) * MIN (PL.UNIT_PRICE), 0 ), 2 ) QTY FROM PO_DISTRIBUTIONS_ALL PD, PO_HEADERS_ALL PH, PO_LINES_ALL PL, MTL_SUPPLY MS WHERE PH.TYPE_LOOKUP_CODE = 'STANDARD' AND PH.CLOSED_CODE = 'OPEN' AND PH.AUTHORIZATION_STATUS = 'APPROVED' AND PL.CLOSED_CODE = 'OPEN' AND PH.PO_HEADER_ID = PL.PO_HEADER_ID AND PD.PO_HEADER_ID = PH.PO_HEADER_ID AND PD.PO_LINE_ID = PL.PO_LINE_ID AND MS.PO_HEADER_ID = PD.PO_HEADER_ID AND MS.PO_LINE_ID = PD.PO_LINE_ID AND MS.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID AND TRUNC (NVL (MS.RECEIPT_DATE, MS.NEED_BY_DATE)) <= TRUNC (:B3 ) AND PH.VENDOR_ID = :B2 AND PL.ITEM_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 300.00 416.44 5 13 0 0 Execute 31575 102200.00 100653.15 0 0 0 0 Fetch 3157515425700.0016468968.50 1184055 55419371 0 31575 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6315115528200.0016570038.09 1184060 55419384 0 31575 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 31575 SORT AGGREGATE 28919 TABLE ACCESS BY INDEX ROWID MTL_SUPPLY 535254 NESTED LOOPS 460568 NESTED LOOPS 393774 NESTED LOOPS 6726422 TABLE ACCESS BY INDEX ROWID PO_HEADERS_ALL 33282863 INDEX RANGE SCAN PO_HEADERS_N1 (object id 3399017) 393774 TABLE ACCESS BY INDEX ROWID PO_LINES_ALL 27017184 INDEX RANGE SCAN PO_LINES_U2 (object id 140185) 460568 TABLE ACCESS BY INDEX ROWID PO_DISTRIBUTIONS_ALL 460568 INDEX RANGE SCAN PO_DISTRIBUTIONS_N4 (object id 140141) 43111 INDEX RANGE SCAN MTL_SUPPLY_N2 (object id 139966) ******************************************************************************** SELECT ROUND (NVL ( SUM ( PD.QUANTITY_ORDERED - ( PD.QUANTITY_DELIVERED + PD.QUANTITY_CANCELLED ) ) * MIN (PL.UNIT_PRICE), 0 ), 2 ) QTY FROM PO_DISTRIBUTIONS_ALL PD, PO_HEADERS_ALL PH, PO_LINES_ALL PL, MTL_SUPPLY MS WHERE PH.TYPE_LOOKUP_CODE = 'STANDARD' AND PH.CLOSED_CODE = 'OPEN' AND PH.AUTHORIZATION_STATUS = 'APPROVED' AND PL.CLOSED_CODE = 'OPEN' AND PH.PO_HEADER_ID = PL.PO_HEADER_ID AND PD.PO_HEADER_ID = PH.PO_HEADER_ID AND PD.PO_LINE_ID = PL.PO_LINE_ID AND MS.PO_HEADER_ID = PD.PO_HEADER_ID AND MS.PO_LINE_ID = PD.PO_LINE_ID AND MS.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID AND TRUNC (NVL (MS.RECEIPT_DATE, MS.NEED_BY_DATE)) BETWEEN TRUNC (:B4 + (7 * (:B3 - 2)) + 1) AND TRUNC (:B4 + (7 * (:B3 - 1))) AND PH.VENDOR_ID = :B2 AND PL.ITEM_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 102.64 0 0 0 0 Execute 5367751924400.00 1848262.91 0 0 0 0 Fetch 5367759259235.20 4462206.24 219442 942129273 0 536775 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 107355111183735.20 6310571.79 219442 942129273 0 536775 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 536775 SORT AGGREGATE 11645 FILTER 11645 TABLE ACCESS BY INDEX ROWID MTL_SUPPLY 9099318 NESTED LOOPS 7829656 NESTED LOOPS 6694158 NESTED LOOPS 114349174 TABLE ACCESS BY INDEX ROWID PO_HEADERS_ALL 565808671 INDEX RANGE SCAN PO_HEADERS_N1 (object id 3399017) 6694158 TABLE ACCESS BY INDEX ROWID PO_LINES_ALL 459292128 INDEX RANGE SCAN PO_LINES_U2 (object id 140185) 7829656 TABLE ACCESS BY INDEX ROWID PO_DISTRIBUTIONS_ALL 7829656 INDEX RANGE SCAN PO_DISTRIBUTIONS_N4 (object id 140141) 732887 INDEX RANGE SCAN MTL_SUPPLY_N2 (object id 139966) ******************************************************************************** SELECT ROUND (NVL ( SUM ( PD.QUANTITY_ORDERED - ( PD.QUANTITY_DELIVERED + PD.QUANTITY_CANCELLED ) ) * MIN (PL.UNIT_PRICE), 0 ), 2 ) QTY FROM PO_DISTRIBUTIONS_ALL PD, PO_HEADERS_ALL PH, PO_LINES_ALL PL, MTL_SUPPLY MS WHERE PH.TYPE_LOOKUP_CODE = 'STANDARD' AND PH.CLOSED_CODE = 'OPEN' AND PH.AUTHORIZATION_STATUS = 'APPROVED' AND PL.CLOSED_CODE = 'OPEN' AND PH.PO_HEADER_ID = PL.PO_HEADER_ID AND PD.PO_HEADER_ID = PH.PO_HEADER_ID AND PD.PO_LINE_ID = PL.PO_LINE_ID AND MS.PO_HEADER_ID = PD.PO_HEADER_ID AND MS.PO_LINE_ID = PD.PO_LINE_ID AND MS.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID AND TRUNC (NVL (MS.RECEIPT_DATE, MS.NEED_BY_DATE)) >= TRUNC (:B3 - (7 * 18)) AND PH.VENDOR_ID = :B2 AND PL.ITEM_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 200.00 105.78 0 0 0 0 Execute 31575 109800.00 104876.90 0 0 0 0 Fetch 3157512921300.0012641793.82 7506 55419369 0 31575 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6315113031300.0012746776.50 7506 55419369 0 31575 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 31575 SORT AGGREGATE 42053 TABLE ACCESS BY INDEX ROWID MTL_SUPPLY 535254 NESTED LOOPS 460568 NESTED LOOPS 393774 NESTED LOOPS 6726422 TABLE ACCESS BY INDEX ROWID PO_HEADERS_ALL 33282863 INDEX RANGE SCAN PO_HEADERS_N1 (object id 3399017) 393774 TABLE ACCESS BY INDEX ROWID PO_LINES_ALL 27017184 INDEX RANGE SCAN PO_LINES_U2 (object id 140185) 460568 TABLE ACCESS BY INDEX ROWID PO_DISTRIBUTIONS_ALL 460568 INDEX RANGE SCAN PO_DISTRIBUTIONS_N4 (object id 140141) 43111 INDEX RANGE SCAN MTL_SUPPLY_N2 (object id 139966) ******************************************************************************** INSERT INTO CUSTOM.PWR_WB_INV_TURNS (PROCESS_TYPE, ATTRIBUTE_CONTEXT, INVENTORY_ITEM_ID, PART_NUMBER, INV_ORG_ID, INV_ORG_CODE, ITEM_TYPE, ITEM_STATUS, PLANNER, BUYER, ATTRIBUTE76, ATTRIBUTE77, ATTRIBUTE78, ATTRIBUTE79, ATTRIBUTE80, ATTRIBUTE81, ATTRIBUTE82, ATTRIBUTE83, ATTRIBUTE84, ATTRIBUTE85, ATTRIBUTE86, ATTRIBUTE87, ATTRIBUTE88, ATTRIBUTE89, ATTRIBUTE90, ATTRIBUTE91, ATTRIBUTE92, ATTRIBUTE93, ATTRIBUTE94, ATTRIBUTE95, ATTRIBUTE96, CREATION_DATE, CREATED_BY ) VALUES (:B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B19 , SYSDATE, :B18 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 39.55 0 0 0 0 Execute 31575 307700.00 595405.32 11538 2571 276631 31575 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31576 307700.00 595444.87 11538 2571 276631 31575 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) ******************************************************************************** declare b boolean; begin b := fnd_debug.disable_db_rules; if (b) then :eget := 1; else :eget := 0; end if; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 3.12 0 0 0 0 Execute 1 0.00 4.34 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 7.46 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** begin fnd_conc_global.get_req_globals( conc_status => :status, request_data => :request_data, conc_restart_time => :restart, release_sub_request => :release); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 22.61 0 0 0 0 Execute 1 100.00 75.96 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 100.00 98.57 0 0 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** begin fnd_file.close; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 1.99 0 0 0 0 Execute 1 0.00 5.02 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 7.01 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** begin fnd_file_private.open (:l, :o); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 1.83 0 0 0 0 Execute 1 0.00 16.40 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 18.23 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** begin fnd_file_private.logfile_get(:s, :b); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.16 0 0 0 0 Execute 2 200.00 153.08 0 0 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 200.00 155.24 0 0 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** begin fnd_file_private.outfile_get(:s, :b); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.55 0 0 0 0 Execute 1 0.00 8.63 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 11.18 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** begin fnd_file_private.close; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 3.04 0 0 0 0 Execute 1 0.00 22.42 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 100.00 25.46 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** begin fnd_conc_stat.store_final; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 200.00 845.45 16 29 0 0 Execute 1 0.00 14.22 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 200.00 859.67 16 29 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** begin FND_LOG_REPOSITORY.METRICS_EVENT_INT_WITH_CONTEXT; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.16 0 0 0 0 Execute 1 0.00 10.52 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 12.68 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** SELECT COUNT(1) FROM FND_LOG_METRICS WHERE TRANSACTION_CONTEXT_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 1.90 0 0 0 0 Execute 1 0.00 1.37 0 0 0 0 Fetch 1 0.00 0.29 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 3.56 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE 0 INDEX RANGE SCAN FND_LOG_METRICS_N1 (object id 906766) ******************************************************************************** select To_Char(To_Date(Decode(Resubmit_Time,null ,'00:00:00',Resubmit_Time), 'HH24:MI:SS')) into :b0 from Fnd_Concurrent_Requests where Request_ID=:b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 1.92 0 0 0 0 Execute 1 0.00 1.32 0 0 0 0 Fetch 1 0.00 7.66 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 10.90 2 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) ******************************************************************************** select FND_CONC_PRIVATE_UTILS.get_resub_time(:b0) into :b1:b2 from DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 18.58 0 0 0 0 Execute 1 0.00 72.73 0 0 0 0 Fetch 1 100.00 50.44 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 200.00 141.75 0 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL DUAL ******************************************************************************** SELECT COUNT(*) FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 24.20 0 0 0 0 Execute 1 0.00 19.18 0 0 0 0 Fetch 1 0.00 0.63 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 100.00 44.01 0 2 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) ******************************************************************************** SELECT RESUBMIT_TIME, RESUBMIT_INTERVAL_TYPE_CODE, REQUESTED_START_DATE, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL, SYSDATE, RELEASE_CLASS_ID, RELEASE_CLASS_APP_ID, RESUBMIT_END_DATE FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 19.56 0 0 0 0 Execute 1 0.00 20.66 0 0 0 0 Fetch 1 0.00 0.85 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 41.07 0 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) ******************************************************************************** SELECT TO_CHAR(DECODE(:B1 , NULL, DECODE (:B4 , 'START', :B3 , :B2 ) + DECODE(:B6 , 'MINUTES', :B5 /1440, 'HOURS', :B5 /24, 'DAYS', :B5 , 'MONTHS', ADD_MONTHS( DECODE(:B4 , 'START', :B3 , :B2 ), :B5 ) - DECODE(:B4 , 'START', :B3 , :B2 )), TO_DATE (TO_CHAR (:B2 , 'DD-MON-YYYY') || ' ' || :B1 , 'DD-MON-YYYY HH24:MI:SS') + DECODE( SIGN(TO_DATE(TO_CHAR(:B2 , 'HH24:MI:SS'), 'HH24:MI:SS') - TO_DATE(:B1 , 'HH24:MI:SS') ), 1, 1, 0)), 'DD-MON-YYYY HH24:MI:SS') FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.00 0 0 0 0 Execute 1 100.00 2.44 0 0 0 0 Fetch 1 0.00 1.27 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 100.00 5.71 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL DUAL ******************************************************************************** SELECT CATEGORY, SEVERITY, FND_LOG_SEVERITY FROM FND_NEW_MESSAGES WHERE MESSAGE_NAME = :B1 AND APPLICATION_ID = :B2 AND LANGUAGE_CODE = :B3 AND ROWNUM = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.61 0 0 0 0 Execute 5 0.00 5.09 0 0 0 0 Fetch 5 0.00 26.36 9 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.00 34.06 9 20 0 5 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 5 COUNT STOPKEY 5 TABLE ACCESS BY INDEX ROWID OBJ#(3726) 5 INDEX UNIQUE SCAN OBJ#(136139) (object id 136139) ******************************************************************************** lock table FND_CONCURRENT_REQUESTS in share update mode call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.14 0 0 0 0 Execute 1 0.00 2.78 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 4.92 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS FULL FND_CONCURRENT_REQUESTS ******************************************************************************** select Has_Sub_Request ,Status_Code ,Outfile_Name ,Logfile_name into :b0,:b1, :b2,:b3 from Fnd_Concurrent_Requests where Request_ID=:b4 for update of Status_Code call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 1.93 0 0 0 0 Execute 1 0.00 8.18 1 3 3 0 Fetch 1 0.00 0.79 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 10.90 1 3 3 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 FOR UPDATE 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) ******************************************************************************** update fnd_concurrent_requests set ofile_size=decode(:b0,'-1',null ,:b0) where request_id=:b2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 24.37 0 0 0 0 Execute 1 0.00 27.65 0 2 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 52.02 0 2 1 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) ******************************************************************************** select phase_code,status_code into :p,:s from fnd_concurrent_requests where request_id=:r call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 1.96 0 0 0 0 Execute 1 0.00 1.15 0 0 0 0 Fetch 1 0.00 1.26 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 4.37 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) ******************************************************************************** SELECT R.PRINT_STYLE, U.USER_NAME, R.REQUEST_ID, R.OUTFILE_NAME, R.OUTFILE_NODE_NAME, R.PRINT_GROUP, R.PRIORITY_REQUEST_ID, R.REQUESTED_BY, R.RESPONSIBILITY_APPLICATION_ID, R.RESPONSIBILITY_ID, R.SECURITY_GROUP_ID, R.CONC_LOGIN_ID, R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID, R.NUMBER_OF_COPIES, P.PRINT_FLAG, R.SAVE_OUTPUT_FLAG, R.ARGUMENT1, P.CONCURRENT_PROGRAM_NAME FROM FND_CONCURRENT_REQUESTS R, FND_USER U, FND_CONCURRENT_PROGRAMS P WHERE R.REQUEST_ID = :reqid AND R.REQUESTED_BY = U.USER_ID AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID AND R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 100.00 52.30 0 0 0 0 Execute 1 100.00 54.73 0 0 0 0 Fetch 1 0.00 14.07 5 9 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 200.00 121.10 5 9 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID OBJ#(3604) 1 INDEX UNIQUE SCAN OBJ#(135956) (object id 135956) 1 TABLE ACCESS BY INDEX ROWID OBJ#(3597) 1 INDEX UNIQUE SCAN OBJ#(135937) (object id 135937) 1 TABLE ACCESS BY INDEX ROWID OBJ#(3783) 1 INDEX UNIQUE SCAN OBJ#(136218) (object id 136218) ******************************************************************************** SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'CP_STATUS_CODE' AND LOOKUP_CODE = :code call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.35 0 0 0 0 Execute 1 0.00 1.55 0 0 0 0 Fetch 1 0.00 13.04 3 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 16.94 3 4 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) ******************************************************************************** SELECT ACTION_TYPE, DECODE(STATUS_S_FLAG, 'Y', 1, 0), DECODE(STATUS_W_FLAG, 'Y', 1, 0), DECODE(STATUS_F_FLAG, 'Y', 1, 0), PROGRAM_APPLICATION_ID, PROGRAM_ID, ARGUMENTS, NUMBER_OF_COPIES, SEQUENCE FROM FND_CONC_PP_ACTIONS WHERE CONCURRENT_REQUEST_ID= :reqid AND NVL(COMPLETED, 'N') = 'N' ORDER BY DECODE(ACTION_TYPE, 6, 0, ACTION_TYPE), SEQUENCE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 20.79 0 0 0 0 Execute 1 100.00 66.81 0 0 0 0 Fetch 1 100.00 13.25 4 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 200.00 100.85 4 4 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID OBJ#(3608) 1 INDEX RANGE SCAN OBJ#(149397) (object id 149397) ******************************************************************************** DECLARE PRAGMA AUTONOMOUS_TRANSACTION;BEGIN UPDATE FND_CONC_PP_ACTIONS SET COMPLETED = 'Y' WHERE CONCURRENT_REQUEST_ID= :reqid AND SEQUENCE = :seq; COMMIT; END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 21.36 0 0 0 0 Execute 1 400.00 202.04 0 0 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 400.00 223.40 0 0 1 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 ******************************************************************************** UPDATE FND_CONC_PP_ACTIONS SET COMPLETED = 'Y' WHERE CONCURRENT_REQUEST_ID= :B2 AND SEQUENCE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 32.37 0 0 0 0 Execute 1 0.00 25.54 2 3 4 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 57.91 2 3 4 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 64 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 1 INDEX RANGE SCAN FND_CONC_PP_ACTIONS_N1 (object id 149397) ******************************************************************************** update Fnd_Concurrent_Requests set Phase_Code=DECODE(phase_code,'C', phase_code,:b0),Status_Code=DECODE(phase_code,'C',DECODE(status_code,'C', DECODE(:b1,'W','W','C'),status_code),:b1),Completion_Text= DECODE(Completion_Text,null ,:b3,Completion_Text),Has_Sub_Request= DECODE(Has_Sub_Request,'Y','Y',:b4),Req_Information=:b5, Actual_Completion_Date=sysdate ,Requested_Start_Date=DECODE(:b6,'Y', TO_DATE(:b7,'YYYY/MM/DD HH24:MI:SS'),Requested_Start_Date),Resubmitted=:b6, Outcome_Product=:b9,Outcome_Code=null ,OFile_Size=decode(:b10,'-1',null , :b10),LFile_Size=decode(:b12,'-1',null ,:b12) where Request_Id=:b14 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.36 0 0 0 0 Execute 1 100.00 24.91 6 2 17 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 100.00 27.27 6 2 17 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) ******************************************************************************** update FND_CONC_PROG_ONSITE_INFO set (LAST_RUN_DATE,LAST_RUN_REQUEST_ID, OUTCOME,SUCCESSFUL_COMPLETION,WARNING_COMPLETION,ERROR_COMPLETION, LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,MIN_RUN_TIME, MAX_RUN_TIME,AVG_RUN_TIME)=(select sysdate ,R.request_id ,STATUS_CODE , (NVL(SUCCESSFUL_COMPLETION,0)+DECODE(STATUS_CODE,'C',1,0)) , (NVL(WARNING_COMPLETION,0)+DECODE(STATUS_CODE,'G',1,0)) , (NVL(ERROR_COMPLETION,0)+DECODE(STATUS_CODE,'E',1,0)) ,sysdate ,:b0 ,:b0 , DECODE(STATUS_CODE,'C',LEAST(NVL(MIN_RUN_TIME, ((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)), ((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)),MIN_RUN_TIME) , DECODE(STATUS_CODE,'C',GREATEST(NVL(MAX_RUN_TIME, ((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)), ((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)),MAX_RUN_TIME) , DECODE(STATUS_CODE,'C',(((NVL(AVG_RUN_TIME,0)* NVL(SUCCESSFUL_COMPLETION,0)) +((ACTUAL_COMPLETION_DATE-ACTUAL_START_DATE)* 86400)) /DECODE(NVL(AVG_RUN_TIME,0),0,1,(NVL(SUCCESSFUL_COMPLETION,0)+1))), AVG_RUN_TIME) from FND_CONCURRENT_REQUESTS R ,FND_CONC_PROG_ONSITE_INFO O where ((R.program_application_id=O.Program_Application_Id and R.Concurrent_Program_Id=O.concurrent_program_id) and R.request_id=:b2)) where (Program_Application_Id,Concurrent_Program_Id) in (select program_application_id ,concurrent_program_id from fnd_concurrent_requests where request_id=:b2) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.90 0 0 0 0 Execute 1 0.00 120.05 3 11 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 122.95 3 11 1 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (object id 591580) 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PROG_ONSITE_INFO 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (object id 591580) ******************************************************************************** select Phase_Code ,Status_Code ,Completion_Text ,Phase.Lookup_Code , Status.Lookup_Code ,Phase.Meaning ,Status.Meaning into :b0,:b1,:b2,:b3,:b4, :b5,:b6 from Fnd_Lookups Phase ,Fnd_Lookups Status ,Fnd_Concurrent_programs P , Fnd_Concurrent_Requests R where (((((R.Request_Id=:b7 and (P.Concurrent_Program_Id=R.Concurrent_program_ID and P.Application_ID= R.Program_Application_ID)) and Phase.Lookup_Type=:b8) and Phase.Lookup_Code= Decode(Status.Lookup_Code,'H','I','S','I','U','I','M','I',R.Phase_Code)) and Status.Lookup_Type=:b9) and Status.Lookup_Code=Decode(R.Phase_Code,'P', Decode(R.Hold_Flag,'Y','H',Decode(P.Enabled_Flag,'N','U', Decode(Sign((R.Requested_Start_Date-sysdate )),1,'P',R.Status_Code))),'R', Decode(R.Hold_Flag,'Y','S',Decode(R.Status_Code,'Q','B','I','B', R.Status_Code)),R.Status_Code)) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 2.77 0 0 0 0 Execute 1 0.00 2.89 0 0 0 0 Fetch 1 100.00 14.49 2 14 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 100.00 20.15 2 14 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 3 NESTED LOOPS 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 135937) 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 484611) ******************************************************************************** select transaction_context_id into :b0 from fnd_log_transaction_context where (transaction_type='REQUEST' and transaction_id=:b1) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 1.95 0 0 0 0 Execute 1 0.00 1.14 0 0 0 0 Fetch 1 0.00 8.75 4 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 11.84 4 4 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID FND_LOG_TRANSACTION_CONTEXT 0 INDEX RANGE SCAN FND_LOG_TRANSACTION_CONTEXT_N2 (object id 1631411) ******************************************************************************** select nvl(CP.DELETE_LOG_FILE,'N') ,CR.LOGFILE_NAME ,STATUS_CODE ,PHASE_CODE into :b0,:b1,:b2,:b3 from FND_CONCURRENT_REQUESTS CR ,FND_CONCURRENT_PROGRAMS CP where ((CR.REQUEST_ID= :b4 and CR.CONCURRENT_PROGRAM_ID=CP.CONCURRENT_PROGRAM_ID) and CR.PROGRAM_APPLICATION_ID=CP.APPLICATION_ID) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 3.05 0 0 0 0 Execute 1 0.00 1.20 0 0 0 0 Fetch 1 0.00 1.84 0 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 6.09 0 6 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 135956) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 135937) ******************************************************************************** UPDATE FND_CONCURRENT_PROCESSES SET PROCESS_STATUS_CODE = 'C', LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = :mgrusrid, LAST_TXN_START = SYSDATE, LAST_TXN_END = NULL WHERE CONCURRENT_PROCESS_ID = :cpid call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 1.86 0 0 0 0 Execute 1 100.00 21.55 5 2 10 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 100.00 23.41 5 2 10 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 64 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN OBJ#(135934) (object id 135934) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 28 700.00 1189.55 16 29 0 0 Execute 343123397.4428447092.41 77301163 1228690755 27384258 18 Fetch 15 300.00 151.95 29 70 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 773124397.4428448433.91 77301208 1228690854 27384258 32 Misses in library cache during parse: 9 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1289 64700.00 86069.66 847 4335 0 0 Execute 392313432614081.1242042973.17 69688051 126566787 26536630 7251647 Fetch 393699440930962.2413615454.13 7615299 1102142370 0 3846355 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 786141730660070.4012794824.00 77304197 1228713492 26536630 11098002 Misses in library cache during parse: 87 Misses in library cache during execute: 5 121 user SQL statements in session. 1199 internal SQL statements in session. 1320 SQL statements in session. ******************************************************************************** Trace file: cost_ora_8499_REDDYS_CR54518907.trc Trace file compatibility: 8.00.04 Sort options: default 0 session in tracefile. 121 user SQL statements in trace file. 1199 internal SQL statements in trace file. 1320 SQL statements in trace file. 153 unique SQL statements in trace file. 30363365 lines in trace file.