TKPROF: Release 11.2.0.3.0 - Development on Thu Mar 6 07:19:50 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Trace file: betsyu1_ora_8176_ANONYMOUS.trc Sort options: prsela exeela fchela ******************************************************************************** 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: aaps/apps@betsyu1 ORA-01017: invalid username/password; logon denied EXPLAIN PLAN option disabled. ******************************************************************************** SELECT /*+ ordered */ --PRN 13909 oh.demand_class_code, TO_CHAR(order_number, '99999999'), TO_CHAR(ol.line_number, '9999'), ol.ordered_item, mp.organization_code, --NVL(frs.email, 'linda.bauer@emerson.com') sc_email, NVL(NVL(oss.primary_email_address,oss.alternate_email_address),'linda.bauer@emerson.com') sc_email, TO_CHAR(ol.promise_date,'DD-Mon-YYYY') promise_dt, TO_CHAR(ol.schedule_ship_date,'DD-Mon-YYYY') sched_dt, (SELECT d.name FROM V$database d) db_name FROM apps.oe_transaction_types_tl ottt, apps.oe_transaction_types_all otta, apps.oe_order_headers_all oh, apps.oe_order_lines_all ol, apps.hr_organization_units hou, apps.xxont_som_scheduler oss, apps.xxom_3lp_sym_ora_order_hdr xxooh, apps.xxom_3lp_sym_ora_order_lines xxool,--Added by OCD Project on 7th aug 2012 apps.mtl_parameters mp, apps.oe_order_sources oos WHERE oh.header_id = ol.header_id AND ol.ship_from_org_id = hou.organization_id AND hou.organization_id = mp.organization_id AND oh.header_id = xxooh.header_id AND xxooh.order_admin = oss.subscriber_id AND xxool.line_id=ol.line_id --Added by OCD Project on 7th aug 2012 AND ol.org_id=xxool.org_id --Added by OCD Project on 7th aug 2012 --AND oss.subscriber_type = 'BUSINESS_ADMIN' Commented for SI AND oh.order_type_id = otta.transaction_type_id AND otta.transaction_type_id = ottt.transaction_type_id AND ottt.language = USERENV('LANG') -- AND ol.link_to_line_id IS NULL commented by OCD Project on 7th aug 2012 AND ( (xxool.assembly_type IS NOT NULL --Added by OCD Project on 7th aug 2012 AND ol.link_to_line_id = ol.top_model_line_id) OR ( (xxool.assembly_type IS NULL OR xxool.assembly_type NOT IN('I','R')) AND ol.link_to_line_id IS NULL ) ) --Added by OCD Project on 7th aug 2012 AND ol.ordered_quantity <> 0 AND oh.open_flag = 'Y' AND ol.open_flag = 'Y' AND oh.flow_status_code <> 'CLOSED' AND oos.order_source_id = oh.order_source_id AND oos.name <> 'Internal' AND (ottt.name NOT LIKE '%QUOTE%' AND ottt.name NOT LIKE '%DUMMY%' AND ottt.name NOT LIKE '%RMA%' AND ottt.name NOT LIKE '%BILLING ONLY%' AND ottt.name NOT LIKE '%CREDIT ONLY%') AND ol.ordered_item NOT LIKE 'MISC%' AND TRUNC(ol.schedule_ship_date) = TRUNC(ol.promise_date) AND mp.organization_code = 'RTF' ORDER BY 1,2,3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.09 0.09 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 7549.35 12029.70 1032852 1476236 26 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 7549.44 12029.79 1032852 1476236 26 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=7069 us cost=0 size=9 card=1) 1 1 1 FIXED TABLE FULL X$KCCDI (cr=0 pr=0 pw=0 time=3488 us cost=0 size=9 card=1) 1 1 1 FIXED TABLE FULL X$KCCDI2 (cr=0 pr=0 pw=0 time=3551 us cost=0 size=0 card=1) 0 0 0 SORT ORDER BY (cr=0 pr=0 pw=0 time=64 us cost=793530 size=224 card=1) 2 2 2 NESTED LOOPS (cr=1414874 pr=992166 pw=7212360 time=2374542593 us) 2 2 2 NESTED LOOPS (cr=1414872 pr=992166 pw=7212360 time=2374542506 us cost=793529 size=224 card=1) 2 2 2 NESTED LOOPS (cr=1414870 pr=992166 pw=7212360 time=2374542422 us cost=793528 size=208 card=1) 8538 8538 8538 NESTED LOOPS (cr=1466640 pr=1031989 pw=7356780 time=1260338078 us cost=793526 size=3800 card=19) 43815 43815 43815 HASH JOIN (cr=1342596 pr=1021114 pw=7356780 time=631701530 us cost=793093 size=40392 card=216) 190031 190031 190031 VIEW index$_join$_008 (cr=1530 pr=2237 pw=750 time=2235327 us cost=2445 size=717451 card=102493) 190031 190031 190031 HASH JOIN (cr=1530 pr=2237 pw=750 time=2151500 us) 190135 190135 190135 INDEX FAST FULL SCAN XXOM_3LP_SYM_ORA_ORDER_HDR_N3 (cr=655 pr=640 pw=0 time=192121 us cost=696 size=717451 card=102493)(object id 13284694) 242642 242642 242642 INDEX FAST FULL SCAN XXOM_3LP_SYM_ORA_ORDER_HDR_N2 (cr=875 pr=847 pw=0 time=548941 us cost=958 size=717451 card=102493)(object id 13127885) 374774210 374774210 374774210 MERGE JOIN CARTESIAN (cr=1342177 pr=1019454 pw=0 time=3262320541 us cost=790610 size=404189460 card=2245497) 1066882 1066882 1066882 NESTED LOOPS (cr=1342091 pr=1019368 pw=0 time=3791571639 us cost=778585 size=83619 card=513) 1066882 1066882 1066882 HASH JOIN (cr=1276225 pr=1019346 pw=0 time=3604473849 us cost=778583 size=185328 card=1188) 2982 2982 2982 VIEW index$_join$_012 (cr=39 pr=17 pw=0 time=226135 us cost=15 size=552 card=69) 2982 2982 2982 HASH JOIN (cr=22 pr=7 pw=0 time=22519 us) 2982 2982 2982 INDEX FAST FULL SCAN HR_ORGANIZATION_UNITS_FK1 (cr=11 pr=3 pw=0 time=2451 us cost=9 size=552 card=69)(object id 32563597) 2982 2982 2982 INDEX FAST FULL SCAN HR_ORGANIZATION_UNITS_PK (cr=11 pr=4 pw=0 time=5231 us cost=9 size=552 card=69)(object id 32563590) 1066882 1066882 1066882 NESTED LOOPS (cr=1276186 pr=1019329 pw=0 time=3580067762 us cost=778568 size=425944 card=2878) 83940 83940 83940 HASH JOIN (cr=36105 pr=35013 pw=0 time=54283346 us cost=17596 size=7071890 card=101027) 2258 2258 2258 NESTED LOOPS (cr=1386 pr=439 pw=0 time=133267 us cost=133 size=62440 card=1784) 2258 2258 2258 TABLE ACCESS FULL OE_TRANSACTION_TYPES_TL (cr=434 pr=433 pw=0 time=96141 us cost=132 size=55304 card=1784) 2258 2258 2258 INDEX UNIQUE SCAN OE_TRANSACTION_TYPES_ALL_U1 (cr=952 pr=6 pw=0 time=39701 us cost=0 size=4 card=1)(object id 43161) 112606 112606 112606 TABLE ACCESS BY INDEX ROWID OE_ORDER_HEADERS_ALL (cr=34719 pr=34574 pw=0 time=64958053 us cost=17461 size=4569705 card=130563) 112705 112705 112705 INDEX RANGE SCAN OE_ORDER_HEADERS_N8 (cr=393 pr=393 pw=0 time=1327201 us cost=400 size=0 card=174084)(object id 99630) 1066882 1066882 1066882 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (cr=1240081 pr=984316 pw=0 time=21822129 us cost=11 size=78 card=1) 3494404 3494404 3494404 INDEX RANGE SCAN OE_ORDER_LINES_ALL_X17 (cr=258826 pr=54431 pw=0 time=434436913 us cost=3 size=0 card=21)(object id 33170974) 1066882 1066882 1066882 INDEX UNIQUE SCAN HR_ALL_ORGANIZATION_UNTS_TL_PK (cr=65866 pr=22 pw=0 time=177595640 us cost=0 size=7 card=1)(object id 44637) 374774210 374774210 374774210 BUFFER SORT (cr=86 pr=86 pw=0 time=2188770905 us cost=790610 size=74392 card=4376) 4377 4377 4377 TABLE ACCESS FULL XXONT_SOM_SCHEDULER (cr=86 pr=86 pw=0 time=24275 us cost=23 size=74392 card=4376) 8538 8538 8538 TABLE ACCESS BY INDEX ROWID XXOM_3LP_SYM_ORA_ORDER_LINES (cr=124044 pr=10875 pw=0 time=140592751 us cost=793526 size=13 card=1) 43215 43215 43215 BITMAP CONVERSION TO ROWIDS (cr=87943 pr=4473 pw=0 time=51715757 us) 43215 43215 43215 BITMAP INDEX RANGE SCAN XXOM_3LP_SYM_ORA_ORDER_N11 (cr=87943 pr=4473 pw=0 time=50909166 us)(object id 33620769) 2 2 2 TABLE ACCESS BY INDEX ROWID MTL_PARAMETERS (cr=8542 pr=13 pw=0 time=621590 us cost=1 size=8 card=1) 8538 8538 8538 INDEX UNIQUE SCAN MTL_PARAMETERS_U1 (cr=4 pr=1 pw=0 time=251706 us cost=0 size=0 card=1)(object id 37657) 2 2 2 INDEX UNIQUE SCAN OE_ORDER_SOURCES_U1 (cr=2 pr=0 pw=0 time=64 us cost=0 size=0 card=1)(object id 42233) 2 2 2 TABLE ACCESS BY INDEX ROWID OE_ORDER_SOURCES (cr=2 pr=0 pw=0 time=64 us cost=1 size=16 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.01 0.01 Disk file operations I/O 59 0.00 0.00 db file sequential read 1029831 1.49 3712.44 db file scattered read 272 0.00 0.03 CSS initialization 1 0.03 0.03 CSS operation: query 6 0.00 0.00 CSS operation: action 1 0.01 0.01 direct path write temp 490701 0.01 51.36 direct path read temp 68 0.00 0.00 log file sync 1 0.00 0.00 latch free 1 0.00 0.00 latch: object queue header operation 1 0.00 0.00 control file sequential read 7 0.00 0.00 SQL*Net break/reset to client 2 0.00 0.00 ******************************************************************************** SQL ID: 2s6h56v3dqy15 Plan Hash: 0 INSERT INTO ALR_ALERT_CHECKS (APPLICATION_ID, ALERT_CHECK_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, ALERT_ID, CHECK_TIME, SUCCESS_FLAG, REQUEST_ID) VALUES (:0, :1, SYSDATE, :2, :3, ((SYSDATE - trunc(SYSDATE))*86400), 'R', :4) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 1 0.01 0.22 13 1 14 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.03 0.24 13 1 14 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=13 pw=0 time=224018 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 db file sequential read 13 0.06 0.21 ******************************************************************************** SQL ID: 4nrq590yvnudc Plan Hash: 0 INSERT INTO ALR_ACTION_SET_CHECKS (APPLICATION_ID, CHECK_ID, ALERT_ID, ORACLE_ID, ACTION_SET_ID, SUCCESS_FLAG, ALERT_CHECK_ID) VALUES (:0, :1, :2, :3, :4, 'R', :5) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.01 0 0 0 0 Execute 1 0.02 0.21 19 1 20 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.05 0.23 19 1 20 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=19 pw=0 time=216749 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 db file sequential read 19 0.03 0.20 ******************************************************************************** SQL ID: 7u3g1r1ym8fv2 Plan Hash: 26413699 SELECT ALERT_NAME, SQL_STATEMENT_TEXT, NVL(MAINTAIN_HISTORY_DAYS, 0), TO_CHAR(DATE_LAST_CHECKED,'DD-MON-YYYY HH24:MI:SS'), FREQUENCY_TYPE, NVL(U.EMAIL_ADDRESS, U.USER_NAME) FROM ALR_ALERTS A, FND_USER U WHERE APPLICATION_ID = :0 AND ALERT_ID = :1 AND ENABLED_FLAG = 'Y' AND A.LAST_UPDATED_BY = U.USER_ID (+) AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.05 0.19 178 185 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.06 0.20 178 185 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS OUTER (cr=184 pr=178 pw=0 time=117630 us cost=54 size=122 card=1) 1 1 1 TABLE ACCESS FULL ALR_ALERTS (cr=181 pr=178 pw=0 time=195566 us cost=53 size=69 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_USER (cr=3 pr=0 pw=0 time=187 us cost=1 size=53 card=1) 1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=2 pr=0 pw=0 time=108 us cost=0 size=0 card=1)(object id 33427) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6 0.00 0.00 SQL*Net message from client 6 0.00 0.00 Disk file operations I/O 19 0.00 0.00 db file sequential read 4 0.00 0.00 db file scattered read 23 0.00 0.00 SQL*Net more data to client 1 0.00 0.00 ******************************************************************************** SQL ID: 52ad540qu4m5d Plan Hash: 0 INSERT INTO XXFND.XXFND_PMO_PROFILE_OPT_AUDIT (PROFILE_OPTION_ID, PROFILE_OPTION_NAME, LEVEL_ID, LEVEL_VALUE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, OLD_PROFILE_OPT_VALUE, NEW_PROFILE_OPT_VALUE) VALUES (:B1 , :B9 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.02 0.17 20 4 18 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.02 0.17 20 4 18 2 Misses in library cache during parse: 2 Misses in library cache during execute: 2 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=2 pr=10 pw=0 time=87446 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 2 0.00 0.00 db file sequential read 20 0.02 0.16 ******************************************************************************** SQL ID: 7ng34ruy5awxq Plan Hash: 3984801583 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 2 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 32 0.03 0.11 36 103 0 22 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 44 0.03 0.12 36 103 0 22 Misses in library cache during parse: 0 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 2 5 SORT ORDER BY (cr=8 pr=4 pw=0 time=20166 us cost=10 size=390 card=2) 0 2 5 HASH JOIN OUTER (cr=8 pr=4 pw=0 time=19912 us cost=9 size=390 card=2) 0 2 5 NESTED LOOPS OUTER (cr=6 pr=4 pw=0 time=19562 us cost=4 size=304 card=2) 0 2 5 TABLE ACCESS CLUSTER IND$ (cr=5 pr=4 pw=0 time=19478 us cost=4 size=200 card=2) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=2 pw=0 time=3156 us cost=2 size=0 card=1)(object id 3) 0 0 0 TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=0 pr=0 pw=0 time=34 us cost=0 size=52 card=1) 0 0 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=0 pr=0 pw=0 time=24 us cost=0 size=0 card=1)(object id 9228134) 0 0 0 VIEW (cr=2 pr=1 pw=0 time=1380 us cost=4 size=43 card=1) 0 0 0 SORT GROUP BY (cr=2 pr=1 pw=0 time=1377 us cost=4 size=16 card=1) 0 0 0 TABLE ACCESS CLUSTER CDEF$ (cr=2 pr=1 pw=0 time=1334 us cost=3 size=16 card=1) 0 0 1 INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 time=38 us cost=2 size=0 card=1)(object id 27) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 36 0.02 0.07 Disk file operations I/O 2 0.00 0.00 ******************************************************************************** SQL ID: 96g93hntrzjtr Plan Hash: 841937906 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 2 0.00 0.00 0 0 0 0 Execute 74 0.01 0.00 0 0 0 0 Fetch 74 0.03 0.10 26 296 0 73 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 150 0.04 0.11 26 296 0 73 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=4 pr=3 pw=0 time=21238 us) 1 1 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=3 pr=2 pw=0 time=19308 us)(object id 194) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 26 0.02 0.08 Disk file operations I/O 5 0.00 0.00 ******************************************************************************** SQL ID: 2bh4a19s0k8p9 Plan Hash: 0 declare res boolean; begin FND_CLIENT_INFO.SET_ORG_CONTEXT(:0); FND_PROFILE.PUT('ORG_ID', :0); res:=FND_PROFILE.SAVE('ORG_ID', :0, 'RESP', :1, :2); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.12 0.10 8 32 8 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.12 0.10 8 32 8 2 Misses in library cache during parse: 2 Misses in library cache during execute: 2 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 4 0.00 0.00 SQL*Net message from client 4 0.00 0.00 db file sequential read 2 0.01 0.01 ******************************************************************************** SQL ID: 6jgg29j5kns6m Plan Hash: 0 insert into "APPLSYS"."WF_JAVA_DEFERRED" (q_name, msgid, corrid, priority, state, delay, expiration, time_manager_info, local_order_no, chain_no, enq_time, step_no, enq_uid, enq_tid, retry_count, exception_qschema, exception_queue, recipient_key, dequeue_msgid, user_data, sender_name, sender_address, sender_protocol, user_prop, cscn, dscn) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.03 0.09 9 1 12 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.09 9 1 12 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=8 pw=0 time=82366 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 9 0.04 0.09 ******************************************************************************** SQL ID: 9tgj4g8y4rwy8 Plan Hash: 3632979230 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0), NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 20 0.00 0.00 0 0 0 0 Fetch 20 0.04 0.09 32 80 0 20 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 41 0.04 0.09 32 80 0 20 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS CLUSTER SEG$ (cr=4 pr=4 pw=0 time=13621 us cost=3 size=67 card=1) 1 1 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=3 pr=3 pw=0 time=11755 us cost=2 size=0 card=1)(object id 9) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 32 0.02 0.08 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 17rbp3s86rzza Plan Hash: 1884197401 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 0.00 0 0 0 0 Execute 1 0.01 0.08 10 4 35 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.08 10 4 35 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=18 pr=10 pw=0 time=88315 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=164 us cost=3 size=185 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=118 us cost=2 size=0 card=1)(object id 34547) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 10 0.03 0.07 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: fxzd9krukdpp2 Plan Hash: 4147207844 UPDATE ALR_ACTION_SET_CHECKS SET ACTION_COUNT = :0, ROW_COUNT = :1, SUCCESS_FLAG = :2 WHERE APPLICATION_ID = :3 AND CHECK_ID = :4 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 1 0.03 0.06 8 3 9 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.05 0.07 8 3 9 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE ALR_ACTION_SET_CHECKS (cr=3 pr=8 pw=0 time=56725 us) 1 1 1 INDEX UNIQUE SCAN ALR_ACTION_SET_CHECKS_U1 (cr=3 pr=3 pw=0 time=19487 us cost=2 size=19 card=1)(object id 27595) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 db file sequential read 8 0.01 0.05 ******************************************************************************** SQL ID: 44rmv4mk9g7u1 Plan Hash: 3471254691 SELECT SUBSCRIPTION_GUID, SYSTEM_GUID, SUBSCRIPTION_SOURCE_TYPE, SUBSCRIPTION_SOURCE_AGENT_GUID, SUBSCRIPTION_PHASE, SUBSCRIPTION_RULE_DATA, SUBSCRIPTION_OUT_AGENT_GUID, SUBSCRIPTION_TO_AGENT_GUID, SUBSCRIPTION_PRIORITY, SUBSCRIPTION_RULE_FUNCTION, WF_PROCESS_TYPE, WF_PROCESS_NAME, SUBSCRIPTION_PARAMETERS, '', '', '', '', '', SUBSCRIPTION_ON_ERROR_TYPE, '' FROM WF_ACTIVE_SUBSCRIPTIONS_V WHERE EVENT_NAME IN(:B5 , :B4 ) AND SUBSCRIPTION_SOURCE_TYPE = :B3 AND ((SUBSCRIPTION_SOURCE_AGENT_GUID IS NOT NULL AND SUBSCRIPTION_SOURCE_AGENT_GUID = NVL(:B2 , SUBSCRIPTION_SOURCE_AGENT_GUID)) OR SUBSCRIPTION_SOURCE_AGENT_GUID IS NULL) AND SYSTEM_GUID = :B1 ORDER BY 5 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 4 0.01 0.06 12 27 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.06 12 27 0 3 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 3 3 3 SORT ORDER BY (cr=27 pr=12 pw=0 time=66996 us cost=13 size=4776 card=2) 3 3 3 VIEW WF_ACTIVE_SUBSCRIPTIONS_V (cr=27 pr=12 pw=0 time=119994 us cost=12 size=4776 card=2) 3 3 3 UNION-ALL (cr=27 pr=12 pw=0 time=119950 us) 1 1 1 NESTED LOOPS (cr=12 pr=7 pw=0 time=56222 us) 2 2 2 NESTED LOOPS (cr=10 pr=5 pw=0 time=49512 us cost=5 size=246 card=1) 2 2 2 INLIST ITERATOR (cr=6 pr=2 pw=0 time=45215 us) 2 2 2 TABLE ACCESS BY INDEX ROWID WF_EVENTS (cr=6 pr=2 pw=0 time=45181 us cost=3 size=75 card=1) 2 2 2 INDEX UNIQUE SCAN WF_EVENTS_U2 (cr=4 pr=1 pw=0 time=2482 us cost=2 size=0 card=2)(object id 166646) 2 2 2 INDEX RANGE SCAN WF_EVENT_SUBSCRIPTIONS_N1 (cr=4 pr=3 pw=0 time=4295 us cost=1 size=0 card=1)(object id 166652) 1 1 1 TABLE ACCESS BY INDEX ROWID WF_EVENT_SUBSCRIPTIONS (cr=2 pr=2 pw=0 time=6605 us cost=2 size=171 card=1) 2 2 2 NESTED LOOPS (cr=15 pr=5 pw=0 time=9871 us) 2 2 2 NESTED LOOPS (cr=13 pr=3 pw=0 time=5806 us cost=7 size=312 card=1) 1 1 1 NESTED LOOPS (cr=11 pr=3 pw=0 time=5973 us cost=5 size=141 card=1) 1 1 1 NESTED LOOPS (cr=8 pr=1 pw=0 time=2543 us cost=4 size=109 card=1) 2 2 2 INLIST ITERATOR (cr=6 pr=0 pw=0 time=519 us) 2 2 2 TABLE ACCESS BY INDEX ROWID WF_EVENTS (cr=6 pr=0 pw=0 time=395 us cost=3 size=75 card=1) 2 2 2 INDEX UNIQUE SCAN WF_EVENTS_U2 (cr=4 pr=0 pw=0 time=225 us cost=2 size=0 card=2)(object id 166646) 1 1 1 INDEX RANGE SCAN WF_EVENT_GROUPS_U1 (cr=2 pr=1 pw=0 time=2006 us cost=1 size=34 card=1)(object id 166650) 1 1 1 TABLE ACCESS BY INDEX ROWID WF_EVENTS (cr=3 pr=2 pw=0 time=3410 us cost=1 size=32 card=1) 1 1 1 INDEX UNIQUE SCAN WF_EVENTS_U1 (cr=2 pr=2 pw=0 time=3359 us cost=0 size=0 card=1)(object id 166645) 2 2 2 INDEX RANGE SCAN WF_EVENT_SUBSCRIPTIONS_N1 (cr=2 pr=0 pw=0 time=85 us cost=1 size=0 card=1)(object id 166652) 2 2 2 TABLE ACCESS BY INDEX ROWID WF_EVENT_SUBSCRIPTIONS (cr=2 pr=2 pw=0 time=4031 us cost=2 size=171 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 12 0.04 0.05 ******************************************************************************** SQL ID: 3ktacv9r56b51 Plan Hash: 458693102 select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,type#,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 16 0.03 0.05 21 64 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 32 0.03 0.05 21 64 0 8 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=8 pr=8 pw=0 time=26891 us cost=17 size=316 card=4) 1 1 1 NESTED LOOPS OUTER (cr=8 pr=8 pw=0 time=26699 us cost=16 size=316 card=4) 1 1 1 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=4 pr=4 pw=0 time=16472 us cost=4 size=132 card=4) 1 1 1 INDEX RANGE SCAN I_DEPENDENCY1 (cr=3 pr=3 pw=0 time=14244 us cost=3 size=0 card=4)(object id 116) 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=4 pw=0 time=10188 us cost=3 size=46 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=3 pw=0 time=8375 us cost=2 size=0 card=1)(object id 26619161) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 5 0.00 0.00 db file sequential read 21 0.00 0.03 ******************************************************************************** SQL ID: fmfdkztk8vx23 Plan Hash: 3675718404 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 0.00 0 0 0 0 Execute 14 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.05 6 56 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 29 0.00 0.05 6 56 0 14 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 COUNT STOPKEY (cr=4 pr=0 pw=0 time=328 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=0 pw=0 time=310 us cost=3 size=36 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=0 pw=0 time=94 us cost=2 size=0 card=1)(object id 33198) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 14 0.00 0.00 SQL*Net message from client 14 0.01 0.04 db file sequential read 6 0.04 0.04 ******************************************************************************** SQL ID: c19mz7b7utng7 Plan Hash: 0 INSERT INTO JCD_FND_PROFILE_OPTION_VALUES( ROW_ID,MD_EXTRACTED_STATUS, MD_UPDATE_DATE ) VALUES ( :B1 ,'N',SYSDATE ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.01 0.04 8 2 6 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.04 8 2 6 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 3558 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=4 pw=0 time=17050 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 8 0.00 0.02 ******************************************************************************** SQL ID: 2q93zsrvbdw48 Plan Hash: 3286988581 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 2 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 107 0.01 0.04 19 64 0 97 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 119 0.01 0.04 19 64 0 97 Misses in library cache during parse: 0 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 ---------- ---------- ---------- --------------------------------------------------- 12 12 12 SORT GROUP BY (cr=6 pr=3 pw=0 time=9017 us cost=6 size=68 card=4) 12 12 12 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=6 pr=3 pw=0 time=5530 us cost=5 size=68 card=4) 12 12 12 INDEX RANGE SCAN I_OBJAUTH1 (cr=3 pr=0 pw=0 time=146 us cost=3 size=0 card=4)(object id 100) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 19 0.00 0.02 ******************************************************************************** SQL ID: 2sjraytcfcv2n Plan Hash: 1608080060 SELECT /*+ USE_NL (A B I) */ DISTINCT A.APPLICATION_ID, A.APPLICATION_NAME, B.APPLICATION_SHORT_NAME, B.BASEPATH, I.PRODUCT_VERSION FROM FND_APPLICATION_TL A, FND_APPLICATION B, FND_PRODUCT_INSTALLATIONS I WHERE A.APPLICATION_ID = I.APPLICATION_ID (+) AND A.APPLICATION_ID = B.APPLICATION_ID AND A.LANGUAGE = USERENV ('LANG') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.03 0.03 0 244 0 317 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.04 0.04 0 244 0 317 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 317 317 317 HASH UNIQUE (cr=244 pr=0 pw=0 time=28566 us cost=631 size=18069 card=317) 317 317 317 NESTED LOOPS OUTER (cr=244 pr=0 pw=0 time=19630 us cost=630 size=18069 card=317) 317 317 317 HASH JOIN (cr=96 pr=0 pw=0 time=12422 us cost=46 size=14582 card=317) 317 317 317 TABLE ACCESS FULL FND_APPLICATION (cr=14 pr=0 pw=0 time=269 us cost=10 size=6023 card=317) 317 317 317 VIEW VW_DTP_377C5901 (cr=82 pr=0 pw=0 time=8094 us cost=35 size=8559 card=317) 317 317 317 HASH UNIQUE (cr=82 pr=0 pw=0 time=7612 us cost=35 size=9510 card=317) 317 317 317 TABLE ACCESS FULL FND_APPLICATION_TL (cr=82 pr=0 pw=0 time=7706 us cost=34 size=9510 card=317) 266 266 266 TABLE ACCESS BY INDEX ROWID FND_PRODUCT_INSTALLATIONS (cr=148 pr=0 pw=0 time=3922 us cost=2 size=11 card=1) 266 266 266 INDEX RANGE SCAN FND_PRODUCT_INSTALLATIONS_PK (cr=3 pr=0 pw=0 time=1397 us cost=1 size=0 card=1)(object id 22589) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net more data to client 9 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SQL ID: 6aq34nj2zb2n7 Plan Hash: 3286988581 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 2 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.03 10 25 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.03 10 25 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT GROUP BY (cr=3 pr=2 pw=0 time=3670 us cost=5 size=17 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=3 pr=2 pw=0 time=3616 us cost=4 size=17 card=1) 0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=3 pr=2 pw=0 time=3613 us cost=3 size=0 card=1)(object id 100) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 10 0.01 0.03 ******************************************************************************** SQL ID: 759fy7caf9stw Plan Hash: 1950479042 SELECT ACTION_SET_MEMBER_ID, ACTION_ID, ACTION_GROUP_ID, SEQUENCE, SUMMARY_THRESHOLD, ABORT_FLAG, ERROR_ACTION_SEQUENCE FROM ALR_ACTION_SET_MEMBERS WHERE APPLICATION_ID = :0 AND ALERT_ID = :1 AND ACTION_SET_ID = :2 AND ENABLED_FLAG = 'Y' AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE ORDER BY SEQUENCE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.03 3 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=3 pr=3 pw=0 time=13266 us cost=3 size=51 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SET_MEMBERS (cr=3 pr=3 pw=0 time=13022 us cost=2 size=51 card=1) 1 1 1 INDEX RANGE SCAN ALR_ACTION_SET_MEMBERS_N1 (cr=2 pr=2 pw=0 time=10625 us cost=1 size=0 card=1)(object id 27621) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 Disk file operations I/O 1 0.00 0.00 db file sequential read 3 0.00 0.01 ******************************************************************************** SQL ID: 1z2wnd16k37nu Plan Hash: 432303922 SELECT A.ACTION_ID, A.NAME, A.ACTION_TYPE, A.BODY ,A.CONCURRENT_PROGRAM_ID, DECODE (A.LIST_ID,NULL, A.TO_RECIPIENTS, D.TO_RECIPIENTS),DECODE (A.LIST_ID, NULL, A.CC_RECIPIENTS, D.CC_RECIPIENTS),DECODE (A.LIST_ID,NULL, A.BCC_RECIPIENTS, D.BCC_RECIPIENTS),DECODE (A.LIST_ID,NULL, A.PRINT_RECIPIENTS, D.PRINT_RECIPIENTS),DECODE (A.LIST_ID,NULL, A.PRINTER, D.PRINTER),A.SUBJECT, A.REPLY_TO,A.COLUMN_WRAP_FLAG, A.MAXIMUM_SUMMARY_MESSAGE_WIDTH,A.ACTION_LEVEL_TYPE, ' ', A.FILE_NAME, A.ARGUMENT_STRING,A.PROGRAM_APPLICATION_ID, A.LIST_APPLICATION_ID, A.RESPONSE_SET_ID,A.FOLLOW_UP_AFTER_DAYS, A.VERSION_NUMBER FROM ALR_ACTIONS A, ALR_DISTRIBUTION_LISTS D WHERE A.APPLICATION_ID=:0 AND A.ALERT_ID = :1 AND A.ACTION_ID = :2 AND A.ENABLED_FLAG = 'Y' AND NVL(D.END_DATE_ACTIVE(+),SYSDATE+1) >= SYSDATE AND A.APPLICATION_ID = D.APPLICATION_ID (+) AND A.LIST_ID = D.LIST_ID (+) UNION ALL SELECT -5, L.MEANING, 'A', NULL, -1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, -1, NULL, NULL, NULL, NULL, -1, -1, -1, -1, -1 FROM ALR_LOOKUPS L WHERE -5 = :2 AND LOOKUP_TYPE = 'ALR_EXIT_ACTION' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 1 0.00 0.01 0 0 0 0 Fetch 1 0.00 0.00 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.03 3 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 UNION-ALL (cr=3 pr=3 pw=0 time=6598 us) 1 1 1 NESTED LOOPS OUTER (cr=3 pr=3 pw=0 time=6482 us cost=5 size=506 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID ALR_ACTIONS (cr=3 pr=3 pw=0 time=6401 us cost=3 size=344 card=1) 1 1 1 INDEX RANGE SCAN ALR_ACTIONS_U1 (cr=2 pr=2 pw=0 time=5592 us cost=2 size=0 card=1)(object id 27460) 0 0 0 TABLE ACCESS BY INDEX ROWID ALR_DISTRIBUTION_LISTS (cr=0 pr=0 pw=0 time=45 us cost=2 size=162 card=1) 0 0 0 INDEX RANGE SCAN ALR_DISTRIBUTION_LISTS_U1 (cr=0 pr=0 pw=0 time=19 us cost=1 size=0 card=1)(object id 27759) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=5 us) 0 0 0 TABLE ACCESS BY INDEX ROWID ALR_LOOKUPS (cr=0 pr=0 pw=0 time=0 us cost=2 size=90 card=3) 0 0 0 INDEX RANGE SCAN ALR_LOOKUPS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=3)(object id 27785) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 db file sequential read 3 0.00 0.00 ******************************************************************************** SQL ID: 8ts2mvwq7jk33 Plan Hash: 3619813786 UPDATE ALR_ALERT_CHECKS SET SUCCESS_FLAG = :0 WHERE APPLICATION_ID = :1 AND ALERT_CHECK_ID = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.03 4 4 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.03 4 4 3 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE ALR_ALERT_CHECKS (cr=4 pr=4 pw=0 time=31061 us) 1 1 1 INDEX UNIQUE SCAN ALR_ALERT_CHECKS_U1 (cr=3 pr=3 pw=0 time=21836 us cost=2 size=13 card=1)(object id 27699) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 db file sequential read 4 0.01 0.02 ******************************************************************************** SQL ID: 53saa2zkr6wc3 Plan Hash: 2631433895 select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 58 0.00 0.00 0 0 0 0 Fetch 117 0.01 0.03 10 304 0 59 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 177 0.01 0.03 10 304 0 59 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID CCOL$ (cr=5 pr=2 pw=0 time=3536 us cost=4 size=18 card=1) 1 1 1 INDEX RANGE SCAN I_CCOL1 (cr=4 pr=2 pw=0 time=3488 us cost=3 size=0 card=1)(object id 51) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 10 0.01 0.02 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 1gu8t96d0bdmu Plan Hash: 17605035 select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols, nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans, t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln, t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1), nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0), nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.01 0.03 18 38 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 0.01 0.03 18 38 0 5 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN OUTER (cr=7 pr=6 pw=0 time=11074 us cost=5 size=182 card=1) 1 1 1 TABLE ACCESS CLUSTER TAB$ (cr=5 pr=4 pw=0 time=8288 us cost=4 size=143 card=1) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=2 pw=0 time=5126 us cost=2 size=0 card=1)(object id 3) 0 0 0 BUFFER SORT (cr=2 pr=2 pw=0 time=2752 us cost=1 size=39 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=2 pr=2 pw=0 time=2684 us cost=1 size=39 card=1) 0 0 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=2 pr=2 pw=0 time=2678 us cost=0 size=0 card=1)(object id 9228132) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 18 0.00 0.01 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: gf6xvyxy51tqy Plan Hash: 2456376070 UPDATE FND_PROFILE_OPTION_VALUES SET PROFILE_OPTION_VALUE = :B9 , LAST_UPDATE_DATE = :B8 , LAST_UPDATED_BY = :B7 , LAST_UPDATE_LOGIN = :B6 WHERE PROFILE_OPTION_ID = :B5 AND APPLICATION_ID = :B4 AND LEVEL_ID = :B3 AND LEVEL_VALUE = :B2 AND (NVL(:B1 , -1) = -1 OR LEVEL_VALUE_APPLICATION_ID = :B1 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.02 0.02 2 9 20 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.02 0.03 2 9 20 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_PROFILE_OPTION_VALUES (cr=23 pr=21 pw=0 time=142126 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES (cr=4 pr=0 pw=0 time=184 us cost=4 size=53 card=1) 1 1 1 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=3 pr=0 pw=0 time=136 us cost=3 size=0 card=1)(object id 1391365) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.01 ******************************************************************************** SQL ID: gx4mv66pvj3xz Plan Hash: 3886069984 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 10 0.00 0.00 0 0 0 0 Fetch 68 0.00 0.02 6 104 0 58 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 80 0.00 0.03 6 104 0 58 Misses in library cache during parse: 0 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 ---------- ---------- ---------- --------------------------------------------------- 5 6 6 TABLE ACCESS CLUSTER CDEF$ (cr=10 pr=2 pw=0 time=11654 us cost=3 size=300 card=6) 1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=3 pr=2 pw=0 time=4440 us cost=2 size=0 card=1)(object id 27) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 6 0.01 0.02 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 22nharvcdzu2p Plan Hash: 91863687 SELECT MEANING FROM HR_LOOKUPS WHERE LOOKUP_TYPE = :B2 AND LOOKUP_CODE = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 0 0 0 0 Fetch 2 0.00 0.02 9 12 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.01 0.03 9 12 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=6 pr=5 pw=0 time=19022 us) 1 1 1 NESTED LOOPS (cr=5 pr=4 pw=0 time=8402 us cost=5 size=104 card=1) 1 1 1 VIEW VW_SQ_1 (cr=2 pr=2 pw=0 time=4767 us cost=2 size=43 card=1) 1 1 1 HASH GROUP BY (cr=2 pr=2 pw=0 time=4757 us cost=2 size=27 card=1) 1 1 1 INDEX RANGE SCAN FND_LOOKUP_TYPES_U1 (cr=2 pr=2 pw=0 time=3897 us cost=2 size=54 card=2)(object id 32859) 1 1 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=2 pw=0 time=3620 us cost=2 size=0 card=1)(object id 14622584) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=1 pr=1 pw=0 time=10591 us cost=3 size=61 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 9 0.00 0.02 ******************************************************************************** SQL ID: gyxv37z6aqyqp Plan Hash: 4230259005 SELECT P.PID, P.SPID, AUDSID, PROCESS, SUBSTR(USERENV('LANGUAGE'), INSTR( USERENV('LANGUAGE'), '.') + 1) FROM V$SESSION S, V$PROCESS P WHERE P.ADDR = S.PADDR AND S.AUDSID = USERENV('SESSIONID') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 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.02 0.03 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) 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=11787 us cost=14 size=134 card=2) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=4605 us cost=7 size=86 card=2) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=4570 us cost=7 size=78 card=2) 379 379 379 FIXED TABLE FULL X$KSLWT (cr=0 pr=0 pw=0 time=3056 us cost=3 size=55053 card=6117) 1 1 1 FIXED TABLE FIXED INDEX X$KSUSE (ind:1) (cr=0 pr=0 pw=0 time=1858 us cost=0 size=30 card=1) 1 1 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=14 us cost=0 size=4 card=1) 370 370 370 FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=1258 us cost=6 size=118080 card=4920) ******************************************************************************** SQL ID: a9u0s3g93f47z Plan Hash: 2094022552 select decode(u.type#, 2, u.ext_username, u.name), o.name, t.update$, t.insert$, t.delete$, t.enabled, decode(bitand(t.property, 8192), 8192, 1, 0), decode(bitand(t.property, 65536), 65536, 1, 0), decode(bitand(t.property, 131072), 131072, 1, 0), (select o.name from obj$ o where o.obj# = u.spare2 and o.type# =57) from sys.obj$ o, sys.user$ u, sys.trigger$ t, sys.obj$ bo where t.baseobject=bo.obj# and bo.name = :1 and bo.spare3 = :2 and bo.namespace = 1 and t.obj#=o.obj# and o.owner#=u.user# and o.type# = 12 and bitand(property,16)=0 and bitand(property,8)=0 order by o.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.01 0.02 11 25 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.01 0.03 11 25 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=4 size=33 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=3 size=0 card=1)(object id 26619161) 0 0 0 SORT ORDER BY (cr=5 pr=3 pw=0 time=9308 us cost=11 size=207 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=9225 us cost=10 size=207 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=9216 us cost=9 size=101 card=1) 0 0 0 NESTED LOOPS (cr=5 pr=3 pw=0 time=9212 us cost=6 size=64 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ5 (cr=3 pr=2 pw=0 time=7055 us cost=3 size=36 card=1)(object id 26619165) 0 0 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=2 pw=0 time=2144 us cost=3 size=56 card=2) 0 0 0 INDEX RANGE SCAN I_TRIGGER1 (cr=2 pr=2 pw=0 time=2120 us cost=1 size=0 card=2)(object id 119) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=37 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 26619161) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=106 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) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 11 0.01 0.02 ******************************************************************************** SQL ID: 4m7m0t6fjcs5x Plan Hash: 89955185 update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6, cache=:7,highwater=:8,audit$=:9,flags=:10 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.02 1 4 5 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.03 1 4 5 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: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE SEQ$ (cr=2 pr=0 pw=0 time=503 us) 1 1 1 INDEX UNIQUE SCAN I_SEQ1 (cr=2 pr=0 pw=0 time=23 us cost=1 size=67 card=1)(object id 99) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 1 0.02 0.02 ******************************************************************************** SQL ID: 2450j0nxcnga5 Plan Hash: 0 declare sql_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, sql_dummy1, :org_id, :server_id);end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 17 0.05 0.03 0 0 0 17 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.05 0.03 0 0 0 17 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 17 0.00 0.00 SQL*Net message from client 17 0.01 0.03 ******************************************************************************** SQL ID: 8kubp71731tnc Plan Hash: 3736647136 select ON_FAILURE_LOG_LEVEL ,USER_CONCURRENT_PROGRAM_NAME into :b0:b1,:b2 from FND_CONCURRENT_REQUESTS FCR ,FND_CONC_PROG_ONSITE_INFO FCP , FND_CONCURRENT_PROGRAMS_VL FCPVL where ((((FCR.REQUEST_ID=:b3 and FCR.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID) and FCR.PROGRAM_APPLICATION_ID=FCP.PROGRAM_APPLICATION_ID) and FCPVL.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID) and FCPVL.APPLICATION_ID=FCP.PROGRAM_APPLICATION_ID) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.01 0 0 0 0 Execute 1 0.00 0.01 0 0 0 0 Fetch 1 0.00 0.00 2 13 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.03 0.03 2 13 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=13 pr=2 pw=0 time=4658 us cost=6 size=94 card=1) 1 1 1 NESTED LOOPS (cr=9 pr=2 pw=0 time=4501 us cost=4 size=43 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=2 pw=0 time=4374 us cost=4 size=33 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=182 us cost=3 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=97 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PROG_ONSITE_INFO (cr=3 pr=2 pw=0 time=4178 us cost=1 size=239856 card=14991) 1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=1 pw=0 time=1651 us cost=0 size=0 card=1)(object id 194616) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=107 us cost=0 size=149760 card=14976)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL (cr=4 pr=0 pw=0 time=137 us cost=2 size=761889 card=14939) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1 (cr=3 pr=0 pw=0 time=85 us cost=1 size=0 card=1)(object id 33634) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 3rwmntrn04p4f Plan Hash: 0 begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:session_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_priority_request, :form_id, :form_application_id, :conc_process_id, :conc_queue_id, :queue_appl_id, :server_id); fnd_profile.put('ORG_ID', :org_id); fnd_profile.put('MFG_ORGANIZATION_ID', :mfg_org_id); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :coa); fnd_profile.put('APPS_MAINTENANCE_MODE', :amm); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.02 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.03 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SQL ID: bpv5n2m9dhcc4 Plan Hash: 1884197401 UPDATE FND_CONCURRENT_REQUESTS SET ORACLE_SESSION_ID = :B4 , ORACLE_PROCESS_ID = :B3 , OS_PROCESS_ID = :B2 , NLS_CODESET = :B1 WHERE REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.02 0 4 4 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.02 0 4 4 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=15 pr=0 pw=0 time=4108 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=432 us cost=3 size=53 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=402 us cost=2 size=0 card=1)(object id 34547) ******************************************************************************** SQL ID: 5n1fs4m2n2y0r Plan Hash: 992489688 select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 22 0.00 0.00 0 0 0 0 Fetch 74 0.01 0.02 8 170 0 52 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 98 0.01 0.02 8 170 0 52 Misses in library cache during parse: 0 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 ---------- ---------- ---------- --------------------------------------------------- 4 3 4 TABLE ACCESS BY INDEX ROWID ICOL$ (cr=9 pr=2 pw=0 time=6976 us cost=4 size=58 card=2) 4 3 4 INDEX RANGE SCAN I_ICOL1 (cr=6 pr=2 pw=0 time=6949 us cost=3 size=0 card=2)(object id 37) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 8 0.00 0.01 ******************************************************************************** SQL ID: 3nkd3g3ju5ph1 Plan Hash: 853875749 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 1 0.00 0.00 0 0 0 0 Execute 29 0.00 0.00 0 0 0 0 Fetch 29 0.00 0.02 10 116 0 29 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 59 0.00 0.02 10 116 0 29 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=4 pw=0 time=11035 us cost=4 size=86 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=3 pw=0 time=7992 us cost=3 size=0 card=1)(object id 26619162) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 10 0.00 0.01 ******************************************************************************** SQL ID: gbd5g50k3q9dc Plan Hash: 246530440 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.02 1 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 1 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=4 pr=1 pw=0 time=24766 us cost=5 size=35 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PP_ACTIONS (cr=4 pr=1 pw=0 time=24541 us cost=4 size=35 card=1) 1 1 1 INDEX RANGE SCAN FND_CONC_PP_ACTIONS_N1 (cr=3 pr=1 pw=0 time=24447 us cost=3 size=0 card=1)(object id 34250) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.02 0.02 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 8swypbbr0m372 Plan Hash: 872636971 select order#,columns,types from access$ where d_obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.01 0.02 3 24 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 0.01 0.02 3 24 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=3 pr=3 pw=0 time=19367 us cost=5 size=360 card=8) 0 0 0 INDEX RANGE SCAN I_ACCESS1 (cr=3 pr=3 pw=0 time=19346 us cost=3 size=0 card=8)(object id 118) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.01 0.01 ******************************************************************************** SQL ID: 5vbbcp6pd58b8 Plan Hash: 0 begin Fnd_Concurrent.Init_Request; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.04 0.02 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.05 0.02 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 1mjd9xp80vuqa Plan Hash: 2984635380 select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.01 0.02 6 32 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 17 0.01 0.02 6 32 0 8 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID SYN$ (cr=4 pr=4 pw=0 time=9804 us cost=3 size=34 card=1) 1 1 1 INDEX UNIQUE SCAN I_SYN1 (cr=3 pr=3 pw=0 time=8437 us cost=2 size=0 card=1)(object id 98) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 6 0.00 0.01 Disk file operations I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 1b8bju290ca31 Plan Hash: 4260941437 SELECT OUT_AGENT_GUID,TO_AGENT_GUID,WF_PROCESS_TYPE,WF_PROCESS_NAME,PRIORITY , PARAMETERS FROM WF_EVENT_SUBSCRIPTIONS WHERE GUID = :B1 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.02 2 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.02 2 6 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID WF_EVENT_SUBSCRIPTIONS (cr=3 pr=1 pw=0 time=10370 us cost=2 size=68 card=1) 1 1 1 INDEX UNIQUE SCAN WF_EVENT_SUBSCRIPTIONS_U1 (cr=2 pr=1 pw=0 time=10313 us cost=1 size=0 card=1)(object id 166653) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.01 ******************************************************************************** SQL ID: 1v8htaq6acrzj Plan Hash: 1436692702 SELECT PROFILE_OPTION_NAME, PROFILE_OPTION_VALUE, PROFILE_OPTION_LONG, LONG_FLAG FROM ALR_PROFILE_OPTIONS ORDER BY PROFILE_OPTION_NAME call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 25 0.00 0.00 2 6 0 24 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 0.02 0.02 2 6 0 24 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 24 24 24 SORT ORDER BY (cr=2 pr=2 pw=0 time=3436 us cost=4 size=1080 card=24) 24 24 24 TABLE ACCESS FULL ALR_PROFILE_OPTIONS (cr=2 pr=2 pw=0 time=3322 us cost=3 size=1080 card=24) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 29 0.00 0.00 SQL*Net message from client 29 0.00 0.00 db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: 45vkgawsw59h4 Plan Hash: 3017560629 SELECT DISTINCT O.ORACLE_USERNAME, O.ENCRYPTED_ORACLE_PASSWORD, O.ORACLE_ID , TO_CHAR(I.DATA_GROUP_ID) FROM FND_ORACLE_USERID O, ALR_ALERT_INSTALLATIONS I WHERE O.ORACLE_ID = I.ORACLE_ID AND I.APPLICATION_ID = :0 AND I.ALERT_ID = :1 AND I.ENABLED_FLAG = 'Y' ORDER BY DECODE(O.ORACLE_USERNAME, USER, 0, 1), O.ORACLE_USERNAME, I.DATA_GROUP_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 3 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 3 5 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=5 pr=3 pw=0 time=8929 us cost=6 size=130 card=1) 1 1 1 HASH UNIQUE (cr=5 pr=3 pw=0 time=8751 us cost=5 size=130 card=1) 1 1 1 NESTED LOOPS (cr=5 pr=3 pw=0 time=7708 us) 1 1 1 NESTED LOOPS (cr=4 pr=3 pw=0 time=7547 us cost=4 size=130 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID ALR_ALERT_INSTALLATIONS (cr=3 pr=3 pw=0 time=7241 us cost=3 size=19 card=1) 1 1 1 INDEX RANGE SCAN ALR_ALERT_INSTALLATIONS_U1 (cr=2 pr=2 pw=0 time=5011 us cost=2 size=0 card=1)(object id 27726) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U1 (cr=1 pr=0 pw=0 time=280 us cost=0 size=0 card=1)(object id 22603) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=1 pr=0 pw=0 time=128 us cost=1 size=111 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 Disk file operations I/O 4 0.00 0.00 db file sequential read 3 0.00 0.00 ******************************************************************************** SQL ID: db78fxqxwxt7r Plan Hash: 2324581405 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.01 0.00 0 0 0 0 Fetch 4 0.01 0.01 7 12 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.02 0.01 7 12 0 12 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 SORT ORDER BY (cr=3 pr=3 pw=0 time=3689 us cost=0 size=0 card=0) 2 2 2 TABLE ACCESS CLUSTER HISTGRM$ (cr=3 pr=3 pw=0 time=3563 us) 1 1 1 INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=2 pr=2 pw=0 time=2428 us)(object id 189) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 7 0.00 0.01 ******************************************************************************** SQL ID: 0crj1mb804wpq Plan Hash: 1767056815 SELECT A.NAME, A.SEQUENCE, S.SUPPRESS_FLAG, A.DETAIL_MAX_LEN, A.SUMMARY_MAX_LEN, A.FORMAT_MASK FROM ALR_ACTION_SET_OUTPUTS S, ALR_ALERT_OUTPUTS A WHERE A.APPLICATION_ID = :0 AND A.ALERT_ID = :1 AND S.ACTION_SET_ID(+) = :2 AND A.APPLICATION_ID = S.APPLICATION_ID (+)AND A.ALERT_ID = S.ALERT_ID (+)AND A.NAME = S.NAME (+) AND A.ENABLED_FLAG = 'Y' ORDER BY A.SEQUENCE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 6 21 0 9 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 6 21 0 9 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 9 9 9 SORT ORDER BY (cr=21 pr=6 pw=0 time=8736 us cost=5 size=60 card=1) 9 9 9 NESTED LOOPS OUTER (cr=21 pr=6 pw=0 time=9044 us cost=4 size=60 card=1) 9 9 9 TABLE ACCESS BY INDEX ROWID ALR_ALERT_OUTPUTS (cr=3 pr=3 pw=0 time=5939 us cost=3 size=31 card=1) 9 9 9 INDEX RANGE SCAN ALR_ALERT_OUTPUTS_N1 (cr=2 pr=2 pw=0 time=5120 us cost=2 size=0 card=1)(object id 27742) 9 9 9 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SET_OUTPUTS (cr=18 pr=3 pw=0 time=2705 us cost=1 size=29 card=1) 9 9 9 INDEX UNIQUE SCAN ALR_ACTION_SET_OUTPUTS_U1 (cr=9 pr=2 pw=0 time=1959 us cost=0 size=0 card=1)(object id 27643) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 db file sequential read 6 0.00 0.00 ******************************************************************************** SQL ID: 2syvqzbxp4k9z Plan Hash: 2485131612 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 7 0.00 0.00 0 0 0 0 Execute 7 0.01 0.00 0 0 0 0 Fetch 7 0.01 0.01 2 14 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.02 0.01 2 14 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=2 pw=0 time=16081 us cost=6 size=69 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=2 pw=0 time=16063 us cost=5 size=50 card=1) 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=2 pw=0 time=16049 us cost=2 size=17 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us cost=3 size=33 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)(object id 26619161) 0 0 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us cost=1 size=19 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) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 2 0.01 0.01 ******************************************************************************** SQL ID: 5hw78v66jn9mc Plan Hash: 2843490295 SELECT DISTINCT PRODUCT_DEPENDENCY, LEVEL FROM FND_PRODUCT_INIT_DEPENDENCY P1 WHERE LEVEL = (SELECT MAX(LEVEL) FROM FND_PRODUCT_INIT_DEPENDENCY P2 WHERE P2.PRODUCT_DEPENDENCY = P1.PRODUCT_DEPENDENCY CONNECT BY PRIOR P2.PRODUCT_DEPENDENCY = P2.APPLICATION_SHORT_NAME START WITH P2.APPLICATION_SHORT_NAME = UPPER(:B1 ) ) CONNECT BY PRIOR PRODUCT_DEPENDENCY = APPLICATION_SHORT_NAME START WITH APPLICATION_SHORT_NAME = UPPER(:B1 ) ORDER BY LEVEL DESC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.02 0.01 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.01 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT UNIQUE (cr=1 pr=0 pw=0 time=548 us cost=2 size=704 card=8) 0 0 0 FILTER (cr=1 pr=0 pw=0 time=509 us) 0 0 0 CONNECT BY NO FILTERING WITH SW (UNIQUE) (cr=1 pr=0 pw=0 time=508 us) 283 283 283 INDEX FULL SCAN FND_PRODUCT_INIT_DEPENDENCY_U1 (cr=1 pr=0 pw=0 time=332 us cost=1 size=2264 card=283)(object id 108134) 0 0 0 SORT AGGREGATE (cr=0 pr=0 pw=0 time=0 us) 0 0 0 FILTER (cr=0 pr=0 pw=0 time=0 us) 0 0 0 CONNECT BY NO FILTERING WITH START-WITH (cr=0 pr=0 pw=0 time=0 us) 0 0 0 INDEX FULL SCAN FND_PRODUCT_INIT_DEPENDENCY_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=2264 card=283)(object id 108134) ******************************************************************************** SQL ID: f711myt0q6cma Plan Hash: 0 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid, userhost,terminal,action#,returncode, logoff$lread,logoff$pread, logoff$lwrite,logoff$dead, logoff$time,comment$text,spare1,clientid, sessioncpu,proxy$sid,user$guid, instance#,process#,auditid,dbid) values (:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date),:13,:14,:15,:16,:17, :18, :19,:20,:21,:22) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.01 1 1 10 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.01 1 1 10 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD TABLE CONVENTIONAL (cr=1 pr=1 pw=0 time=18046 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 1 0.00 0.00 db file sequential read 1 0.01 0.01 ******************************************************************************** SQL ID: 4g2612tvbn0j8 Plan Hash: 0 begin FND_TRACE.START_TRACE; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.01 0.01 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.01 0.01 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.01 0.01 ******************************************************************************** SQL ID: axmdf8vq7k1rh Plan Hash: 2252041172 select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$, flags from seq$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.01 3 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.01 0.01 3 12 0 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID SEQ$ (cr=3 pr=3 pw=0 time=13221 us cost=2 size=67 card=1) 1 1 1 INDEX UNIQUE SCAN I_SEQ1 (cr=2 pr=2 pw=0 time=4888 us cost=1 size=0 card=1)(object id 99) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.00 0.01 ******************************************************************************** SQL ID: 36fdx918saa3h Plan Hash: 1996009488 SELECT TEXT FROM WF_RESOURCES WHERE TYPE = :B2 AND NAME = :B1 AND LANGUAGE = 'US' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.01 6 21 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.00 0.01 6 21 0 7 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID WF_RESOURCES (cr=3 pr=3 pw=0 time=7101 us cost=2 size=70 card=1) 1 1 1 INDEX UNIQUE SCAN WF_RESOURCES_PK (cr=2 pr=2 pw=0 time=4059 us cost=1 size=0 card=1)(object id 74968) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 6 0.00 0.01 ******************************************************************************** SQL ID: 55dc767ajydh3 Plan Hash: 2802907561 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 3 0.00 0.00 0 0 0 0 Execute 21 0.01 0.00 0 0 0 0 Fetch 21 0.01 0.01 2 67 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 45 0.02 0.01 2 67 0 4 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTION_VALUES (cr=4 pr=0 pw=0 time=6690 us cost=4 size=33 card=1) 1 1 1 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (cr=3 pr=0 pw=0 time=78 us cost=3 size=0 card=1)(object id 1391365) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.01 0.01 ******************************************************************************** SQL ID: ggvskj3ku51s7 Plan Hash: 2765076795 select CP.CONCURRENT_PROGRAM_NAME ,CP.USER_CONCURRENT_PROGRAM_NAME , CR.Has_Sub_Request ,CR.Resubmitted into :b0,:b1,:b2,:b3 from FND_CONCURRENT_REQUESTS CR ,FND_CONCURRENT_PROGRAMS_VL 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 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.01 0.00 0 11 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.01 0 11 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=11 pr=0 pw=0 time=357 us cost=6 size=98 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=232 us cost=4 size=47 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=171 us cost=3 size=21 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=121 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=58 us cost=1 size=389376 card=14976) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=40 us cost=0 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL (cr=4 pr=0 pw=0 time=96 us cost=2 size=761889 card=14939) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1 (cr=3 pr=0 pw=0 time=75 us cost=1 size=0 card=1)(object id 33634) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 10uz22m213zkp Plan Hash: 773311590 SELECT RESPONSE_SET_ID, NAME FROM ALR_RESPONSE_SETS WHERE APPLICATION_ID = :0 AND ALERT_ID = :1 AND ENABLED_FLAG = 'Y' AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.01 1 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID ALR_RESPONSE_SETS (cr=1 pr=1 pw=0 time=2128 us cost=2 size=36 card=1) 0 0 0 INDEX RANGE SCAN ALR_RESPONSE_SETS_U2 (cr=1 pr=1 pw=0 time=2118 us cost=1 size=0 card=1)(object id 27996) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: grwydz59pu6mc Plan Hash: 1028580536 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 8 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.01 0.01 6 18 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 0.01 0.01 6 18 0 8 Misses in library cache during parse: 0 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 VIEW$ (cr=1 pr=1 pw=0 time=2066 us cost=1 size=15 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 3 0.00 0.00 db file sequential read 6 0.00 0.00 ******************************************************************************** SQL ID: cqwb1mrrxxu2x Plan Hash: 3311507178 SELECT ACTION_SET_ID, SEQUENCE, NAME, SUPPRESS_FLAG, SUPPRESS_DAYS, RECIPIENTS_VIEW_ONLY_FLAG FROM ALR_ACTION_SETS WHERE APPLICATION_ID = :0 AND ALERT_ID = :1 AND ENABLED_FLAG = 'Y' AND NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE ORDER BY SEQUENCE, NAME call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 3 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT ORDER BY (cr=3 pr=3 pw=0 time=5228 us cost=4 size=54 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SETS (cr=3 pr=3 pw=0 time=5074 us cost=3 size=54 card=1) 1 1 1 INDEX RANGE SCAN ALR_ACTION_SETS_U2 (cr=2 pr=2 pw=0 time=3654 us cost=2 size=0 card=1)(object id 27565) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 db file sequential read 3 0.00 0.00 Disk file operations I/O 2 0.00 0.00 ******************************************************************************** SQL ID: 18vgyatw1kbvw Plan Hash: 1934133821 SELECT P.OPTIMIZER_MODE, P.CONCURRENT_PROGRAM_NAME, UPPER(P.ENABLE_TRACE), UPPER(R.ENABLE_TRACE), DECODE(UPPER(P.ENABLE_TIME_STATISTICS),'Y','TRUE', NULL), EXECUTION_METHOD_CODE FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID AND P.APPLICATION_ID = R.PROGRAM_APPLICATION_ID AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 7 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=423 us cost=4 size=68 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=360 us cost=3 size=19 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=323 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=52 us cost=1 size=733824 card=14976) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=31 us cost=0 size=0 card=1)(object id 33183) ******************************************************************************** SQL ID: 6u1kf5ctzu70k Plan Hash: 3435868795 select EXECUTABLE_APPLICATION_ID into :b0 from FND_CONCURRENT_PROGRAMS where (APPLICATION_ID=:b1 and CONCURRENT_PROGRAM_ID= :b2) 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=126 us cost=2 size=15 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=88 us cost=1 size=0 card=1)(object id 33183) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 7qs7fx89194u1 Plan Hash: 1990737700 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 2 0.00 0.00 0 0 0 0 Execute 36 0.00 0.00 0 0 0 0 Fetch 36 0.02 0.00 4 108 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 74 0.02 0.01 4 108 0 5 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_X99 (cr=3 pr=0 pw=0 time=92 us cost=3 size=29 card=1)(object id 13748041) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.00 0.00 ******************************************************************************** SQL ID: 3vtbsbuurgh6f Plan Hash: 2039355164 SELECT HIERARCHY_TYPE FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_ID = :B2 AND APPLICATION_ID = :B1 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 4 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.01 4 6 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=2 pw=0 time=3109 us cost=2 size=19 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U1 (cr=2 pr=2 pw=0 time=3038 us cost=1 size=0 card=1)(object id 33238) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.00 0.00 ******************************************************************************** SQL ID: 9gdxsmyzbrdkr Plan Hash: 1883182706 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 2 0.00 0.00 0 0 0 0 Execute 37 0.00 0.00 0 0 0 0 Fetch 37 0.00 0.00 2 74 0 28 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 76 0.00 0.01 2 74 0 28 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: 3w4qs0tbpmxr6 Plan Hash: 3924106966 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 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 5 20 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22 0.00 0.01 5 20 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=2 pr=1 pw=0 time=1668 us cost=2 size=112 card=4) 0 0 0 INDEX RANGE SCAN I_CDEF3 (cr=2 pr=1 pw=0 time=1654 us cost=1 size=0 card=1)(object id 49) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 5 0.00 0.00 ******************************************************************************** SQL ID: 3wxhvujaykjw5 Plan Hash: 958774444 SELECT APPLICATION_ID,ALERT_ID,ALERT_NAME,ALERT_CONDITION_TYPE FROM ALR_ALERTS WHERE APPLICATION_ID = :0 AND ALERT_ID = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.01 0.00 0 181 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.01 0 181 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS FULL ALR_ALERTS (cr=181 pr=0 pw=0 time=4593 us cost=53 size=48 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 ******************************************************************************** SQL ID: 3r3j4ftjs9mu8 Plan Hash: 4001234684 SELECT PLSQL_LOG, PLSQL_OUT, PLSQL_DIR FROM FND_CONCURRENT_PROCESSES P, FND_CONCURRENT_REQUESTS R WHERE P.CONCURRENT_PROCESS_ID = R.CONTROLLING_MANAGER AND R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 7 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=444 us cost=4 size=81 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=367 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=346 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES (cr=3 pr=0 pw=0 time=66 us cost=1 size=616352 card=9064) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=50 us cost=0 size=0 card=1)(object id 33070) ******************************************************************************** SQL ID: 1sq0yr7tvn756 Plan Hash: 72729777 SELECT AASI.NAME, AASI.VALUE, AAI.DATA_TYPE FROM ALR_ACTION_SET_INPUTS AASI, ALR_ALERT_INPUTS AAI WHERE AASI.APPLICATION_ID = :0 AND AASI.ALERT_ID = :1 AND AASI.ACTION_SET_ID = :2 AND AAI.APPLICATION_ID=AASI.APPLICATION_ID AND AAI.ALERT_ID = AASI.ALERT_ID AND AAI.NAME = AASI.NAME AND AAI.ENABLED_FLAG = 'Y' 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.01 0.00 2 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 2 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=2 pw=0 time=3702 us) 0 0 0 NESTED LOOPS (cr=2 pr=2 pw=0 time=3674 us cost=4 size=64 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID ALR_ALERT_INPUTS (cr=2 pr=2 pw=0 time=3664 us cost=3 size=30 card=1) 0 0 0 INDEX RANGE SCAN ALR_ALERT_INPUTS_N1 (cr=2 pr=2 pw=0 time=3644 us cost=2 size=0 card=1)(object id 27713) 0 0 0 INDEX UNIQUE SCAN ALR_ACTION_SET_INPUTS_U1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 27608) 0 0 0 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SET_INPUTS (cr=0 pr=0 pw=0 time=0 us cost=1 size=34 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: 87gaftwrm2h68 Plan Hash: 2863542513 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 15 0.00 0.00 0 0 0 0 Fetch 15 0.01 0.00 4 60 0 15 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 31 0.01 0.01 4 60 0 15 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=4 pr=0 pw=0 time=110 us cost=4 size=42 card=1) 1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=3 pr=0 pw=0 time=83 us cost=3 size=0 card=1)(object id 26619161) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.00 0.00 ******************************************************************************** SQL ID: 937qzy5hh3pyq Plan Hash: 102314134 SELECT /*+ index_desc(ALR_ACTION_SET_CHECKS ALR_ACTION_SET_CHECKS_N2) */ CHECK_ID FROM ALR_ACTION_SET_CHECKS WHERE APPLICATION_ID=:0 AND ALERT_ID=:1 AND ACTION_SET_ID=:2 AND ORACLE_ID=:3 AND SUCCESS_FLAG='Y' AND rownum=1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 1 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 7 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 COUNT STOPKEY (cr=7 pr=1 pw=0 time=2529 us) 1 1 1 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SET_CHECKS (cr=7 pr=1 pw=0 time=2513 us cost=4 size=26 card=1) 2 2 2 INDEX RANGE SCAN DESCENDING ALR_ACTION_SET_CHECKS_N2 (cr=4 pr=0 pw=0 time=237 us cost=3 size=0 card=5)(object id 27583) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5 0.00 0.00 SQL*Net message from client 5 0.00 0.00 db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: bpfbs0gst1hjc Plan Hash: 2903460541 SELECT APPLICATION_ID, PROFILE_OPTION_ID, USER_CHANGEABLE_FLAG, USER_VISIBLE_FLAG, SITE_ENABLED_FLAG, SITE_UPDATE_ALLOWED_FLAG, APP_ENABLED_FLAG, APP_UPDATE_ALLOWED_FLAG, RESP_ENABLED_FLAG, RESP_UPDATE_ALLOWED_FLAG, USER_ENABLED_FLAG, USER_UPDATE_ALLOWED_FLAG, HIERARCHY_TYPE, SERVER_ENABLED_FLAG, ORG_ENABLED_FLAG, SERVER_UPDATE_ALLOWED_FLAG, ORG_UPDATE_ALLOWED_FLAG, SERVERRESP_ENABLED_FLAG, SERVERRESP_UPDATE_ALLOWED_FLAG FROM FND_PROFILE_OPTIONS PO WHERE PO.PROFILE_OPTION_NAME = :B1 AND PO.START_DATE_ACTIVE <= SYSDATE AND NVL(PO.END_DATE_ACTIVE, SYSDATE) >= SYSDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 2 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 2 6 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=1 pw=0 time=2325 us cost=2 size=85 card=1) 1 1 1 INDEX RANGE SCAN FND_PROFILE_OPTIONS_X99 (cr=2 pr=0 pw=0 time=232 us cost=1 size=0 card=1)(object id 14622582) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: 4muh1y3arxuck Plan Hash: 3865572370 SELECT NAME FROM HR_OPERATING_UNITS WHERE ORGANIZATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 3 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 3 10 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 4 0.00 0.00 db file sequential read 3 0.00 0.00 ******************************************************************************** SQL ID: 2zqm461dyzn12 Plan Hash: 3620521958 UPDATE FND_CACHE_VERSIONS SET VERSION = VERSION + 1 WHERE NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.01 0.00 0 2 6 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.00 0 2 6 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CACHE_VERSIONS (cr=1 pr=0 pw=0 time=458 us) 1 1 1 INDEX RANGE SCAN FND_CACHE_VERSIONS_PK1 (cr=1 pr=0 pw=0 time=84 us cost=1 size=24 card=1)(object id 3025455) ******************************************************************************** SQL ID: 1p8nwuuamsy55 Plan Hash: 2039355164 SELECT PROFILE_OPTION_NAME FROM APPS.FND_PROFILE_OPTIONS OPT WHERE OPT.APPLICATION_ID = :B2 AND OPT.PROFILE_OPTION_ID = :B1 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 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 2 Misses in library cache during parse: 2 Misses in library cache during execute: 2 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS (cr=3 pr=0 pw=0 time=130 us cost=2 size=34 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U1 (cr=2 pr=0 pw=0 time=74 us cost=1 size=0 card=1)(object id 33238) ******************************************************************************** SQL ID: 8d5u4gbpth0zr Plan Hash: 2762886300 SELECT ALR_ALERT_CHECKS_S.NEXTVAL FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 1 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.02 0.00 0 0 1 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SEQUENCE ALR_ALERT_CHECKS_S (cr=5 pr=0 pw=0 time=3851 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=2 us cost=2 size=0 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 log file sync 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 83taa7kaw59c1 Plan Hash: 2783779297 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 2 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 133 0.01 0.00 0 56 0 123 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 145 0.01 0.00 0 56 0 123 Misses in library cache during parse: 0 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 ---------- ---------- ---------- --------------------------------------------------- 10 12 13 SORT ORDER BY (cr=5 pr=0 pw=0 time=254 us cost=5 size=2992 card=44) 10 12 13 TABLE ACCESS CLUSTER COL$ (cr=5 pr=0 pw=0 time=302 us cost=4 size=2992 card=44) 1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=3 pr=0 pw=0 time=56 us cost=2 size=0 card=1)(object id 3) ******************************************************************************** SQL ID: cpa0885m9zgsy Plan Hash: 0 begin :v1 := fnd_bes_proc.process_event(:v2, :v3); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.01 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.00 0 0 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: dy20tb1s56ahh Plan Hash: 0 begin fnd_conc_stat.collect; end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: ds1nf201ncbhd Plan Hash: 2585102522 SELECT INIT_FUNCTION_NAME FROM FND_PRODUCT_INITIALIZATION WHERE APPLICATION_SHORT_NAME = :B1 AND EXISTS (SELECT 1 FROM FND_PRODUCT_INIT_CONDITION C WHERE C.APPLICATION_SHORT_NAME = :B1 AND C.RE_INIT_CONDITION IN (:B5 , :B4 , :B3 , :B2 )) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 1 0 0 Fetch 1 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 FILTER (cr=1 pr=0 pw=0 time=150 us) 0 0 0 INDEX RANGE SCAN FND_PRODUCT_INITIALIZATION_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=24 card=1)(object id 108129) 0 0 0 INDEX RANGE SCAN FND_PRODUCT_INIT_CONDITION_U1 (cr=1 pr=0 pw=0 time=120 us cost=1 size=9 card=1)(object id 108132) ******************************************************************************** SQL ID: 3nf40w1v96gvj Plan Hash: 2651523188 SELECT ALR_ACTION_SET_CHECKS_S.NEXTVAL FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 1 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 0 1 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SEQUENCE ALR_ACTION_SET_CHECKS_S (cr=5 pr=1 pw=0 time=28828 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=8 us cost=2 size=0 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 log file sync 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: fj83qgv5su7sr Plan Hash: 1335202565 select SEQUENCE ,WIDTH ,LENGTH ,SRW_DRIVER ,HEADER_FLAG into :b0,:b1,:b2,:b3, :b4 from FND_PRINTER_STYLES where PRINTER_STYLE_NAME=:b5 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 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 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 2 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_PRINTER_STYLES (cr=2 pr=0 pw=0 time=159 us cost=1 size=36 card=1) 1 1 1 INDEX UNIQUE SCAN FND_PRINTER_STYLES_U1 (cr=1 pr=0 pw=0 time=108 us cost=0 size=0 card=1)(object id 32929) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 0s9jg1j7mykf2 Plan Hash: 3134095148 DELETE FROM FND_DEBUG_RULE_OPTIONS WHERE DEBUG_RULE_ID IN (SELECT DEBUG_RULE_ID FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME < SYSDATE) OR (REPEATION_COUNTER = 0) ) 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 5 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 5 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE FND_DEBUG_RULE_OPTIONS (cr=5 pr=0 pw=0 time=4830 us) 0 0 0 HASH JOIN SEMI (cr=5 pr=0 pw=0 time=4790 us cost=6 size=23 card=1) 8 8 8 INDEX FULL SCAN FND_DEBUG_RULE_OPTIONS_U1 (cr=1 pr=0 pw=0 time=102 us cost=1 size=112 card=8)(object id 2321837) 0 0 0 TABLE ACCESS FULL FND_DEBUG_RULES (cr=4 pr=0 pw=0 time=224 us cost=4 size=9 card=1) ******************************************************************************** SQL ID: a3pqbc9cxyfub Plan Hash: 1546270724 select FND_CONC_PRIVATE_UTILS.get_resub_time(:b0) into :b1:b2 from DUAL 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 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=19 us cost=2 size=0 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 16j4u0hq5c6hy Plan Hash: 268333230 SELECT WFA.QUEUE_NAME FROM WF_AGENTS WFA, WF_SYSTEMS WFS WHERE WFA.NAME = :B2 AND WFS.NAME = :B1 AND WFS.GUID = WFA.SYSTEM_GUID 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.01 0.00 2 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.00 2 8 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=4 pr=1 pw=0 time=2154 us cost=2 size=84 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID WF_SYSTEMS (cr=2 pr=0 pw=0 time=1186 us cost=1 size=33 card=1) 1 1 1 INDEX UNIQUE SCAN WF_SYSTEMS_U2 (cr=1 pr=0 pw=0 time=1152 us cost=0 size=0 card=1)(object id 166707) 1 1 1 TABLE ACCESS BY INDEX ROWID WF_AGENTS (cr=2 pr=0 pw=0 time=950 us cost=1 size=51 card=1) 1 1 1 INDEX UNIQUE SCAN WF_AGENTS_U2 (cr=1 pr=0 pw=0 time=914 us cost=0 size=0 card=1)(object id 166643) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: 8w57t3xaxs89k Plan Hash: 3712617803 SELECT NAME, VERSION FROM FND_CACHE_VERSIONS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 22 0.00 0.00 0 0 0 0 Fetch 22 0.00 0.00 0 22 0 176 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 45 0.00 0.00 0 22 0 176 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 2) ******************************************************************************** SQL ID: afmkwyhjj2ygy Plan Hash: 3085211511 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 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 2 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 10 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=10 pr=2 pw=0 time=3949 us cost=5 size=192 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=288 us cost=4 size=172 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=207 us cost=3 size=144 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=155 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=74 us cost=1 size=419328 card=14976) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=47 us cost=0 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_USER (cr=3 pr=2 pw=0 time=3637 us cost=1 size=899200 card=44960) 1 1 1 INDEX UNIQUE SCAN FND_USER_U1 (cr=2 pr=1 pw=0 time=1945 us cost=0 size=0 card=1)(object id 33427) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: fh7xtfp2uknqx Plan Hash: 0 begin fnd_file_private.open (:l, :o); end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 utl_file I/O 8 0.00 0.00 ******************************************************************************** SQL ID: dhk9at840tzp8 Plan Hash: 0 begin :v1 := FND_PROFILE.bumpCacheVersion_RF(:v2, :v3); end; 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 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: cb21bacyh3c7d Plan Hash: 3488560417 select metadata from kopm$ where name='DB_FDO' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID KOPM$ (cr=2 pr=2 pw=0 time=3325 us cost=1 size=108 card=1) 1 1 1 INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=1 pw=0 time=1611 us cost=0 size=0 card=1)(object id 287) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: bkaaqaa5aj3gf Plan Hash: 2797573680 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 2 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 6 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=6 pr=2 pw=0 time=3223 us cost=3 size=138 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=147 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U3 (cr=1 pr=0 pw=0 time=111 us cost=0 size=0 card=1)(object id 32806) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_NEW_MESSAGES (cr=4 pr=2 pw=0 time=3060 us cost=2 size=128 card=1) 1 1 1 INDEX UNIQUE SCAN FND_NEW_MESSAGES_PK (cr=3 pr=1 pw=0 time=1647 us cost=1 size=0 card=1)(object id 33198) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: 3nt7qb4xt8kbr Plan Hash: 1546270724 SELECT 'TRACE_USER_DETAILS: TIMESTAMP=04-MAR-14:08:57:32: USER_NAME= NISHANT_RANJAN: CONC_REQUEST_ID=282674203: OLTP_OPT_MODE= : CONC_OPT_MODE= : CONC_PROG_EXE=ALECDC: CONC_PROG_NAME=Check Periodic Alert: RESPONSIBILITY= EMR Alert Manager: APPL_NAME=ALR' FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 FAST DUAL (cr=0 pr=0 pw=0 time=9 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 2qa192hnrrk40 Plan Hash: 0 begin fnd_file_private.close; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ utl_file I/O 12 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.03 0.03 ******************************************************************************** SQL ID: a4gss3ajbyfzr Plan Hash: 515703603 SELECT R.RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL R WHERE R.RESPONSIBILITY_ID = :B2 AND R.APPLICATION_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 2 10 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 2 10 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: bks9ynz58sujr Plan Hash: 131691815 SELECT GUID, NAME, TYPE, STATUS, GENERATE_FUNCTION, JAVA_GENERATE_FUNC, LICENSED_FLAG FROM WF_EVENTS WHERE NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID WF_EVENTS (cr=3 pr=2 pw=0 time=2800 us cost=2 size=103 card=1) 1 1 1 INDEX UNIQUE SCAN WF_EVENTS_U2 (cr=2 pr=1 pw=0 time=1506 us cost=1 size=0 card=1)(object id 166646) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** SQL ID: 47r1y8yn34jmj Plan Hash: 3213098354 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 1 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 1 4 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID COL$ (cr=1 pr=1 pw=0 time=1785 us cost=1 size=15 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** SQL ID: 9w141c6p8f5gu Plan Hash: 0 declare alt_dummy1 boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, alt_dummy1);end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SQL ID: 2px9nkqfdvrtd Plan Hash: 3905985053 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 17 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 17 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=17 pr=0 pw=0 time=1388 us) 2 2 2 NESTED LOOPS (cr=15 pr=0 pw=0 time=1023 us cost=10 size=180 card=1) 1 1 1 NESTED LOOPS (cr=12 pr=0 pw=0 time=982 us cost=7 size=121 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=221 us cost=4 size=62 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=148 us cost=3 size=50 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=102 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=61 us cost=1 size=179712 card=14976) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=35 us cost=0 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=5 pr=0 pw=0 time=751 us cost=3 size=59 card=1) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=173 us cost=2 size=0 card=1)(object id 14622584) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=86 us cost=2 size=0 card=1)(object id 14622584) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=2 pr=0 pw=0 time=266 us cost=3 size=59 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.01 0.01 ******************************************************************************** SQL ID: 88maya168wkas Plan Hash: 1884197401 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 0.00 0 0 0 0 Execute 1 0.01 0.00 0 4 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 4 2 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONCURRENT_REQUESTS (cr=9 pr=0 pw=0 time=1337 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=77 us cost=3 size=32 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=58 us cost=2 size=0 card=1)(object id 34547) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: d3tnha97j45gq Plan Hash: 0 begin Fnd_Concurrent.Set_Preferred_RBS; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 14ys3d7nmvxbv Plan Hash: 0 ALTER SESSION SET SQL_TRACE = TRUE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: c4wtbv2xcmq78 Plan Hash: 0 begin fnd_file_private.logfile_get(:s, :b); end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 utl_file I/O 1 0.00 0.00 ******************************************************************************** SQL ID: fxr5kcfdxsjcj Plan Hash: 1473858840 UPDATE APPWORX_OA_REQUESTS SET REQUEST_ID =REQUEST_ID WHERE REQUEST_ID = :B1 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 14 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 14 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE APPWORX_OA_REQUESTS (cr=14 pr=0 pw=0 time=326 us) 0 0 0 TABLE ACCESS FULL APPWORX_OA_REQUESTS (cr=14 pr=0 pw=0 time=322 us cost=10 size=7 card=1) ******************************************************************************** SQL ID: d17m78gkh6p93 Plan Hash: 2775352469 SELECT Q.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_REQUESTS R, FND_CONCURRENT_PROCESSES P, FND_CONCURRENT_QUEUES Q WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND R.CONTROLLING_MANAGER = P.CONCURRENT_PROCESS_ID AND Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID AND Q.APPLICATION_ID = P.QUEUE_APPLICATION_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 9 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 9 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=9 pr=0 pw=0 time=887 us cost=5 size=35 card=1) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=589 us cost=4 size=26 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=500 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=428 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES (cr=3 pr=0 pw=0 time=82 us cost=1 size=117832 card=9064) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (cr=2 pr=0 pw=0 time=55 us cost=0 size=0 card=1)(object id 33070) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_QUEUES (cr=2 pr=0 pw=0 time=266 us cost=1 size=621 card=69) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_QUEUES_U1 (cr=1 pr=0 pw=0 time=40 us cost=0 size=0 card=1)(object id 33259) ******************************************************************************** SQL ID: 1hz00txs5dyw2 Plan Hash: 2774165112 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 5 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES (cr=5 pr=0 pw=0 time=809 us cost=4 size=59 card=1) 2 2 2 INDEX RANGE SCAN FND_LOOKUP_VALUES_X99 (cr=3 pr=0 pw=0 time=180 us cost=3 size=0 card=1)(object id 14622584) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 2pc7ccuj1qq7h Plan Hash: 4290205421 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 4 3 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 3 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FOR UPDATE (cr=4 pr=0 pw=0 time=521 us) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=182 us cost=3 size=131 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=122 us cost=2 size=0 card=1)(object id 34547) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.01 0.01 ******************************************************************************** SQL ID: gryz5jc5wzzh4 Plan Hash: 543232615 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 8 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 8 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 MERGE JOIN CARTESIAN (cr=8 pr=0 pw=0 time=636 us cost=5 size=52 card=1) 1 1 1 NESTED LOOPS (cr=5 pr=0 pw=0 time=416 us cost=3 size=33 card=1) 1 1 1 INDEX UNIQUE SCAN HR_ORGANIZATION_UNITS_PK (cr=2 pr=0 pw=0 time=127 us cost=1 size=4 card=1)(object id 32563590) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=284 us cost=2 size=29 card=1) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_X99 (cr=2 pr=0 pw=0 time=181 us cost=1 size=0 card=1)(object id 14622722) 1 1 1 BUFFER SORT (cr=3 pr=0 pw=0 time=200 us cost=3 size=19 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID HR_ORGANIZATION_INFORMATION (cr=3 pr=0 pw=0 time=115 us cost=2 size=19 card=1) 1 1 1 INDEX RANGE SCAN HR_ORGANIZATION_INFORMATIO_FK2 (cr=2 pr=0 pw=0 time=90 us cost=1 size=0 card=1)(object id 3031442) ******************************************************************************** SQL ID: aw7fu9a9bdyus Plan Hash: 510263741 SELECT * FROM PER_SECURITY_PROFILES WHERE SECURITY_PROFILE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 5 0.01 0.00 0 0 0 0 Fetch 5 0.00 0.00 0 10 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 10 0 5 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 2 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID PER_SECURITY_PROFILES (cr=2 pr=0 pw=0 time=73 us cost=1 size=109 card=1) 1 1 1 INDEX UNIQUE SCAN PER_SECURITY_PROFILES_PK (cr=1 pr=0 pw=0 time=42 us cost=0 size=0 card=1)(object id 44492) ******************************************************************************** SQL ID: 2xyb5d6xg9srh Plan Hash: 1783251294 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 7 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 0 14 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.00 0 14 0 4 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=86 us cost=2 size=13 card=1) ******************************************************************************** SQL ID: 8ggw94h7mvxd7 Plan Hash: 0 COMMIT 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 1 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 1 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 2tyrw6s0jvap7 Plan Hash: 1934133821 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=205 us cost=4 size=93 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=136 us cost=3 size=81 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=92 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=48 us cost=1 size=179712 card=14976) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=31 us cost=0 size=0 card=1)(object id 33183) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 893s4vm787w7a Plan Hash: 2531403236 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 13 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 13 1 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 UPDATE FND_CONC_PROG_ONSITE_INFO (cr=13 pr=0 pw=0 time=510 us) 1 1 1 NESTED LOOPS (cr=6 pr=0 pw=0 time=252 us cost=4 size=82 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=206 us cost=3 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=98 us cost=2 size=0 card=1)(object id 34547) 1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=0 pw=0 time=38 us cost=0 size=974415 card=14991)(object id 194616) 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=67 us cost=4 size=75 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=41 us cost=3 size=35 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=20 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PROG_ONSITE_INFO (cr=3 pr=0 pw=0 time=18 us cost=1 size=599640 card=14991) 1 1 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (cr=2 pr=0 pw=0 time=9 us cost=0 size=0 card=1)(object id 194616) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: g90k5xtu46wmp Plan Hash: 0 begin fnd_file.close; end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: gvrx5h0ynb5f7 Plan Hash: 0 begin :release := fnd_release.major_version;end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 2t1mcgnmdffdw Plan Hash: 1917149222 SELECT TO_CHAR(SYSDATE,'YYYY-MM-DD HH24:MI:SS') FROM DUAL WHERE ROWNUM=1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 COUNT STOPKEY (cr=0 pr=0 pw=0 time=30 us) 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=7 us cost=2 size=0 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 924k0uck6anwh Plan Hash: 0 begin fnd_file_private.outfile_get(:s, :b); end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 utl_file I/O 1 0.00 0.00 ******************************************************************************** SQL ID: 19d9ju4hz45dr Plan Hash: 1934133821 SELECT P.ROLLBACK_SEGMENT FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_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 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 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=525 us cost=4 size=29 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=434 us cost=3 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=392 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=60 us cost=1 size=179712 card=14976) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=40 us cost=0 size=0 card=1)(object id 33183) ******************************************************************************** SQL ID: f2tzfzy3qw2bp Plan Hash: 1511344495 SELECT DECODE(READ_ONLY_FLAG,'U', 'Y' ,'M', 'Y' ,'K', 'Y' ,'N') SCHEMA_MODE, DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1),' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1, 10)) FROM FND_ORACLE_USERID WHERE ORACLE_USERNAME = USER call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 4 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 4 0 2 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID (cr=2 pr=0 pw=0 time=142 us cost=1 size=7 card=1) 1 1 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U2 (cr=1 pr=0 pw=0 time=80 us cost=0 size=0 card=1)(object id 22604) ******************************************************************************** SQL ID: 1d3vut2wf2mhv Plan Hash: 173711545 SELECT ENABLE_ROUTINE, DISABLE_ROUTINE, DRO.DEBUG_OPTION_NAME, DRO.DEBUG_OPTION_VALUE, DR.DEBUG_RULE_ID, REPEATION_COUNTER, START_TIME, END_TIME, USER_ID, RESPONSIBILITY_ID, RESP_APPL_ID, COMPONENT_TYPE, COMPONENT_NAME, COMPONENT_ID, COMPONENT_APPL_ID, TRACE_FILE_ROUTINE, TRACE_FILE_NODE, COMMENTS, NVL(REQUEST_ID,0) REQID FROM FND_DEBUG_OPTIONS DO, FND_DEBUG_RULES DR, FND_DEBUG_OPTION_VALUES DOV, FND_DEBUG_RULE_OPTIONS DRO WHERE ( DR.USER_ID = :B8 OR (DR.RESPONSIBILITY_ID = :B7 AND DR.RESP_APPL_ID = :B6 ) OR (DR.USER_ID IS NULL AND DR.RESPONSIBILITY_ID IS NULL) ) AND (( SYSDATE >= DR.START_TIME AND SYSDATE <= DR.END_TIME) OR DR.REPEATION_COUNTER > 0 ) AND ( DR.COMPONENT_NAME = :B5 OR (DR.COMPONENT_ID = :B4 AND DR.COMPONENT_APPL_ID = :B3 ) ) AND DR.COMPONENT_TYPE = :B2 AND DRO.DEBUG_OPTION_NAME = DOV.DEBUG_OPTION_NAME AND DRO.DEBUG_OPTION_VALUE = DOV.DEBUG_OPTION_VALUE AND DRO.DEBUG_OPTION_NAME = DO.DEBUG_OPTION_NAME AND DO.TYPE = 'D' AND DO.ENABLED_FLAG = 'Y' AND ((DR.REQUEST_ID IS NOT NULL AND :B1 = DR.REQUEST_ID) OR (DR.REQUEST_ID IS NULL) ) AND DR.DEBUG_RULE_ID = DRO.DEBUG_RULE_ID AND DR.DEBUG_RULE_ID=(SELECT MIN(DEBUG_RULE_ID) FROM FND_DEBUG_RULES IDR WHERE (IDR.USER_ID = :B8 OR (IDR.RESPONSIBILITY_ID = :B7 AND IDR.RESP_APPL_ID = :B6 ) OR (IDR.USER_ID IS NULL AND IDR.RESPONSIBILITY_ID IS NULL) ) AND (( SYSDATE >= IDR.START_TIME AND SYSDATE <= IDR.END_TIME) OR IDR.REPEATION_COUNTER > 0 ) AND ( IDR.COMPONENT_NAME = :B5 OR (IDR.COMPONENT_ID = :B4 AND IDR.COMPONENT_APPL_ID = :B3 ) ) AND IDR.COMPONENT_TYPE = :B2 AND ((IDR.REQUEST_ID IS NOT NULL AND :B1 = IDR.REQUEST_ID) OR (IDR.REQUEST_ID IS NULL) ) ) ORDER BY REQID DESC, DR.CREATION_DATE, DR.DEBUG_RULE_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 SORT ORDER BY (cr=1 pr=0 pw=0 time=242 us cost=9 size=219 card=1) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=159 us) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=155 us cost=6 size=219 card=1) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=151 us cost=5 size=115 card=1) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=148 us cost=4 size=101 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULES (cr=1 pr=0 pw=0 time=144 us cost=2 size=76 card=1) 0 0 0 INDEX RANGE SCAN FND_DEBUG_RULES_N3 (cr=1 pr=0 pw=0 time=113 us cost=1 size=0 card=1)(object id 2250898) 0 0 0 SORT AGGREGATE (cr=0 pr=0 pw=0 time=0 us) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULES (cr=0 pr=0 pw=0 time=0 us cost=2 size=76 card=1) 0 0 0 INDEX RANGE SCAN FND_DEBUG_RULES_N3 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 2250898) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_RULE_OPTIONS (cr=0 pr=0 pw=0 time=0 us cost=2 size=25 card=1) 0 0 0 INDEX RANGE SCAN FND_DEBUG_RULE_OPTIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=1 size=0 card=1)(object id 2321837) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_OPTIONS (cr=0 pr=0 pw=0 time=0 us cost=1 size=14 card=1) 0 0 0 INDEX UNIQUE SCAN FND_DEBUG_OPTIONS_U1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 2250886) 0 0 0 INDEX UNIQUE SCAN FND_DEBUG_OPTION_VALUES_U1 (cr=0 pr=0 pw=0 time=0 us cost=0 size=0 card=1)(object id 2250890) 0 0 0 TABLE ACCESS BY INDEX ROWID FND_DEBUG_OPTION_VALUES (cr=0 pr=0 pw=0 time=0 us cost=1 size=104 card=1) ******************************************************************************** SQL ID: 9jzpjbrt45jgm Plan Hash: 537836892 SELECT COUNT(*) FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID = :B1 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=3 pr=0 pw=0 time=330 us) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=260 us cost=2 size=7 card=1)(object id 34547) ******************************************************************************** SQL ID: 2n11d838tu3s2 Plan Hash: 1567616234 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 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: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID FND_LOG_TRANSACTION_CONTEXT (cr=2 pr=0 pw=0 time=151 us cost=2 size=21 card=1) 0 0 0 INDEX RANGE SCAN FND_LOG_TRANSACTION_CONTEXT_N2 (cr=2 pr=0 pw=0 time=131 us cost=1 size=0 card=1)(object id 302509) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 0p5cpqqwhdyr7 Plan Hash: 134341859 SELECT SUBSTR(REPLACE(USER_CONCURRENT_PROGRAM_NAME,'''',' '),1,240), SUBSTR(CONCURRENT_PROGRAM_NAME,1,30) FROM FND_CONCURRENT_PROGRAMS_VL WHERE CONCURRENT_PROGRAM_ID = :B1 AND APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=339 us cost=4 size=77 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=240 us cost=2 size=26 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=190 us cost=1 size=0 card=1)(object id 33183) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL (cr=4 pr=0 pw=0 time=90 us cost=2 size=51 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1 (cr=3 pr=0 pw=0 time=63 us cost=1 size=0 card=1)(object id 33634) ******************************************************************************** SQL ID: 90kv3kupxjg3a Plan Hash: 0 lock table FND_CONCURRENT_REQUESTS in share update mode call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: d1fv0kpyztkkz Plan Hash: 1133168885 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=137 us cost=3 size=13 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=97 us cost=2 size=0 card=1)(object id 34547) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: c6ukqtfzn8njb Plan Hash: 3468989253 SELECT NAME FROM WF_SYSTEMS WHERE GUID = :B1 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: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID WF_SYSTEMS (cr=2 pr=0 pw=0 time=68 us cost=1 size=33 card=1) 1 1 1 INDEX UNIQUE SCAN WF_SYSTEMS_U1 (cr=1 pr=0 pw=0 time=36 us cost=0 size=0 card=1)(object id 166705) ******************************************************************************** SQL ID: gy26a7tjan9jk Plan Hash: 1934133821 SELECT P.RESOURCE_CONSUMER_GROUP FROM FND_CONCURRENT_PROGRAMS P, FND_CONCURRENT_REQUESTS R WHERE R.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 7 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=7 pr=0 pw=0 time=189 us cost=4 size=44 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=97 us cost=3 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=85 us cost=2 size=0 card=1)(object id 34547) 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS (cr=3 pr=0 pw=0 time=83 us cost=1 size=404352 card=14976) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (cr=2 pr=0 pw=0 time=56 us cost=0 size=0 card=1)(object id 33183) ******************************************************************************** SQL ID: 7ubzmv61bvaz6 Plan Hash: 1546270724 SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') FROM SYS.DUAL 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 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=4 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: ffuf485g4tj0s Plan Hash: 1396620114 select count(*) from resource_consumer_group$ where name = :1 and internal_use = 1 and status = 'ACTIVE' 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 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=2 pr=0 pw=0 time=215 us) 0 0 0 TABLE ACCESS FULL RESOURCE_CONSUMER_GROUP$ (cr=2 pr=0 pw=0 time=187 us cost=2 size=27 card=1) ******************************************************************************** SQL ID: 6fpgjh9367r2n Plan Hash: 1133168885 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=99 us cost=3 size=33 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=23 us cost=2 size=0 card=1)(object id 34547) ******************************************************************************** SQL ID: 7nbz42z807azn Plan Hash: 0 SAVEPOINT WF_DISPATCH_SAVEPOINT 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 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 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: at3qkkaxrbrn5 Plan Hash: 3162025953 DELETE FROM FND_DEBUG_RULES WHERE (START_TIME IS NOT NULL AND END_TIME < SYSDATE) OR (REPEATION_COUNTER = 0) 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 4 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 DELETE FND_DEBUG_RULES (cr=4 pr=0 pw=0 time=59 us) 0 0 0 TABLE ACCESS FULL FND_DEBUG_RULES (cr=4 pr=0 pw=0 time=56 us cost=4 size=43 card=1) ******************************************************************************** SQL ID: g0621q4gsac3f Plan Hash: 1546270724 SELECT TO_CHAR(SYSDATE,'DD-MON-YY:HH24:MI:SS') FROM SYS.DUAL 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 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=4 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 5as61q63aqmts Plan Hash: 3838274141 SELECT A.APPLICATION_SHORT_NAME FROM FND_APPLICATION A WHERE A.APPLICATION_ID = :B1 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 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_APPLICATION (cr=2 pr=0 pw=0 time=37 us cost=1 size=10 card=1) 1 1 1 INDEX UNIQUE SCAN FND_APPLICATION_U1 (cr=1 pr=0 pw=0 time=18 us cost=0 size=0 card=1)(object id 32802) ******************************************************************************** SQL ID: 8gxrsat9m0dc2 Plan Hash: 0 alter session set NLS_TERRITORY = "AMERICA" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 404g2bvgmf03m Plan Hash: 0 alter session set NLS_LANGUAGE = "AMERICAN" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 39918s1sdb8b1 Plan Hash: 1133168885 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=44 us cost=3 size=11 card=1) 1 1 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=29 us cost=2 size=0 card=1)(object id 34547) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: g4cn8fyry077m Plan Hash: 1546270724 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 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: 1ad1ww0b5p4ky Plan Hash: 1546270724 SELECT DECODE(:B1 , 'P', 'REPORTS', 'I', 'PLSQL_CP', 'J', 'JAVA_STORED_CP', 'K', 'JAVA_CP', 'Q', 'SQLPLUS_CP', 'E', 'PERL_CP', 'S', 'SUBROUTINE_CP', 'A', 'SPAWNED_CP', 'H', 'HOST_CP', 'L', 'LOADER_CP', 'NOT_SUPPORTED') FROM DUAL 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 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us cost=2 size=0 card=1) ******************************************************************************** SQL ID: at2h5x34yj2c4 Plan Hash: 1546270724 SELECT NLS_CHARSET_ID(:B1 ) FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 1c1u6gc725u2a Plan Hash: 2325295079 SELECT U.USER_NAME, NVL(U.EMPLOYEE_ID, :B2 ) EMPLOYEE_ID, NVL(U.CUSTOMER_ID, :B2 ) CUSTOMER_ID, NVL(U.SUPPLIER_ID, :B2 ) SUPPLIER_ID, NVL(U.PERSON_PARTY_ID, :B2 ) PERSON_PARTY_ID FROM FND_USER U WHERE U.USER_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 98j69vs3ymzjv Plan Hash: 1846972739 SELECT DECODE(:B2 , 'UTF8', FL.UTF8_DATE_LANGUAGE, 'AL32UTF8', FL.UTF8_DATE_LANGUAGE, FL.LOCAL_DATE_LANGUAGE ) DATA_RTN FROM FND_LANGUAGES FL WHERE FL.NLS_LANGUAGE = :B1 AND FL.INSTALLED_FLAG <>'D' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: bvyqm6268u2as Plan Hash: 2335689044 SELECT NODE_NAME FROM FND_NODES WHERE NODE_ID = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: cjd5ryf2wfqs1 Plan Hash: 0 alter session set NLS_DATE_FORMAT = "DD-MON-RR" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: g1bvmkr52kdxp Plan Hash: 0 alter session set NLS_SORT = "BINARY" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: f2f0ypsk4x8n1 Plan Hash: 0 alter session set NLS_NUMERIC_CHARACTERS = ".," call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 2fgjgudmx0yac Plan Hash: 0 alter session set NLS_DATE_LANGUAGE = "AMERICAN" call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SQL ID: 595qpkr7b4a4t Plan Hash: 1546270724 SELECT NLS_CHARSET_NAME(:B1 ) FROM SYS.DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 52 0.33 0.28 0 0 0 0 Execute 83 0.37 0.94 62 66 95 38 Fetch 70 7549.46 12030.08 1033065 1477035 28 387 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 205 7550.16 12031.32 1033127 1477101 123 425 Misses in library cache during parse: 25 Misses in library cache during execute: 20 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 241 0.00 0.00 SQL*Net message from client 241 0.03 0.27 Disk file operations I/O 85 0.00 0.00 db file sequential read 1029932 1.49 3713.15 db file scattered read 295 0.00 0.03 SQL*Net more data to client 10 0.00 0.00 log file sync 11 0.00 0.02 SQL*Net more data from client 1 0.00 0.00 CSS initialization 1 0.03 0.03 CSS operation: query 6 0.00 0.00 CSS operation: action 1 0.01 0.01 direct path write temp 490701 0.01 51.36 direct path read temp 68 0.00 0.00 latch free 1 0.00 0.00 latch: object queue header operation 1 0.00 0.00 control file sequential read 7 0.00 0.00 SQL*Net break/reset to client 2 0.00 0.00 utl_file I/O 22 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 149 0.07 0.08 0 0 0 0 Execute 550 0.19 0.53 41 51 82 18 Fetch 939 0.30 0.97 300 2138 0 869 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1638 0.56 1.59 341 2189 82 887 Misses in library cache during parse: 19 Misses in library cache during execute: 14 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 31 0.00 0.00 db file sequential read 341 0.04 1.03 134 user SQL statements in session. 39 internal SQL statements in session. 173 SQL statements in session. 0 statements EXPLAINed in this session. ******************************************************************************** Trace file: betsyu1_ora_8176_ANONYMOUS.trc Trace file compatibility: 11.1.0.7 Sort options: prsela exeela fchela 1 session in tracefile. 134 user SQL statements in trace file. 39 internal SQL statements in trace file. 173 SQL statements in trace file. 143 unique SQL statements in trace file. 1549776 lines in trace file. 12033 elapsed seconds in trace file.