TKPROF: Release 11.2.0.3.0 - Development on Mon Jul 15 03:30:02 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: egipt1_ora_10926.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 ******************************************************************************** error connecting to database using: apps_global/I0svcA_NWlRaKo ORA-12162: TNS:net service name is incorrectly specified EXPLAIN PLAN option disabled. ******************************************************************************** SQL ID: 0ncpd061ggvfg Plan Hash: 0 ALTER SESSION SET sql_trace = FALSE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 0 0 0 Misses in library cache during parse: 4 Optimizer mode: ALL_ROWS Parsing user id: 51 ******************************************************************************** SQL ID: cjf5yfgtsjpsr Plan Hash: 0 ALTER SESSION SET sql_trace = TRUE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 4 Optimizer mode: ALL_ROWS Parsing user id: 51 ******************************************************************************** SQL ID: 7ng34ruy5awxq Plan Hash: 3992920156 select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property, i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey, i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256), i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null, null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 7 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 7 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 SORT ORDER BY (cr=7 pr=0 pw=0 time=513 us cost=7 size=388 card=2) 2 2 2 HASH JOIN OUTER (cr=7 pr=0 pw=0 time=456 us cost=6 size=388 card=2) 2 2 2 NESTED LOOPS OUTER (cr=4 pr=0 pw=0 time=53 us cost=2 size=302 card=2) 2 2 2 TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=24 us cost=2 size=198 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=11 us cost=1 size=0 card=1)(object id 3) 0 0 0 TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=1 pr=0 pw=0 time=14 us cost=0 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=1 pr=0 pw=0 time=5 us cost=0 size=0 card=1)(object id 433) 0 0 0 VIEW (cr=3 pr=0 pw=0 time=48 us cost=3 size=43 card=1) 0 0 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=45 us cost=3 size=15 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=3 pr=0 pw=0 time=26 us cost=2 size=15 card=1) 2 2 2 INDEX RANGE SCAN I_CDEF2 (cr=2 pr=0 pw=0 time=16 us cost=1 size=0 card=4)(object id 54) ******************************************************************************** SQL ID: 96g93hntrzjtr Plan Hash: 2239883476 select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 14 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.00 0 42 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29 0.00 0.00 0 42 0 12 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=3 pr=0 pw=0 time=1444 us) 1 1 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=746 us)(object id 427) ******************************************************************************** SQL ID: 5n1fs4m2n2y0r Plan Hash: 299250003 select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 0 10 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 10 0 3 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 TABLE ACCESS BY INDEX ROWID ICOL$ (cr=6 pr=0 pw=0 time=20 us cost=2 size=54 card=2) 2 2 2 INDEX RANGE SCAN I_ICOL1 (cr=4 pr=0 pw=0 time=21 us cost=1 size=0 card=2)(object id 42) ******************************************************************************** SQL ID: 83taa7kaw59c1 Plan Hash: 3765558045 select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2, nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182, scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$, rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2, nvl(spare3,0) from col$ where obj#=:1 order by intcol# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 11 0.00 0.00 0 3 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.00 0 3 0 10 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 10 10 10 SORT ORDER BY (cr=3 pr=0 pw=0 time=61 us cost=3 size=826 card=14) 10 10 10 TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=39 us cost=2 size=826 card=14) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=9 us cost=1 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: 6aq34nj2zb2n7 Plan Hash: 2874733959 select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT GROUP BY (cr=2 pr=0 pw=0 time=28 us cost=4 size=15 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=0 pw=0 time=17 us cost=3 size=15 card=1) 0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=13 us cost=2 size=0 card=1)(object id 62) ******************************************************************************** SQL ID: 2q93zsrvbdw48 Plan Hash: 2874733959 select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT GROUP BY (cr=2 pr=0 pw=0 time=26 us cost=4 size=15 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=0 pw=0 time=15 us cost=3 size=15 card=1) 0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=11 us cost=2 size=0 card=1)(object id 62) ******************************************************************************** SQL ID: 3w4qs0tbpmxr6 Plan Hash: 1224215794 select con#,obj#,rcon#,enabled,nvl(defer,0),spare2,spare3 from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=1 pr=0 pw=0 time=20 us cost=2 size=64 card=2) 0 0 0 INDEX RANGE SCAN I_CDEF3 (cr=1 pr=0 pw=0 time=16 us cost=1 size=0 card=1)(object id 55) ******************************************************************************** SQL ID: 53saa2zkr6wc3 Plan Hash: 3954488388 select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.00 0 8 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID CCOL$ (cr=4 pr=0 pw=0 time=21 us cost=3 size=16 card=1) 1 1 1 INDEX RANGE SCAN I_CCOL1 (cr=3 pr=0 pw=0 time=17 us cost=2 size=0 card=1)(object id 57) ******************************************************************************** SQL ID: db78fxqxwxt7r Plan Hash: 3312420081 select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 1 12 0 56 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 1 12 0 56 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 20 20 20 SORT ORDER BY (cr=3 pr=1 pw=0 time=6092 us cost=0 size=0 card=0) 20 20 20 TABLE ACCESS CLUSTER HISTGRM$ (cr=3 pr=1 pw=0 time=6053 us) 1 1 1 INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=11 us)(object id 422) ******************************************************************************** SQL ID: 2syvqzbxp4k9z Plan Hash: 1423211129 select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 20 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 30 0.00 0.00 0 20 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 4 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=34 us cost=5 size=65 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=30 us cost=4 size=49 card=1) 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=27 us cost=2 size=16 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=2 size=33 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 36) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=16 card=1) 0 0 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 11) ******************************************************************************** SQL ID: 2xyb5d6xg9srh Plan Hash: 785096182 select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 12 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 12 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 4 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=21 us cost=2 size=12 card=1) ******************************************************************************** select FAX_LIST.* from (select row_number() over ( order by fax.ID ASC ) RN, fax.ACCOUNT_TYPE, fax.BU_FILE_LOCATION, fax.COUNT_PAGES_RECEIVED, nvl(fax.CUSTOMER_NAME, fax.SENDER_NAME) AS CUSTOMER_NAME, fax.FAX_SOURCE, fax.CUSTOMER_NUMBER, fax.CUSTOMER_OMEGA_NUMBER, fax.GENIFAX_RECIPIENT_ID, fax.ID AS FAX_ID, fax.DATE_RECEIVED AS FAX_RECEIVED, fax.IS_LOCKED, fax.LOCKED_BY, fax.ORIGINATOR_CSI, fax.MARGIN, fax.PAYMENT_TYPE, fax.PRIORITY_CODE, fax.PRIORITY_VALUE, FROM_TZ (fax.DATE_RECEIVED, 'UTC') AT TIME ZONE map.ORACLE_TZ_NAME AS DATE_RECEIVED, fax.SALES_PERSON, fax.SENDER_EMAIL, fax.SENDER_NAME, fax.SUBJECT, fax.WORKGROUP_ID, fax.LOCKED_TIME, src.DESCRIPTION, src.FAX_NUMBER, src.WORKFLOW_ID, fax.CREATED_BY, fax.CREATED_DATE, fax.UPDATE_DATE, fax.UPDATED_BY, fax.RESERVED_BY, fax.PRICE_TO_ORDER, fax.SKU_COUNT_TO_ORDER , nvl(ORL.GET_FTH_WTR (fax.LAST_TRANSITION_ID).CHANGED_BY, case when fax.LAST_TRANSITION_ID is null and fax.GENIFAX_RECIPIENT_ID is not null then 'ORL FEEDER' else 'Admin' end ) AS LAST_USER , from_tz(nvl(ORL.GET_FTH_WTR (fax.LAST_TRANSITION_ID).CHANGED_DATE, fax.DATE_RECEIVED), 'UTC') at time zone map.ORACLE_TZ_NAME AS MOVE_DATETIME , NVL(ORL.GET_FTH_WTR (fax.LAST_TRANSITION_ID).REASON, 'Reroute') AS MOVE_REASON , NVL((select fw.DESCRIPTION from ORL.WORKGROUP_TRANSITION wt , ORL.WORKGROUP fw where wt.ID = ORL.GET_FTH_WTR (fax.LAST_TRANSITION_ID).WORKGROUP_TRANSITION_ID and fw.ID = wt.CURRENT_WORKGROUP_ID ), case when fax.LAST_TRANSITION_ID is null and fax.GENIFAX_RECIPIENT_ID is not null then 'ORL FEEDER STAGING' else 'N/A' end ) as OLD_STATUS , (select max(PURCHASE_ORDER_NUMBER) from ORL.FAX_OFFER_DETAIL where FAX_ID = fax.ID) as MAXPO , (select case count(PURCHASE_ORDER_NUMBER) when 0 then null else count(PURCHASE_ORDER_NUMBER) end as POCOUNT from ORL.FAX_OFFER_DETAIL where FAX_ID = fax.ID) as POCOUNT , (select sum(VALUE) as ORDER_VALUE from ORL.FAX_OFFER_DETAIL where FAX_ID = fax.ID) as ORDER_VALUE, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).SALESPERSON_NAME AS SALESPERSON_NAME, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).GROUP_NAME AS GROUP_NAME, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).ROLE_NAME AS ROLE_NAME, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).EMAIL AS EMAIL, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).SALES_CHANNEL AS SALES_CHANNEL from ORL.FAX_HEADER fax, APPS_GLOBAL.GLOBAL_BU_MAPPING map, ORL.FAX_SOURCE src where fax.WORKGROUP_ID = 262 and map.GEDIS = 'Y' and map.BU_ID = (select BUID from ORL.WORKGROUP where ID = fax.WORKGROUP_ID) and ORL.GET_SALESPERSON(map.ORG_ID, fax.SALES_PERSON).GROUP_NAME = 'ORL_GB_Channel_PD3' and ORL.GET_SALESPERSON(map.ORG_ID, fax.SALES_PERSON).SALESPERSON_NAME = 'A_CARRICK' and src.WORKFLOW_ID IN ( select to_number(COLUMN_VALUE) as COLUMN_VALUE from table(SplitClob('1,2,3',',')) t) and src.ID (+)= fax.FAX_SOURCE ) FAX_LIST WHERE RN between 1 and 100 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.13 0.13 0 1422 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.13 0.13 0 1422 0 0 Misses in library cache during parse: 2 Optimizer mode: ALL_ROWS Parsing user id: 51 ******************************************************************************** SQL ID: 0qcvhxzjjkxxg Plan Hash: 1841784897 SELECT OWNER_NAME FROM APPS_GLOBAL.GLOBAL_BU_MAPPING WHERE ORG_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 661661 11.54 11.73 0 0 0 0 Fetch 661661 10.70 10.92 0 1323322 0 661661 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1323323 22.24 22.66 0 1323322 0 661661 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 106 (recursive depth: 1) ******************************************************************************** SQL ID: b33djnv3m3yu0 Plan Hash: 389732789 SELECT WTR.REASON, WTR.WORKGROUP_TRANSITION_ID, FTH.CHANGED_BY, FTH.CHANGED_DATE FROM ORL.FAX_TRANSITION_HISTORY FTH, ORL.WORKGROUP_TRANSITION_REASON WTR WHERE FTH.ID = :B1 AND WTR.ID(+) = FTH.TRANSITION_REASON_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 404 0.01 0.01 0 0 0 0 Fetch 404 0.03 0.31 53 2828 0 404 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 809 0.04 0.33 53 2828 0 404 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 106 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS OUTER (cr=7 pr=7 pw=0 time=40959 us cost=4 size=103 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FAX_TRANSITION_HISTORY (cr=4 pr=4 pw=0 time=26843 us cost=3 size=52 card=1) 1 1 1 INDEX UNIQUE SCAN PK_FAX_TRANSITION_HISTORY (cr=3 pr=3 pw=0 time=18576 us cost=2 size=0 card=1)(object id 109528) 1 1 1 TABLE ACCESS BY INDEX ROWID WORKGROUP_TRANSITION_REASON (cr=3 pr=3 pw=0 time=14109 us cost=1 size=548454 card=10754) 1 1 1 INDEX UNIQUE SCAN PK_WORKGROUP_TRANSITION_REASON (cr=2 pr=2 pw=0 time=7527 us cost=0 size=0 card=1)(object id 109498) ******************************************************************************** SQL ID: 47r1y8yn34jmj Plan Hash: 2191121161 select default$ from col$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 4 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID COL$ (cr=1 pr=0 pw=0 time=22 us cost=1 size=15 card=1) ******************************************************************************** select FAX_LIST.* from (select row_number() over ( order by fax.ID ASC ) RN, fax.ACCOUNT_TYPE, fax.BU_FILE_LOCATION, fax.COUNT_PAGES_RECEIVED, nvl(fax.CUSTOMER_NAME, fax.SENDER_NAME) AS CUSTOMER_NAME, fax.FAX_SOURCE, fax.CUSTOMER_NUMBER, fax.CUSTOMER_OMEGA_NUMBER, fax.GENIFAX_RECIPIENT_ID, fax.ID AS FAX_ID, fax.DATE_RECEIVED AS FAX_RECEIVED, fax.IS_LOCKED, fax.LOCKED_BY, fax.ORIGINATOR_CSI, fax.MARGIN, fax.PAYMENT_TYPE, fax.PRIORITY_CODE, fax.PRIORITY_VALUE, FROM_TZ (fax.DATE_RECEIVED, 'UTC') AT TIME ZONE map.ORACLE_TZ_NAME AS DATE_RECEIVED, fax.SALES_PERSON, fax.SENDER_EMAIL, fax.SENDER_NAME, fax.SUBJECT, fax.WORKGROUP_ID, fax.LOCKED_TIME, src.DESCRIPTION, src.FAX_NUMBER, src.WORKFLOW_ID, fax.CREATED_BY, fax.CREATED_DATE, fax.UPDATE_DATE, fax.UPDATED_BY, fax.RESERVED_BY, fax.PRICE_TO_ORDER, fax.SKU_COUNT_TO_ORDER , nvl(ORL.GET_FTH_WTR (fax.LAST_TRANSITION_ID).CHANGED_BY, case when fax.LAST_TRANSITION_ID is null and fax.GENIFAX_RECIPIENT_ID is not null then 'ORL FEEDER' else 'Admin' end ) AS LAST_USER , from_tz(nvl(ORL.GET_FTH_WTR (fax.LAST_TRANSITION_ID).CHANGED_DATE, fax.DATE_RECEIVED), 'UTC') at time zone map.ORACLE_TZ_NAME AS MOVE_DATETIME , NVL(ORL.GET_FTH_WTR (fax.LAST_TRANSITION_ID).REASON, 'Reroute') AS MOVE_REASON , NVL((select fw.DESCRIPTION from ORL.WORKGROUP_TRANSITION wt , ORL.WORKGROUP fw where wt.ID = ORL.GET_FTH_WTR (fax.LAST_TRANSITION_ID).WORKGROUP_TRANSITION_ID and fw.ID = wt.CURRENT_WORKGROUP_ID ), case when fax.LAST_TRANSITION_ID is null and fax.GENIFAX_RECIPIENT_ID is not null then 'ORL FEEDER STAGING' else 'N/A' end ) as OLD_STATUS , (select max(PURCHASE_ORDER_NUMBER) from ORL.FAX_OFFER_DETAIL where FAX_ID = fax.ID) as MAXPO , (select case count(PURCHASE_ORDER_NUMBER) when 0 then null else count(PURCHASE_ORDER_NUMBER) end as POCOUNT from ORL.FAX_OFFER_DETAIL where FAX_ID = fax.ID) as POCOUNT , (select sum(VALUE) as ORDER_VALUE from ORL.FAX_OFFER_DETAIL where FAX_ID = fax.ID) as ORDER_VALUE, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).SALESPERSON_NAME AS SALESPERSON_NAME, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).GROUP_NAME AS GROUP_NAME, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).ROLE_NAME AS ROLE_NAME, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).EMAIL AS EMAIL, ORL.GET_SALESPERSON (map.ORG_ID, fax.SALES_PERSON).SALES_CHANNEL AS SALES_CHANNEL from ORL.FAX_HEADER fax, APPS_GLOBAL.GLOBAL_BU_MAPPING map, ORL.FAX_SOURCE src where fax.WORKGROUP_ID = 262 and map.GEDIS = 'Y' and map.BU_ID = (select BUID from ORL.WORKGROUP where ID = fax.WORKGROUP_ID) and ORL.GET_SALESPERSON(map.ORG_ID, fax.SALES_PERSON).GROUP_NAME = 'ORL_GB_Channel_PD3' and ORL.GET_SALESPERSON(map.ORG_ID, fax.SALES_PERSON).SALESPERSON_NAME = 'A_CARRICK' and src.WORKFLOW_ID IN ( select to_number(COLUMN_VALUE) as COLUMN_VALUE from table(SplitClob('1,2,3',',')) t) and src.ID (+)= fax.FAX_SOURCE ) FAX_LIST WHERE RN between 1 and 100 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 190.28 584.58 48861 356066 110 100 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 190.28 584.58 48861 356066 110 100 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 51 Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 50 101 NESTED LOOPS (cr=464 pr=2 pw=0 time=22687 us cost=3 size=40 card=1) 0 50 101 TABLE ACCESS BY INDEX ROWID WORKGROUP_TRANSITION (cr=408 pr=2 pw=0 time=21242 us cost=2 size=9 card=1) 0 50 101 INDEX UNIQUE SCAN PK_WORKGROUP_TRANSITION (cr=358 pr=1 pw=0 time=15276 us cost=1 size=0 card=1)(object id 109497) 0 50 101 TABLE ACCESS BY INDEX ROWID WORKGROUP (cr=55 pr=0 pw=0 time=946 us cost=1 size=43028 card=1388) 0 50 101 INDEX UNIQUE SCAN PK_WORKGROUP (cr=4 pr=0 pw=0 time=560 us cost=0 size=0 card=1)(object id 109489) 0 50 101 SORT AGGREGATE (cr=132 pr=43 pw=0 time=388050 us) 0 52 104 TABLE ACCESS BY INDEX ROWID FAX_OFFER_DETAIL (cr=132 pr=43 pw=0 time=387462 us cost=5 size=16 card=1) 0 52 104 INDEX RANGE SCAN FAX_OFFER_DETAIL_IDX1 (cr=92 pr=17 pw=0 time=52516 us cost=3 size=0 card=1)(object id 109507) 0 50 101 SORT AGGREGATE (cr=132 pr=0 pw=0 time=1951 us) 0 52 104 TABLE ACCESS BY INDEX ROWID FAX_OFFER_DETAIL (cr=132 pr=0 pw=0 time=1590 us cost=5 size=16 card=1) 0 52 104 INDEX RANGE SCAN FAX_OFFER_DETAIL_IDX1 (cr=92 pr=0 pw=0 time=794 us cost=3 size=0 card=1)(object id 109507) 0 50 101 SORT AGGREGATE (cr=132 pr=0 pw=0 time=1684 us) 0 52 104 TABLE ACCESS BY INDEX ROWID FAX_OFFER_DETAIL (cr=132 pr=0 pw=0 time=1247 us cost=5 size=11 card=1) 0 52 104 INDEX RANGE SCAN FAX_OFFER_DETAIL_IDX1 (cr=92 pr=0 pw=0 time=444 us cost=3 size=0 card=1)(object id 109507) 0 50 100 VIEW (cr=3643524 pr=23682 pw=0 time=319855034 us cost=24181 size=6046 card=1) 0 50 101 WINDOW SORT PUSHED RANK (cr=3637563 pr=23612 pw=0 time=318978454 us cost=24181 size=691 card=1) 4073 4222 4372 NESTED LOOPS (cr=5251840 pr=24407 pw=0 time=64484932 us) 201378 316368 431359 NESTED LOOPS (cr=177526 pr=24386 pw=0 time=243022560 us cost=24178 size=691 card=1) 201378 316368 431359 NESTED LOOPS (cr=177520 pr=24386 pw=0 time=238638387 us cost=11905 size=8181422 card=12266) 16 293 570 HASH JOIN RIGHT SEMI (cr=53 pr=14 pw=0 time=13532 us cost=52 size=3604 card=68) 3 3 3 COLLECTION ITERATOR PICKLER FETCH SPLITCLOB (cr=15 pr=0 pw=0 time=963 us cost=29 size=12 card=6) 113 1240 2368 TABLE ACCESS FULL FAX_SOURCE (cr=38 pr=14 pw=0 time=11400 us cost=22 size=120768 card=2368) 201378 316368 431359 TABLE ACCESS BY INDEX ROWID FAX_HEADER (cr=177466 pr=24372 pw=0 time=238130130 us cost=11905 size=111134 card=181) 201378 316368 431359 BITMAP CONVERSION TO ROWIDS (cr=5464 pr=446 pw=0 time=2015611 us) 14 63 112 BITMAP AND (cr=5464 pr=446 pw=0 time=3121430 us) 27 107 187 BITMAP CONVERSION FROM ROWIDS (cr=1260 pr=446 pw=0 time=2340522 us) 333927 466486 599046 INDEX RANGE SCAN FAX_HEADER_FS_IDX (cr=1260 pr=446 pw=0 time=1294056 us cost=8 size=0 card=3306)(object id 109561) 1329 4424 7520 BITMAP INDEX SINGLE VALUE BITMAPINDX_WORKGROUP_ID_RAM (cr=4204 pr=0 pw=0 time=42242 us)(object id 122866) 201378 316368 431359 INDEX RANGE SCAN GLOBAL_BU_MAPPING_BUID (cr=6 pr=0 pw=0 time=2823808 us cost=0 size=0 card=1)(object id 107805) 1 1 1 TABLE ACCESS BY INDEX ROWID WORKGROUP (cr=3 pr=0 pw=0 time=378 us cost=2 size=8 card=1) 1 1 1 INDEX UNIQUE SCAN PK_WORKGROUP (cr=2 pr=0 pw=0 time=8 us cost=1 size=0 card=1)(object id 109489) 4073 4222 4372 TABLE ACCESS BY INDEX ROWID GLOBAL_BU_MAPPING (cr=5187206 pr=21 pw=0 time=164900286 us cost=1 size=24 card=1) ******************************************************************************** select SALESPERSON_NAME , EMAIL , SALES_CHANNEL , ROLE_NAME , GROUP_NAME from APPS_UK.ORL_ACTIVE_SALESPERSON where SALESPERSON_ID = :1 and rownum = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 661661 30.88 31.04 0 0 0 0 Fetch 661661 111.87 112.94 42 9059169 0 587745 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1323324 142.76 143.99 42 9059169 0 587745 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 106 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 COUNT STOPKEY (cr=16 pr=0 pw=0 time=259 us) 1 1 1 NESTED LOOPS (cr=16 pr=0 pw=0 time=238 us) 1 1 1 NESTED LOOPS (cr=15 pr=0 pw=0 time=220 us cost=8 size=523 card=1) 1 1 1 NESTED LOOPS (cr=14 pr=0 pw=0 time=212 us cost=7 size=505 card=1) 1 1 1 MERGE JOIN CARTESIAN (cr=12 pr=0 pw=0 time=198 us cost=6 size=478 card=1) 1 1 1 VIEW (cr=9 pr=0 pw=0 time=141 us cost=4 size=452 card=1) 1 1 1 WINDOW SORT PUSHED RANK (cr=9 pr=0 pw=0 time=136 us cost=4 size=100 card=1) 1 1 1 NESTED LOOPS (cr=9 pr=0 pw=0 time=100 us) 2 2 2 NESTED LOOPS (cr=7 pr=0 pw=0 time=68 us cost=3 size=100 card=1) 2 2 2 TABLE ACCESS BY INDEX ROWID GEDIS_SALESPERSON (cr=5 pr=0 pw=0 time=46 us cost=2 size=71 card=1) 10 10 10 INDEX RANGE SCAN GEDIS_SALESPERSON_N1 (cr=2 pr=0 pw=0 time=26 us cost=1 size=0 card=3)(object id 113093) 2 2 2 INDEX UNIQUE SCAN PK_GEDIS_RESPONSIBILITY (cr=2 pr=0 pw=0 time=14 us cost=0 size=0 card=1)(object id 112876) 1 1 1 TABLE ACCESS BY INDEX ROWID GEDIS_RESPONSIBILITY (cr=2 pr=0 pw=0 time=14 us cost=1 size=29 card=1) 1 1 1 BUFFER SORT (cr=3 pr=0 pw=0 time=48 us cost=6 size=26 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID GEDIS_USER_LINK (cr=3 pr=0 pw=0 time=34 us cost=2 size=26 card=1) 1 1 1 INDEX RANGE SCAN GEDIS_USER_LINK_PK (cr=2 pr=0 pw=0 time=12 us cost=1 size=0 card=1)(object id 112924) 1 1 1 TABLE ACCESS BY INDEX ROWID GEDIS_USER_GROUP (cr=2 pr=0 pw=0 time=11 us cost=1 size=27 card=1) 1 1 1 INDEX UNIQUE SCAN GEDIS_USER_GROUP_PK (cr=1 pr=0 pw=0 time=5 us cost=0 size=0 card=1)(object id 112925) 1 1 1 INDEX UNIQUE SCAN GEDIS_USER_ROLE_PK (cr=1 pr=0 pw=0 time=4 us cost=0 size=0 card=1)(object id 112926) 1 1 1 TABLE ACCESS BY INDEX ROWID GEDIS_USER_ROLE (cr=1 pr=0 pw=0 time=10 us cost=1 size=18 card=1) ******************************************************************************** SQL ID: grwydz59pu6mc Plan Hash: 3684871272 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 8 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 8 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=13 us cost=1 size=15 card=1) ******************************************************************************** SQL ID: gx4mv66pvj3xz Plan Hash: 1932954096 select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0),spare2,spare3 from cdef$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.00 0.00 0 8 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 1 2 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=4 pr=0 pw=0 time=23 us cost=2 size=204 card=4) 0 1 2 INDEX RANGE SCAN I_CDEF2 (cr=3 pr=0 pw=0 time=16 us cost=1 size=0 card=4)(object id 54) ******************************************************************************** SELECT s.sid, s.serial#, pa.value || '/' || LOWER(SYS_CONTEXT('userenv','instance_name')) || '_ora_' || p.spid || '.trc' AS trace_file FROM v$session s, v$process p, v$parameter pa WHERE pa.name = 'user_dump_dest' AND s.paddr = p.addr AND s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 51 ******************************************************************************** SELECT s.sid, s.serial#, pa.value || '/' || LOWER(SYS_CONTEXT('userenv','instance_name')) || '_ora_' || p.spid || '.trc' AS trace_file FROM v$session s, v$process p, v$parameter pa WHERE pa.name = 'user_dump_dest' AND s.paddr = p.addr AND s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 51 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 HASH JOIN (cr=0 pr=0 pw=0 time=10220 us cost=1 size=2284 card=1) 2752 2752 2752 MERGE JOIN CARTESIAN (cr=0 pr=0 pw=0 time=11708 us cost=1 size=2203 card=1) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=1786 us cost=1 size=169 card=1) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=1772 us cost=1 size=156 card=1) 1 1 1 HASH JOIN (cr=0 pr=0 pw=0 time=1754 us cost=1 size=130 card=1) 1 1 1 FIXED TABLE FULL X$KSUSE (cr=0 pr=0 pw=0 time=1130 us cost=0 size=84 card=1) 92 92 92 FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=191 us cost=0 size=46 card=1) 1 1 1 FIXED TABLE FIXED INDEX X$KSLWT (ind:1) (cr=0 pr=0 pw=0 time=10 us cost=0 size=26 card=1) 1 1 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=5 us cost=0 size=13 card=1) 2752 2752 2752 BUFFER SORT (cr=0 pr=0 pw=0 time=5718 us cost=1 size=203400 card=100) 2752 2752 2752 FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=18392 us cost=0 size=203400 card=100) 1 1 1 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=2351 us cost=0 size=81 card=1) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.14 0.14 0 1422 0 0 Execute 11 0.00 0.00 0 0 0 0 Fetch 3 190.29 584.59 48861 356066 110 101 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 190.43 584.73 48861 357488 110 101 Misses in library cache during parse: 7 Misses in library cache during execute: 4 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 38 0.01 0.01 0 0 0 0 Execute 1323778 42.47 42.82 0 0 0 0 Fetch 1323797 122.62 124.19 96 10385459 0 1249903 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2647613 165.10 167.03 96 10385459 0 1249903 Misses in library cache during parse: 17 Misses in library cache during execute: 17 19 user SQL statements in session. 25 internal SQL statements in session. 44 SQL statements in session. 0 statements EXPLAINed in this session. ******************************************************************************** Trace file: egipt1_ora_10926.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 19 user SQL statements in trace file. 25 internal SQL statements in trace file. 44 SQL statements in trace file. 21 unique SQL statements in trace file. 3973745 lines in trace file. 2802 elapsed seconds in trace file.