TKPROF: Release 12.1.0.2.0 - Development on Fri Jun 19 10:29:30 2020 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Trace file: EBSDE11_ora_112722_SYSADMIN_0619_101524.trc Sort options: default ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** SQL ID: 15qkgfm4v75pz Plan Hash: 0 BEGIN fnd_trace.start_trace(:1); END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 2 0.08 0.11 16 73 0 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.08 0.11 16 73 0 2 Misses in library cache during parse: 0 Misses in library cache during execute: 2 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SQL ID: b0d5haypwhhyu Plan Hash: 0 begin fnd_log_repository.get_bulk_context_pvt(:1, :2, :3, :4, :5); end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 675 0.12 0.19 0 0 0 675 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 675 0.12 0.19 0 0 0 675 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 675 0.00 0.00 SQL*Net message from client 675 0.08 0.33 log file sync 1 0.00 0.00 ******************************************************************************** SQL ID: 8156nbx891ybz Plan Hash: 4013722353 SELECT FND_LOG_MESSAGES_S.NEXTVAL FROM DUAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 675 0.00 0.00 0 0 0 0 Fetch 675 0.00 0.01 0 0 1 675 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1350 0.01 0.01 0 0 1 675 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 SEQUENCE OF 'FND_LOG_MESSAGES_S' (SEQUENCE) 0 FAST DUAL Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ row cache lock 1 0.00 0.00 ******************************************************************************** SQL ID: f6umh3yxzm99n Plan Hash: 0 BEGIN fnd_trace.stop_trace(:1); END; 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 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) ******************************************************************************** SQL ID: c9h14xw3t88q4 Plan Hash: 0 alter session set events 'sql_trace off' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Parsing user id: 173 (APPS) (recursive depth: 1) ******************************************************************************** SQL ID: 26ghg6vvatjqy Plan Hash: 2361687893 SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel result_cache(snapshot=3600) */ SUM(C1) FROM (SELECT /*+ qb_name("innerQuery") */ 1 AS C1 FROM SYS."X$KSLED" "E#1", SYS."X$KSLWT" "W#0" WHERE ("W#0"."KSLWTEVT"="E#1"."INDX")) innerQuery 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: 1 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=0 pr=0 pw=0 time=849 us) 443 443 443 NESTED LOOPS (cr=0 pr=0 pw=0 time=901 us cost=0 size=5863 card=451) 443 443 443 FIXED TABLE FULL X$KSLWT (cr=0 pr=0 pw=0 time=342 us cost=0 size=3157 card=451) 443 443 443 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=331 us cost=0 size=6 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 SORT (AGGREGATE) 443 NESTED LOOPS 443 FIXED TABLE (FULL) OF 'X$KSLWT' (TABLE (FIXED)) 443 FIXED TABLE (FIXED INDEX) OF 'X$KSLED (ind:2)' (TABLE (FIXED) ) ******************************************************************************** SQL ID: dnzjmxkbmk4uy Plan Hash: 2517809292 select distinct spid from v$process p,v$session s where p.addr = s.paddr and s.audsid = userenv('sessionid') 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.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 0 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 HASH UNIQUE (cr=0 pr=0 pw=0 time=2873 us cost=2 size=55 card=1) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=2326 us cost=1 size=55 card=1) 1 1 1 HASH JOIN (cr=0 pr=0 pw=0 time=2322 us cost=1 size=51 card=1) 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=858 us cost=0 size=30 card=1) 449 449 449 FIXED TABLE FULL X$KSLWT (cr=0 pr=0 pw=0 time=453 us cost=0 size=3608 card=451) 1 1 1 FIXED TABLE FIXED INDEX X$KSUSE (ind:1) (cr=0 pr=0 pw=0 time=600 us cost=0 size=22 card=1) 454 454 454 FIXED TABLE FULL X$KSUPR (cr=0 pr=0 pw=0 time=458 us cost=1 size=9723 card=463) 1 1 1 FIXED TABLE FIXED INDEX X$KSLED (ind:2) (cr=0 pr=0 pw=0 time=3 us cost=0 size=4 card=1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 HASH (UNIQUE) 1 NESTED LOOPS 1 HASH JOIN 1 NESTED LOOPS 449 FIXED TABLE (FULL) OF 'X$KSLWT' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSUSE (ind:1)' (TABLE (FIXED)) 454 FIXED TABLE (FULL) OF 'X$KSUPR' (TABLE (FIXED)) 1 FIXED TABLE (FIXED INDEX) OF 'X$KSLED (ind:2)' (TABLE (FIXED) ) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 10cp58xjsr3m7 Plan Hash: 4013722353 select fnd_log_messages_s.nextval from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 SEQUENCE OF 'FND_LOG_MESSAGES_S' (SEQUENCE) 0 FAST DUAL Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: fkdzz2g0ws8r3 Plan Hash: 3678372184 select description from FND_PROFILE_OPTIONS_VL where profile_option_name= 'FND_CORPORATE_BRANDING_IMAGE' 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 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 6 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 NESTED LOOPS 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_PROFILE_OPTIONS_U2' (INDEX (UNIQUE)) 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'FND_PROFILE_OPTIONS_TL' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'FND_PROFILE_OPTIONS_TL_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: fjd9w8q1p3b38 Plan Hash: 0 BEGIN :1 := FND_LOG_REPOSITORY.STR_UNCHKED_INT_WITH_CONTEXT(LOG_LEVEL=>:2, MODULE=>:3,MESSAGE_TEXT=>:4,SESSION_ID=>:5,USER_ID=>:6,NODE=>:7, NODE_IP_ADDRESS=>:8,JVM_ID=>:9,THREAD_ID=>:10,ENCODED=>:11,CALL_STACK=>:12) ; END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 39 0.01 0.02 0 0 0 39 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 39 0.01 0.02 0 0 0 39 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 39 0.00 0.00 log file sync 38 0.00 0.01 SQL*Net message from client 39 21.30 21.31 ******************************************************************************** SQL ID: 60u0yd9z56tq8 Plan Hash: 341022301 INSERT INTO FND_LOG_MESSAGES ( ECID_ID, ECID_SEQ, CALLSTACK, ERRORSTACK, MODULE, LOG_LEVEL, MESSAGE_TEXT, SESSION_ID, USER_ID, TIMESTAMP, LOG_SEQUENCE, ENCODED, NODE, NODE_IP_ADDRESS, PROCESS_ID, JVM_ID, THREAD_ID, AUDSID, DB_INSTANCE, TRANSACTION_CONTEXT_ID ) VALUES ( SYS_CONTEXT('USERENV', 'ECID_ID'), SYS_CONTEXT('USERENV', 'ECID_SEQ'), :B16 , :B15 , SUBSTRB(:B14 ,1,255), :B13 , SUBSTRB(FND_LOG_REPOSITORY.NOPASS(:B12 ), 1, 4000), :B11 , NVL(:B10 , -1), SYSDATE, FND_LOG_MESSAGES_S.NEXTVAL, :B9 , SUBSTRB(:B8 ,1,60), SUBSTRB(:B7 , 1,30), SUBSTRB(:B6 ,1,120), SUBSTRB(:B5 ,1,120), SUBSTRB(:B4 ,1,120), :B3 , :B2 , :B1 ) RETURNING LOG_SEQUENCE INTO :O0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 39 0.04 0.21 11 131 885 39 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 39 0.04 0.21 11 131 885 39 Misses in library cache during parse: 0 Misses in library cache during execute: 4 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 LOAD TABLE CONVENTIONAL FND_LOG_MESSAGES (cr=6 pr=2 pw=3 time=6720 us) 1 1 1 SEQUENCE FND_LOG_MESSAGES_S (cr=0 pr=0 pw=0 time=87 us) Rows Execution Plan ------- --------------------------------------------------- 0 INSERT STATEMENT MODE: ALL_ROWS 1 LOAD TABLE CONVENTIONAL OF 'FND_LOG_MESSAGES' 1 SEQUENCE OF 'FND_LOG_MESSAGES_S' (SEQUENCE) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ Disk file operations I/O 113 0.00 0.00 direct path write 10 0.13 0.13 cell single block physical read 6 0.00 0.02 direct path read 5 0.00 0.00 row cache lock 1 0.00 0.00 ******************************************************************************** SQL ID: 8ggw94h7mvxd7 Plan Hash: 0 COMMIT call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 40 0.00 0.00 0 0 40 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 42 0.00 0.00 0 0 40 0 Misses in library cache during parse: 0 Parsing user id: 173 (APPS) (recursive depth: 1) ******************************************************************************** SQL ID: cyxbnpx56hm9h Plan Hash: 0 BEGIN :1:=jdr_mds_internal.getDocumentID(:2,:3); END; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: btamp5s88hqqb Plan Hash: 584970956 SELECT PATH_DOCID, PATH_TYPE FROM JDR_PATHS WHERE PATH_NAME = :B1 AND PATH_OWNER_DOCID = :B2 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'JDR_PATHS' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'JDR_PATHS_U2' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 14knmm0z37a0q Plan Hash: 0 declare val varchar2(256);begin :1 := fnd_session_management.GETSESSIONATTRIBUTEVALUE(:2,:3);end; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 3 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 3 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 3 0.00 0.00 ******************************************************************************** SQL ID: 6ftv6fk15fcjp Plan Hash: 4121501816 SELECT VALUE FROM ICX_SESSION_ATTRIBUTES WHERE SESSION_ID = :B2 AND NAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 9 0 0 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'ICX_SESSION_ATTRIBUTES' (TABLE) 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'ICX_SESSION_ATTRIBUTES_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: 9knava656vbr0 Plan Hash: 0 BEGIN :1 := MO_GLOBAL.GET_CURRENT_ORG_ID(); END; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 2ht9ry9by8ydz Plan Hash: 2097519442 select rowid as "__Oracle_JDBC_interal_ROWID__", lookup_code, meaning from fnd_lookup_values where lookup_type ='FND_SLIDEMENU_LKP' and LANGUAGE=:1 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 2 0.00 0.00 0 17 0 13 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 17 0 13 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID BATCHED) OF 'FND_LOOKUP_VALUES' (TABLE) 0 INDEX MODE: ANALYZED (RANGE SCAN) OF 'FND_LOOKUP_VALUES_U1' (INDEX (UNIQUE)) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 0.00 0.00 ******************************************************************************** SQL ID: f1v2hmt6qbkyc Plan Hash: 0 begin fnd_session_management.PUTSESSIONATTRIBUTEVALUE(:1,:2,:3);end; 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 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** SQL ID: 9afw9a42jbumf Plan Hash: 1750127105 DELETE ICX_SESSION_ATTRIBUTES WHERE SESSION_ID = :B2 AND NAME = :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 4 5 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 4 5 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 DELETE STATEMENT MODE: ALL_ROWS 0 DELETE OF 'ICX_SESSION_ATTRIBUTES' 0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'ICX_SESSION_ATTRIBUTES_U1' (INDEX (UNIQUE)) ******************************************************************************** SQL ID: dxmpc755h7qj4 Plan Hash: 0 INSERT INTO ICX_SESSION_ATTRIBUTES (SESSION_ID,NAME,VALUE) VALUES (:B3 ,:B2 ,: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 4 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 4 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 173 (APPS) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 INSERT STATEMENT MODE: ALL_ROWS 0 LOAD TABLE CONVENTIONAL OF 'ICX_SESSION_ATTRIBUTES' ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.01 0 0 0 0 Execute 728 0.23 0.33 16 73 0 724 Fetch 5 0.00 0.00 0 23 0 16 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 735 0.24 0.35 16 96 0 740 Misses in library cache during parse: 2 Misses in library cache during execute: 3 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 730 0.00 0.00 SQL*Net message from client 730 21.30 21.65 Disk file operations I/O 113 0.00 0.00 log file sync 39 0.00 0.01 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 42 0.01 0.01 0 0 0 0 Execute 985 0.11 0.30 11 137 936 42 Fetch 1105 0.05 0.06 63 760 1 2843 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2132 0.18 0.38 74 897 937 2885 Misses in library cache during parse: 15 Misses in library cache during execute: 17 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ cell single block physical read 69 0.00 0.04 row cache lock 3 0.00 0.00 direct path write 10 0.13 0.13 direct path read 5 0.00 0.00 22 user SQL statements in session. 29 internal SQL statements in session. 51 SQL statements in session. 11 statements EXPLAINed in this session. ******************************************************************************** Trace file: EBSDE11_ora_112722_SYSADMIN_0619_101524.trc Trace file compatibility: 11.1.0.7 Sort options: default 1 session in tracefile. 22 user SQL statements in trace file. 29 internal SQL statements in trace file. 51 SQL statements in trace file. 40 unique SQL statements in trace file. 11 SQL statements EXPLAINed using schema: APPS.prof$plan_table Default table was used. Table was created. Table was dropped. 28671 lines in trace file. 22 elapsed seconds in trace file.