TKPROF: Release 9.2.0.8.0 - Production on Thu Jun 21 04:54:40 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Trace file: eaj_alert_4000.trc Sort options: fchela exeela ******************************************************************************** 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 ******************************************************************************** SELECT eccs.ORG_ID , eccs.CUSTOMER_NUMBER , eccs.CUSTOMER_NAME , eccs.CR_LIMIT_CURR_CODE , eccs.CREDIT_LIMIT , eccs.FORECAST_NDD , eccs.OPEN_RECEIVABLES , eccs.OPEN_SALES_ORDERS , round(((SUM(eccs.OPEN_RECEIVABLES+eccs.OPEN_SALES_ORDERS)) / DECODE(eccs.CREDIT_LIMIT,0,1,eccs.CREDIT_LIMIT) )*100,2) , SUM(eccs.OPEN_RECEIVABLES+eccs.OPEN_SALES_ORDERS) FROM ( SELECT 98 org_id, rc.customer_number, rc.customer_name, cpa.currency_code cr_limit_curr_code, cpa.overall_credit_limit credit_limit, rc.customer_id, NVL((SELECT SUM(NVL(apt_ndd.amount_due_remaining,0)) FROM AR_PAYMENT_SCHEDULES_ALL apt_ndd WHERE 1=1 AND apt_ndd.customer_id = rc.customer_id AND apt_ndd.due_date = (SELECT MIN(apt_ndd2.due_date) FROM AR_PAYMENT_SCHEDULES_ALL apt_ndd2 WHERE 1=1 AND NVL(apt_ndd2.amount_due_remaining,0) <> 0 AND apt_ndd2.due_date > SYSDATE AND apt_ndd2.customer_id = rc.customer_id AND apt_ndd2.org_id = 98) ),0)Forecast_ndd, NVL((SELECT SUM(NVL(ROUND(aps.amount_due_remaining,2),0)) FROM AR_PAYMENT_SCHEDULES_ALL aps WHERE aps.customer_id = rc.customer_id AND aps.org_id = 98 ),0) Open_Receivables , NVL((SELECT SUM(ROUND(ool.pricing_quantity,2) * ROUND(ool.unit_selling_price,2)) FROM OE_ORDER_LINES_ALL ool, OE_ORDER_HEADERS_ALL ooh WHERE ooh.sold_to_org_id = rc.customer_id AND ool.header_id = ooh.header_id AND ooh.order_category_code = 'ORDER' AND ool.flow_status_code IN ('PICKED','AWAITING_SHIPPING') AND ool.org_id = 98 ),0) Open_Sales_Orders FROM apps.RA_CUSTOMERS rc, apps.HZ_CUST_PROFILE_AMTS cpa WHERE 1 = 1 AND cpa.cust_account_id = rc.customer_id AND cpa.currency_code = 'JPY' AND rc.status = 'A' ) eccs WHERE eccs.ORG_ID = 98 GROUP BY eccs.ORG_ID , eccs.CUSTOMER_NUMBER , eccs.CUSTOMER_NAME , eccs.CR_LIMIT_CURR_CODE , eccs.CREDIT_LIMIT , eccs.FORECAST_NDD , eccs.OPEN_RECEIVABLES , eccs.OPEN_SALES_ORDERS having ((SUM(eccs.OPEN_RECEIVABLES+eccs.OPEN_SALES_ORDERS)) / DECODE(eccs.CREDIT_LIMIT,0,1,eccs.CREDIT_LIMIT) )*100 between 70 and 100 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 42.41 212.66 165726 2638781 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 42.41 212.66 165726 2638781 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 2 FILTER 58 SORT GROUP BY 58 HASH JOIN 58 HASH JOIN 315 TABLE ACCESS FULL HZ_CUST_PROFILE_AMTS 1640 TABLE ACCESS FULL HZ_CUST_ACCOUNTS 13359 TABLE ACCESS FULL HZ_PARTIES 58 SORT AGGREGATE 969148 TABLE ACCESS BY INDEX ROWID AR_PAYMENT_SCHEDULES_ALL (Orphan Entry) 969148 INDEX RANGE SCAN AR_PAYMENT_SCHEDULES_N6 (object id 28914)(Orphan Entry) 58 SORT AGGREGATE 10967 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (Orphan Entry) 1622936 NESTED LOOPS (Orphan Entry) 605709 TABLE ACCESS BY INDEX ROWID OE_ORDER_HEADERS_ALL (Orphan Entry) 615126 INDEX RANGE SCAN OE_ORDER_HEADERS_N2 (object id 41421)(Orphan Entry) 1017169 INDEX RANGE SCAN OE_ORDER_LINES_N1 (object id 41462)(Orphan Entry) 58 SORT AGGREGATE 969148 TABLE ACCESS BY INDEX ROWID AR_PAYMENT_SCHEDULES_ALL (Orphan Entry) 969148 INDEX RANGE SCAN AR_PAYMENT_SCHEDULES_N6 (object id 28914)(Orphan Entry) 58 SORT AGGREGATE 10967 TABLE ACCESS BY INDEX ROWID OE_ORDER_LINES_ALL (Orphan Entry) 1622936 NESTED LOOPS (Orphan Entry) 605709 TABLE ACCESS BY INDEX ROWID OE_ORDER_HEADERS_ALL (Orphan Entry) 615126 INDEX RANGE SCAN OE_ORDER_HEADERS_N2 (object id 41421)(Orphan Entry) 1017169 INDEX RANGE SCAN OE_ORDER_LINES_N1 (object id 41462)(Orphan Entry) ******************************************************************************** INSERT INTO ALR_OUTPUT_HISTORY (APPLICATION_ID, NAME, CHECK_ID, ROW_NUMBER, DATA_TYPE, VALUE) VALUES (:0, :1, :2, :3, :4, :5) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 20 0.01 0.26 18 18 197 20 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 30 0.01 0.26 18 18 197 20 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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.01 0.00 0 0 0 0 Execute 1 0.00 0.17 17 1 17 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.17 17 1 17 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 1 0.00 0.12 11 1 11 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.12 11 1 11 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** SELECT vh.check_id, o.row_number, o.name, o.value, NVL(vh.action_level, -1) FROM (SELECT distinct h.check_id, h.application_id, h.action_level FROM ALR_ACTION_HISTORY h WHERE h.application_id = :0 AND h.action_set_id = :1 ) vh, ALR_OUTPUT_HISTORY o WHERE vh.check_id = o.check_id AND vh.application_id = o.application_id AND o.name in ('ORG_ID', 'CUSTOMER_NUMBER','CUSTOMER_NAME','CR_LMT_CURR_CODE','CREDIT_LIMIT', 'FORECAST_NDD','OPEN_REC','OPEN_ORD','CR_LMT_UTLZ_PER','CR_LMT_UTLZ') ORDER BY 5 desc, vh.check_id, o.row_number, o.name, o.value 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.08 29 229 0 50 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.08 29 229 0 50 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 50 SORT ORDER BY 50 VIEW 50 SORT UNIQUE 50 TABLE ACCESS BY INDEX ROWID ALR_OUTPUT_HISTORY 56 NESTED LOOPS 5 TABLE ACCESS BY INDEX ROWID ALR_ACTION_HISTORY 5 INDEX RANGE SCAN ALR_ACTION_HISTORY_N1 (object id 27496) 50 INLIST ITERATOR 50 INDEX RANGE SCAN ALR_OUTPUT_HISTORY_N1 (object id 27675) ******************************************************************************** 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 2 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.07 14 20 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.07 14 20 0 5 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID OBJ#(18) 2 INDEX RANGE SCAN OBJ#(34) (object id 34) ******************************************************************************** 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 7 0.00 0.00 0 0 0 0 Fetch 7 0.01 0.06 6 25 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.01 0.06 6 25 0 4 Misses in library cache during parse: 0 Optimizer goal: RULE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** begin WF_EVENT_OJMSTEXT_QH.enqueue(:v1, :v2); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.01 0.05 13 17 84 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.06 13 17 84 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 2) ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 25 0.00 0.05 2 52 0 24 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 27 0.00 0.05 2 52 0 24 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 24 TABLE ACCESS BY INDEX ROWID ALR_PROFILE_OPTIONS 24 INDEX FULL SCAN ALR_PROFILE_OPTIONS_U1 (object id 27735) ******************************************************************************** SELECT TAG FROM FND_LOOKUP_VALUES LV, V$NLS_PARAMETERS NP WHERE LV.LOOKUP_TYPE = 'FND_ISO_CHARACTER_SET_MAP' AND LV.LOOKUP_CODE = NP.VALUE AND NP.PARAMETER = 'NLS_CHARACTERSET' AND LV.LANGUAGE='US' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.05 9 9 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.06 9 9 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 3 NESTED LOOPS 1 FIXED TABLE FULL X$NLS_PARAMETERS 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 34010) ******************************************************************************** INSERT INTO ALR_ACTION_DATA ( APPLICATION_ID, ACTION_HISTORY_ID, CHECK_ID, ROW_NUMBER, DUPLICATE_FLAG) VALUES ( :0, :1, :2, :3, :4) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.05 2 2 10 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.05 2 2 10 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** insert into APPLSYS.WF_CONTROL (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) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, 0, :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 2 0.00 0.04 7 7 8 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.04 7 7 8 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 3) ******************************************************************************** select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.04 7 9 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.04 7 9 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 SORT ORDER BY 2 NESTED LOOPS OUTER 2 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ 2 INDEX RANGE SCAN I_DEPENDENCY1 (object id 116) 1 TABLE ACCESS BY INDEX ROWID OBJ$ 1 INDEX UNIQUE SCAN I_OBJ1 (object id 33) ******************************************************************************** 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 2 0.00 0.00 0 0 0 0 Fetch 15 0.00 0.03 4 10 0 13 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 19 0.00 0.03 4 10 0 13 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.03 5 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.03 5 6 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ#(58) 1 INDEX UNIQUE SCAN OBJ#(98) (object id 98) ******************************************************************************** (select sub.guid sub_guid, sub.rule_function rule_func, sub.source_type source_type, nvl(sub.phase,0) phase, sub.rule_data rule_data, sub.priority priority from wf_event_subscriptions sub, wf_events evt where sub.system_guid = :b4 and sub.status = 'ENABLED' and sub.licensed_flag = 'Y' and sub.source_type = :b3 and ((sub.source_agent_guid is NOT NULL AND sub.source_agent_guid = nvl(:b2, sub.source_agent_guid)) OR sub.source_agent_guid is NULL) and sub.event_filter_guid = evt.guid and evt.name in (:b1,'oracle.apps.wf.event.any') and evt.type = 'EVENT' and evt.status = 'ENABLED' and evt.licensed_flag = 'Y') union all (select sub.guid sub_guid, sub.rule_function rule_func, sub.source_type source_type, nvl(sub.phase,0) phase, sub.rule_data rule_data, sub.priority priority from wf_event_subscriptions sub, wf_event_groups egrp, wf_events grp, wf_events evt where sub.system_guid = :b4 and sub.status = 'ENABLED' and sub.licensed_flag = 'Y' and sub.source_type = :b3 and ((sub.source_agent_guid is NOT NULL AND sub.source_agent_guid = nvl(:b2, sub.source_agent_guid)) OR sub.source_agent_guid is NULL) and grp.guid = sub.event_filter_guid and grp.type = 'GROUP' and grp.status = 'ENABLED' and egrp.group_guid = grp.guid and egrp.member_guid = evt.guid and evt.name = :b1 and evt.type = 'EVENT' and evt.status = 'ENABLED' and evt.licensed_flag = 'Y') order by 4 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.03 21 42 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.00 0.03 21 42 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 SORT ORDER BY 2 UNION-ALL 0 TABLE ACCESS BY INDEX ROWID WF_EVENT_SUBSCRIPTIONS 8 NESTED LOOPS 4 INLIST ITERATOR 4 TABLE ACCESS BY INDEX ROWID WF_EVENTS 4 INDEX RANGE SCAN WF_EVENTS_U2 (object id 166407) 2 INDEX RANGE SCAN WF_EVENT_SUBSCRIPTIONS_N1 (object id 166413) 2 TABLE ACCESS BY INDEX ROWID WF_EVENT_SUBSCRIPTIONS 6 NESTED LOOPS 2 NESTED LOOPS 2 NESTED LOOPS 2 TABLE ACCESS BY INDEX ROWID WF_EVENTS 2 INDEX UNIQUE SCAN WF_EVENTS_U2 (object id 166407) 2 INDEX RANGE SCAN WF_EVENT_GROUPS_U1 (object id 166411) 2 TABLE ACCESS BY INDEX ROWID WF_EVENTS 2 INDEX UNIQUE SCAN WF_EVENTS_U1 (object id 166406) 2 INDEX RANGE SCAN WF_EVENT_SUBSCRIPTIONS_N1 (object id 166413) ******************************************************************************** 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.00 0.00 0 0 0 0 Fetch 1 0.00 0.03 6 25 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.03 6 25 0 10 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 10 SORT ORDER BY 10 NESTED LOOPS OUTER 10 TABLE ACCESS BY INDEX ROWID ALR_ALERT_OUTPUTS 10 INDEX RANGE SCAN ALR_ALERT_OUTPUTS_N1 (object id 27635) 10 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SET_OUTPUTS 10 INDEX UNIQUE SCAN ALR_ACTION_SET_OUTPUTS_U1 (object id 27590) ******************************************************************************** select order#,columns,types from access$ where d_obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.03 4 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.03 4 5 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID ACCESS$ 1 INDEX RANGE SCAN I_ACCESS1 (object id 118) ******************************************************************************** declare dummy boolean;begin fnd_profile.get_specific(:name, :userid, :respid, :applid, :val, dummy, :org_id,:server_id);end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 19 0.01 0.00 0 0 0 0 Execute 19 0.02 0.03 0 0 0 19 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 38 0.03 0.03 0 0 0 19 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.02 4 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.03 4 6 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select dimobj#, col# from dimattr$ where detailobj#=:1 union select dimobj#, col# from dimjoinkey$ where detailobj#=:1 union select dimobj#, col# from dimlevelkey$ where detailobj#=:1 order by 2, 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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 3 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 3 3 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT UNIQUE 0 UNION-ALL 0 TABLE ACCESS BY INDEX ROWID DIMATTR$ 0 INDEX RANGE SCAN I_DIMATTR$_2 (object id 344) 0 TABLE ACCESS BY INDEX ROWID DIMJOINKEY$ 0 INDEX RANGE SCAN I_DIMJOINKEY$_2 (object id 341) 0 TABLE ACCESS BY INDEX ROWID DIMLEVELKEY$ 0 INDEX RANGE SCAN I_DIMLEVELKEY$_2 (object id 338) ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.02 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.02 3 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SETS 1 INDEX RANGE SCAN ALR_ACTION_SETS_U2 (object id 27527) ******************************************************************************** INSERT INTO ALR_ACTION_HISTORY ( APPLICATION_ID, ACTION_HISTORY_ID, ACTION_ID, ACTION_LEVEL, LAST_UPDATE_DATE, CHECK_ID, ALERT_ID, ACTION_SET_ID, ACTION_SET_MEMBER_ID, MAXIMUM_SUMMARY_MESSAGE_WIDTH, COLUMN_WRAP_FLAG, ACTION_EXECUTED_FLAG, SUCCESS_FLAG, MESSAGE_HANDLE, NODE_HANDLE, VERSION_NUMBER) VALUES (:0, :1, DECODE(:2,-1,NULL,:3), :4, SYSDATE, :5, :6, :7, :8, DECODE(:9,-1, NULL,:10), :11, :12, :13, :14, :15, :15 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.02 1 2 14 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.02 1 2 14 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags, i.property, i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey, i.lblkkey, i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256), i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,spare2,spare6, decode(i.pctthres$,null, null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#, min(to_number(bitand(defer,4))) valid# from cdef$ where obj#= :1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.bo#= :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.01 0.02 4 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.02 4 7 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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 3 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.02 3 6 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER SEG$ 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (object id 9) ******************************************************************************** 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.00 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.00 0.01 3 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 UNION-ALL 1 NESTED LOOPS OUTER 1 TABLE ACCESS BY INDEX ROWID ALR_ACTIONS 2 INDEX RANGE SCAN ALR_ACTIONS_U1 (object id 27446) 0 TABLE ACCESS BY INDEX ROWID ALR_DISTRIBUTION_LISTS 0 INDEX RANGE SCAN ALR_DISTRIBUTION_LISTS_U1 (object id 27639) 0 FILTER 0 TABLE ACCESS BY INDEX ROWID ALR_LOOKUPS 0 INDEX RANGE SCAN ALR_LOOKUPS_U1 (object id 27646) ******************************************************************************** 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.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 2 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 2 4 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY 1 SORT UNIQUE 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID ALR_ALERT_INSTALLATIONS 1 INDEX RANGE SCAN ALR_ALERT_INSTALLATIONS_U1 (object id 27631) 1 TABLE ACCESS BY INDEX ROWID FND_ORACLE_USERID 1 INDEX UNIQUE SCAN FND_ORACLE_USERID_U1 (object id 22597) ******************************************************************************** select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0), audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt, avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1), nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0) ,nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 3 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER OBJ#(4) 1 INDEX UNIQUE SCAN OBJ#(3) (object id 3) ******************************************************************************** begin 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('MFG_ORGANIZATION_ID', :l); fnd_profile.put('MFG_CHART_OF_ACCOUNTS_ID', :m); 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.01 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.01 0 0 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** select cols,audit$,textlength,intcols,property,flags,rowid from view$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 3 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 3 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ#(59) 1 INDEX UNIQUE SCAN OBJ#(96) (object id 96) ******************************************************************************** select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.01 2 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.01 2 4 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname, o.dataobj#,o.flags from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.01 2 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.01 2 6 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** begin :v1 := fnd_bes_proc.process_event(:v2, :v3); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.03 0.01 4 39 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.03 0.01 4 39 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** 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 2 0.00 0.00 0 0 0 0 Fetch 14 0.00 0.01 2 7 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.01 2 7 0 12 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 2 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 2 2 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext, dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,scnwrp,scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags, plugged, NVL(spare1,0), NVL(spare2,0) from ts$ where ts#=: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.01 2 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 2 2 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER TS$ 1 INDEX UNIQUE SCAN I_TS# (object id 7) ******************************************************************************** SELECT ALR_ACTION_HISTORY_S.NEXTVAL FROM SYS.DUAL 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.01 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.01 0 6 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 SEQUENCE 1 TABLE ACCESS FULL DUAL ******************************************************************************** select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 12 0.00 0.01 2 24 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 19 0.00 0.01 2 24 0 6 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** 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.00 0.00 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.00 0.01 3 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY 1 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SET_MEMBERS 1 INDEX RANGE SCAN ALR_ACTION_SET_MEMBERS_N1 (object id 27575) ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 1 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID ALR_RESPONSE_SETS 0 INDEX RANGE SCAN ALR_RESPONSE_SETS_U2 (object id 27796) ******************************************************************************** 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.01 0.01 1 5 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 1 5 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 COUNT STOPKEY 1 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SET_CHECKS 2 INDEX RANGE SCAN DESCENDING ALR_ACTION_SET_CHECKS_N2 (object id 27541) ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.01 4 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.01 4 6 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID WF_EVENT_SUBSCRIPTIONS 2 INDEX UNIQUE SCAN WF_EVENT_SUBSCRIPTIONS_U1 (object id 166414) ******************************************************************************** SELECT profile_option_id, application_id from fnd_profile_options where profile_option_name = upper(:b1) and start_date_active <= sysdate and nvl(end_date_active, sysdate) >= sysdate call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 179 0.00 0.00 0 0 0 0 Fetch 179 0.01 0.00 1 471 0 113 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 358 0.01 0.01 1 471 0 113 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 1 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.01 1 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 2 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_PRINTER_STYLES 1 INDEX UNIQUE SCAN FND_PRINTER_STYLES_U1 (object id 34128) ******************************************************************************** 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.01 0.00 0 100 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.00 0 100 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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.00 0.00 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 1 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID ALR_ALERT_INPUTS 1 NESTED LOOPS 0 TABLE ACCESS BY INDEX ROWID ALR_ACTION_SET_INPUTS 0 INDEX RANGE SCAN ALR_ACTION_SET_INPUTS_U1 (object id 27566) 0 INDEX RANGE SCAN ALR_ALERT_INPUTS_N1 (object id 27627) ******************************************************************************** select distinct obj#,containerobj#,pflags,xpflags,mflags from sum$, sumdetail$ where detailobj#=:1 and sumobj#=obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 1 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT UNIQUE 0 NESTED LOOPS 0 TABLE ACCESS BY INDEX ROWID SUMDETAIL$ 0 INDEX RANGE SCAN I_SUMDETAIL$_2 (object id 322) 0 TABLE ACCESS BY INDEX ROWID SUM$ 0 INDEX UNIQUE SCAN I_SUM$_1 (object id 319) ******************************************************************************** SELECT ALERT_NAME, SQL_STATEMENT_TEXT, NVL(MAINTAIN_HISTORY_DAYS, -1), 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.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 1 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 1 6 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS OUTER 1 TABLE ACCESS BY INDEX ROWID ALR_ALERTS 1 INDEX UNIQUE SCAN ALR_ALERTS_U1 (object id 27616) 1 TABLE ACCESS BY INDEX ROWID FND_USER 1 INDEX UNIQUE SCAN FND_USER_U1 (object id 34712) ******************************************************************************** select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 1 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SELECT profile_option_value from fnd_profile_option_values where profile_option_id = :b4 and application_id = :b3 and level_id = :b2 and level_value = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 92 0.00 0.00 0 0 0 0 Fetch 92 0.00 0.00 1 172 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 184 0.00 0.00 1 172 0 8 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 1 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 1 0.00 0.00 2 3 7 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 2 3 7 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN ALR_ACTION_SET_CHECKS_U1 (object id 27556) ******************************************************************************** begin Fnd_Concurrent.Init_Request; 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 goal: CHOOSE Parsing user id: 173 ******************************************************************************** SELECT CODE, COMMAND, ARGUMENTS FROM ALR_MESSAGE_SYSTEMS WHERE ENABLED_FLAG = 'Y' 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 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 2 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL ALR_MESSAGE_SYSTEMS ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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.00 1 3 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 1 3 2 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN ALR_ALERT_CHECKS_U1 (object id 27623) ******************************************************************************** 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 1 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 2 4 4 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 4 4 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE 2 INDEX RANGE SCAN FND_PROFILE_OPTION_VALUES_U1 (object id 930126) ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 21 0.00 0.00 0 0 0 0 Fetch 21 0.00 0.00 0 45 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.00 0.00 0 45 0 3 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL DUAL ******************************************************************************** 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.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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 MERGE JOIN 117 FIXED TABLE FULL X$KSUPR 1 SORT JOIN 1 FIXED TABLE FULL X$KSUSE ******************************************************************************** SELECT TEXT FROM WF_RESOURCES WHERE TYPE = :B2 AND NAME = :B1 AND LANGUAGE = 'US' AND NAME IN ('WF_VERSION','WF_SYSTEM_GUID', 'WF_SYSTEM_STATUS','WF_SCHEMA') 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.01 0.00 3 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.01 0.00 3 6 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 FILTER 2 TABLE ACCESS BY INDEX ROWID WF_RESOURCES 2 INDEX UNIQUE SCAN WF_RESOURCES_PK (object id 74823) ******************************************************************************** SELECT name from wf_systems where guid = :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 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 2 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID WF_SYSTEMS 1 INDEX UNIQUE SCAN WF_SYSTEMS_U1 (object id 166472) ******************************************************************************** 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 goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID KOPM$ 1 INDEX UNIQUE SCAN I_KOPM1 (object id 287) ******************************************************************************** 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.00 0.00 0 3 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 2 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) ******************************************************************************** UPDATE ALR_ALERTS SET DATE_LAST_CHECKED = TO_DATE(:0,'DD-MON-YYYY HH24:MI:SS') WHERE APPLICATION_ID = :1 AND ALERT_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.00 0 1 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 2 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN ALR_ALERTS_U1 (object id 27616) ******************************************************************************** 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='CP_PHASE_CODE') and Phase.Lookup_Code=Decode(Status.Lookup_Code,'H','I','S','I','U','I','M','I', R.Phase_Code)) and Status.Lookup_Type='CP_STATUS_CODE') 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 15 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 15 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 3 NESTED LOOPS 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 34377) 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 34010) 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 34010) ******************************************************************************** SELECT agt.queue_handler from wf_agents agt, wf_systems sys where agt.name = :b2 and sys.name = :b1 and agt.system_guid = sys.guid 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 4 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 4 8 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 NESTED LOOPS 2 TABLE ACCESS BY INDEX ROWID WF_SYSTEMS 2 INDEX UNIQUE SCAN WF_SYSTEMS_U2 (object id 166473) 2 TABLE ACCESS BY INDEX ROWID WF_AGENTS 2 INDEX UNIQUE SCAN WF_AGENTS_U2 (object id 166404) ******************************************************************************** SELECT agt.name, sys.name from wf_agents agt, wf_systems sys where agt.guid = :b1 and sys.guid = agt.system_guid 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 4 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 4 8 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 NESTED LOOPS 2 TABLE ACCESS BY INDEX ROWID WF_AGENTS 2 INDEX UNIQUE SCAN WF_AGENTS_U1 (object id 166403) 2 TABLE ACCESS BY INDEX ROWID WF_SYSTEMS 2 INDEX UNIQUE SCAN WF_SYSTEMS_U1 (object id 166472) ******************************************************************************** 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.00 0.00 0 3 25 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 25 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (object id 194187) 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 TABLE ACCESS BY INDEX ROWID FND_CONC_PROG_ONSITE_INFO 1 INDEX UNIQUE SCAN FND_CONC_PROG_ONSITE_INFO_U1 (object id 194187) ******************************************************************************** SELECT application_id, profile_option_id from fnd_profile_options po where po.profile_option_name = :b1 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 2 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 2 6 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID FND_PROFILE_OPTIONS 2 INDEX UNIQUE SCAN FND_PROFILE_OPTIONS_U2 (object id 34644) ******************************************************************************** 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) 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.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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 34377) ******************************************************************************** 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 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 10 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 10 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 NESTED LOOPS 2 INDEX UNIQUE SCAN FND_RESPONSIBILITY_U1 (object id 34682) 2 TABLE ACCESS BY INDEX ROWID FND_RESPONSIBILITY_TL 2 INDEX UNIQUE SCAN FND_RESPONSIBILITY_TL_U1 (object id 34730) ******************************************************************************** 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 6 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 6 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 34377) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1 (object id 34471) ******************************************************************************** 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.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 10 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (object id 34347) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_QUEUES 1 INDEX UNIQUE SCAN FND_CONCURRENT_QUEUES_U1 (object id 34409) ******************************************************************************** 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 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 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 8 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 2 NESTED LOOPS 2 TABLE ACCESS BY INDEX ROWID WF_SYSTEMS 2 INDEX UNIQUE SCAN WF_SYSTEMS_U2 (object id 166473) 2 TABLE ACCESS BY INDEX ROWID WF_AGENTS 2 INDEX UNIQUE SCAN WF_AGENTS_U2 (object id 166404) ******************************************************************************** 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 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_LOOKUP_VALUES 1 INDEX RANGE SCAN FND_LOOKUP_VALUES_U1 (object id 34010) ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 ******************************************************************************** SELECT ALR_ACTION_SET_CHECKS_S.NEXTVAL 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 SEQUENCE 1 TABLE ACCESS FULL DUAL ******************************************************************************** select Has_Sub_Request ,Outfile_Name ,Logfile_name into :b0,:b1,:b2 from Fnd_Concurrent_Requests where Request_ID=:b3 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 2 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 2 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 FOR UPDATE 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) ******************************************************************************** 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.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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROCESSES 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROCESSES_U1 (object id 34347) ******************************************************************************** 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.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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT UNIQUE 0 FILTER 0 CONNECT BY WITH FILTERING 0 TABLE ACCESS BY INDEX ROWID FND_PRODUCT_INIT_DEPENDENCY 0 INDEX RANGE SCAN FND_PRODUCT_INIT_DEPENDENCY_U1 (object id 108000) 0 NESTED LOOPS 0 BUFFER SORT 0 CONNECT BY PUMP 0 INDEX RANGE SCAN FND_PRODUCT_INIT_DEPENDENCY_U1 (object id 108000) 0 TABLE ACCESS FULL FND_PRODUCT_INIT_DEPENDENCY 0 SORT AGGREGATE 0 FILTER 0 CONNECT BY WITH FILTERING 0 TABLE ACCESS BY INDEX ROWID FND_PRODUCT_INIT_DEPENDENCY 0 INDEX RANGE SCAN FND_PRODUCT_INIT_DEPENDENCY_U1 (object id 108000) 0 NESTED LOOPS 0 BUFFER SORT 0 CONNECT BY PUMP 0 INDEX RANGE SCAN FND_PRODUCT_INIT_DEPENDENCY_U1 (object id 108000) 0 TABLE ACCESS FULL FND_PRODUCT_INIT_DEPENDENCY ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 34377) ******************************************************************************** COMMIT 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 1 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 1 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** 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.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 10 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 34377) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS_TL 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_TL_U1 (object id 34471) ******************************************************************************** select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 0 9 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 9 0 6 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SELECT LOWER(HOST_NAME), LOWER(INSTANCE_NAME) FROM V$INSTANCE 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 goal: CHOOSE Parsing user id: 173 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 NESTED LOOPS 1 FIXED TABLE FULL X$QUIESCE 1 FIXED TABLE FULL X$KVIT 1 FIXED TABLE FULL X$KSUXSINST ******************************************************************************** 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 COUNT STOPKEY 1 TABLE ACCESS FULL DUAL ******************************************************************************** SELECT ALR_ALERT_CHECKS_S.NEXTVAL 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 SEQUENCE 1 TABLE ACCESS FULL DUAL ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) ******************************************************************************** SELECT TEXT FROM WF_RESOURCES WHERE TYPE = :B2 AND NAME = :B1 AND LANGUAGE = USERENV('LANG') AND NAME NOT IN ('WF_VERSION','WF_SYSTEM_GUID', 'WF_SYSTEM_STATUS', 'WF_SCHEMA') 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 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 FILTER 0 TABLE ACCESS BY INDEX ROWID WF_RESOURCES 0 INDEX UNIQUE SCAN WF_RESOURCES_PK (object id 74823) ******************************************************************************** select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 3 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 3 0 2 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SAVEPOINT wf_dispatch_savepoint 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 34377) ******************************************************************************** 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 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.00 0 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ#(34538) 1 INDEX RANGE SCAN OBJ#(34539) (object id 34539) ******************************************************************************** SELECT R.PRINT_STYLE, U.USER_NAME, R.REQUEST_ID, R.OUTFILE_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 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 0 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 10 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS 1 NESTED LOOPS 1 TABLE ACCESS BY INDEX ROWID OBJ#(34562) 1 INDEX UNIQUE SCAN OBJ#(34571) (object id 34571) 1 TABLE ACCESS BY INDEX ROWID OBJ#(34368) 1 INDEX UNIQUE SCAN OBJ#(34377) (object id 34377) 1 TABLE ACCESS BY INDEX ROWID OBJ#(34702) 1 INDEX UNIQUE SCAN OBJ#(34712) (object id 34712) ******************************************************************************** select message_text, encoded from fnd_log_messages where transaction_context_id = :context_id order by timestamp call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 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 4 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS FULL FND_CONCURRENT_REQUESTS ******************************************************************************** select INIT_FUNCTION_NAME from FND_PRODUCT_INITIALIZATION where APPLICATION_SHORT_NAME = :v1 and exists (select 1 from FND_PRODUCT_INIT_CONDITION C where C.APPLICATION_SHORT_NAME = :v2 and C.RE_INIT_CONDITION in ('USER','RESP','APPL','ORG')) 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 1 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 FILTER 0 INDEX RANGE SCAN FND_PRODUCT_INITIALIZATION_U1 (object id 107996) 0 INLIST ITERATOR 0 INDEX RANGE SCAN FND_PRODUCT_INIT_CONDITION_U1 (object id 107998) ******************************************************************************** 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.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_PROGRAMS 1 INDEX UNIQUE SCAN FND_CONCURRENT_PROGRAMS_U1 (object id 34377) ******************************************************************************** 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: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** ALTER SESSION SET SQL_TRACE TRUE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 ******************************************************************************** select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL DUAL ******************************************************************************** SELECT u.user_name, nvl(u.employee_id, -1), nvl(u.customer_id, -1), nvl(u.supplier_id, -1) 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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) ******************************************************************************** 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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) ******************************************************************************** SELECT TO_CHAR(DECODE(:b1, NULL, DECODE (:b4, 'START', :b3, :b2) + DECODE(:b6, /* 'MINUTES', GREATEST(interval, 1)/1440, */ 'MINUTES', :b5/1440, 'HOURS', :b5/24, 'DAYS', :b5, 'MONTHS', ADD_MONTHS( DECODE(:b4, 'START', :b3, :b2), :b5) - DECODE(:b4, 'START', :b3, :b2)), /*TIME*/ 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', 'NLS_DATE_LANGUAGE = ''AMERICAN''') 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL DUAL ******************************************************************************** SELECT count(*) from fnd_concurrent_requests where request_id = :b1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE 1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (object id 34571) ******************************************************************************** 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 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 6 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** select transaction_context_id from fnd_log_transaction_context where transaction_type = 'REQUEST' and transaction_id = :reqid 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 goal: CHOOSE Parsing user id: 173 Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID FND_LOG_TRANSACTION_CONTEXT 0 INDEX RANGE SCAN FND_LOG_TRANSACTION_CONTEXT_N2 (object id 280061) ******************************************************************************** select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY USER ROWID VIEW$ ******************************************************************************** select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY 0 TABLE ACCESS CLUSTER LOB$ 1 INDEX UNIQUE SCAN I_OBJ# (object id 3) ******************************************************************************** SELECT userenv('SESSIONID') 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 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SELECT nvl(multi_org_flag, 'N'), nvl(multi_currency_flag, 'N') from fnd_product_groups 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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SELECT a.application_short_name from fnd_application a where a.application_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 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 173 (recursive depth: 1) ******************************************************************************** SELECT 'TRACE_USER_DETAILS: TIMESTAMP=14-JUN-07:22:11:57: USER_NAME=ARAVE: CONC_REQUEST_ID=10810400: OLTP_OPT_MODE= : CONC_OPT_MODE= : CONC_PROG_EXE= ALECDC: CONC_PROG_NAME=Check Periodic Alert: RESPONSIBILITY=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 goal: CHOOSE Parsing user id: 173 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS FULL DUAL ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 85 0.03 0.03 0 0 0 0 Execute 95 0.07 0.71 52 151 288 61 Fetch 56 42.42 213.03 165790 2639201 0 110 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 236 42.52 213.79 165842 2639352 288 171 Misses in library cache during parse: 2 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 71 0.00 0.01 0 0 0 0 Execute 394 0.04 0.14 26 74 99 9 Fetch 426 0.04 0.60 120 1037 0 221 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 891 0.08 0.75 146 1111 99 230 Misses in library cache during parse: 1 128 user SQL statements in session. 37 internal SQL statements in session. 165 SQL statements in session. ******************************************************************************** Trace file: eaj_alert_4000.trc Trace file compatibility: 9.02.00 Sort options: fchela exeela 1 session in tracefile. 128 user SQL statements in trace file. 37 internal SQL statements in trace file. 165 SQL statements in trace file. 124 unique SQL statements in trace file. 2394 lines in trace file.