TKPROF: Release 19.0.0.0.0 - Development on Tue Jul 2 13:48:31 2024 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Trace file: finprod1_ora_117631_RC_MCB_SUP0400_LIMIT_CARDS.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: grwydz59pu6mc Plan Hash: 3684871272 select text from view$ where rowid=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 21 0 10 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 30 0.00 0.00 0 21 0 10 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 4 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS BY USER ROWID VIEW$ (cr=1 pr=0 pw=0 time=11 us starts=1 cost=1 size=15 card=1) ******************************************************************************** SQL ID: 54q35ctruvmjc Plan Hash: 865334584 select cc.intcol# from cdef$ c, ccol$ cc where c.obj#=cc.obj# and c.con#=cc.con# and c.type#=7 and c.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 3 0.00 0.00 0 10 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.00 0.00 0 10 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 2 2 2 HASH JOIN (cr=10 pr=0 pw=0 time=375 us starts=1 cost=4 size=87 card=3) 2 2 2 NESTED LOOPS (cr=4 pr=0 pw=0 time=57 us starts=1 cost=4 size=87 card=3) 2 2 2 STATISTICS COLLECTOR (cr=4 pr=0 pw=0 time=54 us starts=1) 2 2 2 TABLE ACCESS CLUSTER CDEF$ (cr=4 pr=0 pw=0 time=31 us starts=1 cost=2 size=42 card=3) 1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 time=18 us starts=1 cost=1 size=0 card=1)(object id 30) 0 0 0 TABLE ACCESS CLUSTER CCOL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=15 card=1) 23 23 23 TABLE ACCESS CLUSTER CCOL$ (cr=6 pr=0 pw=0 time=14 us starts=1 cost=2 size=90 card=6) 1 1 1 INDEX UNIQUE SCAN I_COBJ# (cr=2 pr=0 pw=0 time=8 us starts=1 cost=1 size=0 card=1)(object id 30) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 1 0.00 0.00 ******************************************************************************** SQL ID: 23s96rf87635s Plan Hash: 1347681019 select count(*) from sys.col_group_usage$ where obj# = :1 and cols = :2 and trunc(sysdate) = trunc(timestamp) and bitand(flags, :3) = :3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 0 21 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 0 21 0 7 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: c8h20n1d0k95m Plan Hash: 1097271556 select /*+ no_parallel */ spare4 from sys.optstat_hist_control$ where sname=: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: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS STORAGE FULL OPTSTAT_HIST_CONTROL$ (cr=2 pr=0 pw=0 time=48 us starts=1 cost=2 size=26 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 2 0.00 0.00 ******************************************************************************** SQL ID: 1wz811srf8xh8 Plan Hash: 0 BEGIN dbms_stats.gen_selmap(:owner,:tabname,:pname,:spname, :flag,:colinfo,:selmap,:clist); 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 mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 4 0.00 0.00 ******************************************************************************** SQL ID: b9nbhsbx8tqz5 Plan Hash: 1097271556 SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 0 14 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.00 0.00 0 14 0 7 Misses in library cache during parse: 1 Misses in library cache during execute: 2 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 TABLE ACCESS STORAGE FULL OPTSTAT_HIST_CONTROL$ (cr=2 pr=0 pw=0 time=42 us starts=1 cost=2 size=26 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 ******************************************************************************** SQL ID: d7zvk9bn8dyr6 Plan Hash: 3646447030 select /* QOSD */ /*+ index(do) */ dir_cnt from opt_directive_own$ do where dir_own# = :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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 3) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID OPT_DIRECTIVE_OWN$ (cr=1 pr=0 pw=0 time=8 us starts=1 cost=1 size=15 card=1) 0 0 0 INDEX UNIQUE SCAN I_OPT_DIRECTIVE_OWN# (cr=1 pr=0 pw=0 time=7 us starts=1 cost=0 size=0 card=1)(object id 705) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 1 0.00 0.00 ******************************************************************************** SQL ID: 3rju5whzbh017 Plan Hash: 3326593961 SELECT /*+ ordered index(u) index(o) index(po) OPT_PARAM('_parallel_syspls_obey_force' 'false') */ MOD(PO.SPARE2, 256), PO.PARTTYPE FROM SYS.USER$ U, SYS.OBJ$ O, SYS.PARTOBJ$ PO WHERE U.NAME = :B3 AND O.NAME = :B2 AND O.NAMESPACE = :B1 AND U.USER# = O.OWNER# AND O.OBJ# = PO.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 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 HASH JOIN (cr=2 pr=0 pw=0 time=2993 us starts=1 cost=3 size=67 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=2983 us starts=1 cost=3 size=67 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=2981 us starts=1 cost=3 size=67 card=1) 0 0 0 STATISTICS COLLECTOR (cr=2 pr=0 pw=0 time=2979 us starts=1) 0 0 0 HASH JOIN (cr=2 pr=0 pw=0 time=2941 us starts=1 cost=2 size=55 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=2936 us starts=1 cost=2 size=55 card=1) 1 1 1 STATISTICS COLLECTOR (cr=2 pr=0 pw=0 time=2928 us starts=1) 1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=2902 us starts=1 cost=1 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=9 us starts=1 cost=0 size=0 card=1)(object id 46) 0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=5 us starts=1 cost=1 size=38 card=1)(object id 37) 0 0 0 INDEX SKIP SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=38 card=1)(object id 37) 0 0 0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 80) 0 0 0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=12 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED PARTOBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=12 card=1) 0 0 0 INDEX FULL SCAN I_PARTOBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 80) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 4 0.00 0.00 gc cr block 2-way 1 0.00 0.00 ******************************************************************************** SQL ID: 7azxftvubufnj Plan Hash: 126357115 SELECT COUNT(UNQ) UNQ, COUNT(PFX) PFX FROM (SELECT /*+ first_rows(1) leading(cc) OPT_PARAM('_parallel_syspls_obey_force' 'false') */ CD.TYPE# UNQ, NULL PFX FROM SYS.CCOL$ CC, SYS.CDEF$ CD WHERE CC.OBJ# = :B2 AND CC.INTCOL# = :B1 AND CD.CON# = CC.CON# AND CD.OBJ# = CC.OBJ# AND CD.ENABLED IS NOT NULL AND CD.INTCOLS = 1 AND CD.TYPE# IN (2,3) AND BITAND(CD.DEFER, 2+4) = 4 AND ROWNUM < 2 UNION ALL SELECT /*+ first_rows(1) leading(i) */ CASE WHEN I.INTCOLS = 1 AND BITAND(I.PROPERTY,1) = 1 THEN 3 ELSE NULL END UNQ, CASE WHEN IC.POS# = 1 THEN 1 ELSE NULL END PFX FROM SYS.IND$ I, SYS.ICOL$ IC WHERE I.BO# = :B2 AND I.BO# = IC.BO# AND IC.INTCOL# = :B1 AND I.OBJ# = IC.OBJ# AND BITAND(I.FLAGS,1025) = 0 AND ROWNUM < 2 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 78 0.01 0.01 0 0 0 0 Fetch 78 0.00 0.00 0 0 0 78 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 157 0.01 0.01 0 0 0 78 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: FIRST_ROWS Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=0 pr=0 pw=0 time=1428 us starts=1) 0 0 0 VIEW (cr=0 pr=0 pw=0 time=1422 us starts=1 cost=5 size=32 card=2) 0 0 0 UNION-ALL (cr=0 pr=0 pw=0 time=1421 us starts=1) 0 0 0 COUNT STOPKEY (cr=0 pr=0 pw=0 time=1401 us starts=1) 0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=1398 us starts=1 cost=2 size=39 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=1387 us starts=1 cost=2 size=39 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=1386 us starts=1 cost=2 size=39 card=1) 0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=1383 us starts=1) 0 0 0 TABLE ACCESS CLUSTER CCOL$ (cr=0 pr=0 pw=0 time=5 us starts=1 cost=2 size=15 card=1) 0 0 0 INDEX UNIQUE SCAN I_COBJ# (cr=0 pr=0 pw=0 time=3 us starts=1 cost=1 size=0 card=1)(object id 30) 0 0 0 INDEX RANGE SCAN I_CDEF2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 54) 0 0 0 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=24 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED CDEF$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=24 card=1) 0 0 0 INDEX RANGE SCAN I_CDEF2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 54) 0 0 0 COUNT STOPKEY (cr=0 pr=0 pw=0 time=16 us starts=1) 0 0 0 HASH JOIN (cr=0 pr=0 pw=0 time=14 us starts=1 cost=3 size=42 card=1) 0 0 0 NESTED LOOPS (cr=0 pr=0 pw=0 time=10 us starts=1 cost=3 size=42 card=1) 0 0 0 STATISTICS COLLECTOR (cr=0 pr=0 pw=0 time=10 us starts=1) 0 0 0 TABLE ACCESS CLUSTER IND$ (cr=0 pr=0 pw=0 time=3 us starts=1 cost=2 size=23 card=1) 0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=1 us starts=1 cost=1 size=0 card=1)(object id 3) 0 0 0 TABLE ACCESS CLUSTER ICOL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=19 card=1) 0 0 0 TABLE ACCESS CLUSTER ICOL$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=19 card=1) 0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 3) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 7 0.00 0.00 ******************************************************************************** SQL ID: 7gzcdxb9drpf8 Plan Hash: 3179548805 SELECT /*+ leading(u) use_nl_with_index(o) OPT_PARAM('_parallel_syspls_obey_force' 'false') */ O.OBJ#, O.TYPE# FROM SYS.USER$ U, SYS.OBJ$ O WHERE U.NAME = :B3 AND O.OWNER# = U.USER# AND O.NAME = :B2 AND O.NAMESPACE = 1 AND O.REMOTEOWNER IS NULL AND O.LINKNAME IS NULL AND (O.SUBNAME IS NULL AND :B1 IS NULL OR O.SUBNAME = :B1 ) AND O.TYPE# IN (2,19,34) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=233 us starts=1 cost=2 size=122 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=225 us starts=1 cost=1 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=7 us starts=1 cost=0 size=0 card=1)(object id 46) 0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=6 us starts=1 cost=1 size=105 card=1)(object id 37) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 5 0.00 0.00 gc cr block 2-way 1 0.00 0.00 ******************************************************************************** SQL ID: 39zsy1kpdjz09 Plan Hash: 2596887597 SELECT O.FLAGS, T.PROPERTY FROM SYS.OBJ$ O, SYS.TAB$ T WHERE O.OBJ# = :B1 AND O.OBJ# = T.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 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 MERGE JOIN CARTESIAN (cr=2 pr=0 pw=0 time=16 us starts=1 cost=5 size=24 card=1) 0 0 0 TABLE ACCESS CLUSTER TAB$ (cr=2 pr=0 pw=0 time=11 us starts=1 cost=2 size=14 card=1) 0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=10 us starts=1 cost=1 size=0 card=1)(object id 3) 0 0 0 BUFFER SORT (cr=0 pr=0 pw=0 time=0 us starts=0 cost=3 size=10 card=1) 0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=3 size=10 card=1) 0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=0 card=1)(object id 36) ******************************************************************************** SQL ID: 5rurx5xtjwcu2 Plan Hash: 185276389 SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ KSPPCV.KSPPSTVL FROM X$KSPPCV KSPPCV, X$KSPPI KSPPI WHERE KSPPI.INDX = KSPPCV.INDX AND KSPPI.KSPPINM = :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 0 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=168 us starts=1 cost=0 size=39 card=1) 1 1 1 FIXED TABLE FIXED INDEX X$KSPPI (ind:1) (cr=0 pr=0 pw=0 time=155 us starts=1 cost=0 size=30 card=1) 1 1 1 FIXED TABLE FIXED INDEX X$KSPPCV (ind:1) (cr=0 pr=0 pw=0 time=8 us starts=1 cost=0 size=9 card=1) ******************************************************************************** SQL ID: 87gaftwrm2h68 Plan Hash: 1072382624 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 0 21 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 0 21 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 5uu6gr69xhk48 Plan Hash: 3095026863 SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ T.PROPERTY FROM SYS.USER$ U, SYS.OBJ$ O, SYS.TAB$ T WHERE U.NAME = :B2 AND U.USER# = O.OWNER# AND O.NAME = :B1 AND O.NAMESPACE = 1 AND O.REMOTEOWNER IS NULL AND O.LINKNAME IS NULL AND O.SUBNAME IS NULL AND O.TYPE# = 2 AND O.OBJ# = T.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 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=311 us starts=1 cost=3 size=136 card=1) 0 0 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=311 us starts=1 cost=2 size=122 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID USER$ (cr=2 pr=0 pw=0 time=305 us starts=1 cost=1 size=17 card=1) 1 1 1 INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=7 us starts=1 cost=0 size=0 card=1)(object id 46) 0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=3 us starts=1 cost=1 size=105 card=1)(object id 37) 0 0 0 TABLE ACCESS CLUSTER TAB$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=14 card=1) 0 0 0 INDEX UNIQUE SCAN I_OBJ# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 3) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ gc current block 2-way 1 0.00 0.00 ******************************************************************************** SQL ID: 62yyzw3309d6a Plan Hash: 2667441017 SELECT VALUE FROM V$SESSION_FIX_CONTROL WHERE BUGNO = :B1 AND SESSION_ID = USERENV('SID') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 78 0.00 0.00 0 0 0 0 Fetch 78 0.00 0.00 0 0 0 78 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 157 0.00 0.00 0 0 0 78 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: SYS (recursive depth: 2) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 FIXED TABLE FIXED INDEX X$QKSBGSES (ind:1) (cr=0 pr=0 pw=0 time=15 us starts=1 cost=0 size=16 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 ******************************************************************************** SQL ID: 0nphkprhngsuz Plan Hash: 4060643197 CREATE TABLE STG_MCB_SUP0400TEST AS SELECT * FROM RC_MCB_SUP0400_LIMIT_CARDS WHERE PERIOD_ID=20240630 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.30 0.34 0 9 0 0 Execute 1 92.44 99.48 40579 9136899 34 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 92.74 99.82 40579 9136908 34 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 117 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 LOAD AS SELECT STG_MCB_SUP0400TEST (cr=0 pr=0 pw=0 time=100 us starts=1) 4 4 4 OPTIMIZER STATISTICS GATHERING (cr=7797615 pr=39766 pw=0 time=96597323 us starts=1 cost=9250 size=389 card=1) 4 4 4 NESTED LOOPS (cr=7797615 pr=39766 pw=0 time=96591216 us starts=1 cost=9250 size=389 card=1) 4 4 4 NESTED LOOPS (cr=7797613 pr=39766 pw=0 time=96591173 us starts=1 cost=9250 size=385 card=1) 4 4 4 NESTED LOOPS (cr=7797599 pr=39766 pw=0 time=96590062 us starts=1 cost=9248 size=274 card=1) 2264 2264 2264 NESTED LOOPS (cr=9115331 pr=40516 pw=0 time=107675855 us starts=1 cost=9246 size=232 card=1) 8262 8262 8262 NESTED LOOPS (cr=75074 pr=40522 pw=0 time=2372217 us starts=1 cost=9197 size=193 card=1) 8262 8262 8262 NESTED LOOPS (cr=66798 pr=40522 pw=0 time=2265824 us starts=1 cost=9195 size=161 card=1) 8262 8262 8262 NESTED LOOPS (cr=58532 pr=40522 pw=0 time=2162992 us starts=1 cost=9194 size=136 card=1) 8262 8262 8262 HASH JOIN (cr=33744 pr=33717 pw=0 time=224420 us starts=1 cost=9192 size=116 card=1) 156678 156678 156678 HASH JOIN (cr=33736 pr=33717 pw=0 time=84822 us starts=1 cost=9190 size=5096 card=56) 1 1 1 JOIN FILTER CREATE :BF0000 (cr=8 pr=0 pw=0 time=1247 us starts=1 cost=2 size=40 card=1) 1 1 1 VIEW index$_join$_026 (cr=8 pr=0 pw=0 time=1219 us starts=1 cost=2 size=40 card=1) 1 1 1 HASH JOIN (cr=8 pr=0 pw=0 time=1213 us starts=1) 104 104 104 INDEX STORAGE FAST FULL SCAN PK_D_LIMITLEVELDETAILTYPE (cr=4 pr=0 pw=0 time=127 us starts=1 cost=1 size=40 card=1)(object id 5213985) 1 1 1 INDEX STORAGE FAST FULL SCAN UQ_D_LIMITLEVELDETAILTYPE_1 (cr=4 pr=0 pw=0 time=26 us starts=1 cost=1 size=40 card=1)(object id 5213988) 156678 156678 156678 JOIN FILTER USE :BF0000 (cr=33727 pr=33717 pw=0 time=61108 us starts=1 cost=9188 size=246024 card=4824) 156678 156678 156678 PARTITION LIST SINGLE PARTITION: KEY(AP) KEY(AP) (cr=33727 pr=33717 pw=0 time=60449 us starts=1 cost=9188 size=246024 card=4824) 156678 156678 156678 TABLE ACCESS STORAGE FULL FCT_LIMIT_DETAIL PARTITION: 1099 1099 (cr=33724 pr=33717 pw=0 time=55262 us starts=1 cost=9188 size=246024 card=4824) 1 1 1 VIEW index$_join$_025 (cr=8 pr=0 pw=0 time=808 us starts=1 cost=2 size=25 card=1) 1 1 1 HASH JOIN (cr=8 pr=0 pw=0 time=805 us starts=1) 6 6 6 INDEX STORAGE FAST FULL SCAN PK_D_LIMITLEVEL (cr=4 pr=0 pw=0 time=31 us starts=1 cost=1 size=25 card=1)(object id 5213981) 1 1 1 INDEX STORAGE FAST FULL SCAN UQ_D_LIMITLEVEL_1 (cr=4 pr=0 pw=0 time=17 us starts=1 cost=1 size=25 card=1)(object id 5213984) 8262 8262 8262 PARTITION LIST SINGLE PARTITION: 1099 1099 (cr=24788 pr=6805 pw=0 time=2251947 us starts=8262 cost=2 size=20 card=1) 8262 8262 8262 TABLE ACCESS BY LOCAL INDEX ROWID FCT_LIMIT_MASTER PARTITION: 1099 1099 (cr=24788 pr=6805 pw=0 time=2145841 us starts=8262 cost=2 size=20 card=1) 8262 8262 8262 INDEX UNIQUE SCAN PPK_F_LIMITMASTER PARTITION: 1099 1099 (cr=16526 pr=1225 pw=0 time=581348 us starts=8262 cost=1 size=0 card=1)(object id 5354562) 8262 8262 8262 TABLE ACCESS BY INDEX ROWID DIM_CURRENCY (cr=8266 pr=0 pw=0 time=76552 us starts=8262 cost=1 size=25 card=1) 8262 8262 8262 INDEX UNIQUE SCAN PK_DIMCURRENCY (cr=4 pr=0 pw=0 time=29518 us starts=8262 cost=0 size=0 card=1)(object id 5212970) 8262 8262 8262 TABLE ACCESS BY INDEX ROWID FCT_CURRENCY_RATE (cr=8276 pr=0 pw=0 time=88761 us starts=8262 cost=2 size=32 card=1) 8262 8262 8262 INDEX UNIQUE SCAN PK_FCTCURRENCYRATE (cr=14 pr=0 pw=0 time=51753 us starts=8262 cost=1 size=0 card=1)(object id 5213240) 2264 2264 2264 INDEX RANGE SCAN CUST_RELATION_PK (cr=9054098 pr=0 pw=0 time=95118212 us starts=8262 cost=49 size=39 card=1)(object id 5392092) 4 4 4 TABLE ACCESS BY INDEX ROWID DIM_CUSTOMER (cr=6749 pr=55 pw=0 time=310068 us starts=2264 cost=2 size=42 card=1) 2264 2264 2264 INDEX UNIQUE SCAN PK_D_CUSTOMER (cr=4485 pr=54 pw=0 time=293237 us starts=2264 cost=1 size=0 card=1)(object id 5213704) 4 4 4 TABLE ACCESS BY INDEX ROWID DIM_CUSTOMER (cr=14 pr=0 pw=0 time=882 us starts=4 cost=2 size=111 card=1) 4 4 4 INDEX UNIQUE SCAN PK_D_CUSTOMER (cr=10 pr=0 pw=0 time=859 us starts=4 cost=1 size=0 card=1)(object id 5213704) 4 4 4 INDEX UNIQUE SCAN PK_D_CUSTOMERTYPE (cr=2 pr=0 pw=0 time=17 us starts=4 cost=0 size=4 card=1)(object id 5213804) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 131 0.00 0.00 library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 DLM cross inst call completion 12 0.00 0.00 row cache lock 4 0.00 0.00 KJC: Wait for msg sends to complete 2 0.00 0.00 reliable message 1 0.00 0.00 enq: KO - fast object checkpoint 2 0.00 0.00 cell smart table scan 119 0.02 0.03 gc cr grant 2-way 484 0.00 0.06 cell single block physical read: RDMA 4355 0.00 0.30 cell single block physical read: pmem cache 2456 0.00 0.77 gc current block 2-way 886 0.00 0.12 cell single block physical read: flash cache 52 0.00 0.03 latch: cache buffers chains 1 0.00 0.00 enq: TS - contention 1 0.00 0.00 gc current grant 2-way 2 0.00 0.00 log file sync 1 0.00 0.00 SQL*Net break/reset to client 1 0.00 0.00 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** declare error boolean; st_syn_detected EXCEPTION; PRAGMA EXCEPTION_INIT(st_syn_detected, -995); BEGIN if((sys.dbms_standard.dictionary_obj_type!='SYNONYM')or(sys.dbms_standard.dictionary_obj_owner!='PUBLIC')) then return; end if; error := CASE sys.dbms_standard.dictionary_obj_name WHEN 'ST_GEOMETRY' THEN TRUE WHEN 'ST_SURFACE' THEN TRUE WHEN 'ST_POLYGON' THEN TRUE WHEN 'ST_POINT' THEN TRUE WHEN 'ST_MULTISURFACE' THEN TRUE WHEN 'ST_MULTIPOINT' THEN TRUE WHEN 'ST_MULTILINESTRING' THEN TRUE WHEN 'ST_MULTICURVE' THEN TRUE WHEN 'ST_LINESTRING' THEN TRUE WHEN 'ST_GEOMCOLLECTION' THEN TRUE WHEN 'ST_CURVE' THEN TRUE WHEN 'ST_CURVEPOLYGON' THEN TRUE WHEN 'ST_COMPOUNDCURVE' THEN TRUE WHEN 'ST_CIRCULARSTRING' THEN TRUE WHEN 'ST_INTERSECTS' THEN TRUE WHEN 'ST_RELATE' THEN TRUE WHEN 'ST_TOUCH' THEN TRUE WHEN 'ST_CONTAINS' THEN TRUE WHEN 'ST_COVERS' THEN TRUE WHEN 'ST_COVEREDBY' THEN TRUE WHEN 'ST_INSIDE' THEN TRUE WHEN 'ST_OVERLAP' THEN TRUE WHEN 'ST_OVERLAPS' THEN TRUE WHEN 'ST_EQUAL' THEN TRUE WHEN 'ST_OVERLAPBDYDISJOINT' THEN TRUE WHEN 'ST_OVERLAPBDYINTERSECT' THEN TRUE WHEN 'ST_GEOMETRY_ARRAY' THEN TRUE WHEN 'ST_POINT_ARRAY' THEN TRUE WHEN 'ST_CURVE_ARRAY' THEN TRUE WHEN 'ST_SURFACE_ARRAY' THEN TRUE WHEN 'ST_LINESTRING_ARRAY' THEN TRUE WHEN 'ST_POLYGON_ARRAY' THEN TRUE ELSE FALSE END; if(error) then raise st_syn_detected; end if; END; call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 1 Misses in library cache during parse: 0 Optimizer mode: ALL_ROWS Parsing user id: 93 (recursive depth: 1) ******************************************************************************** SQL ID: acmvv4fhdc9zh Plan Hash: 813480514 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, nvl(dflcollid, 16382), creappid, creverid, modappid, modverid, crepatchid, modpatchid 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 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: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 77mtwmnd4c4pk Plan Hash: 1589386835 select obj# from objerror$ 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 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 2 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS STORAGE FULL OBJERROR$ (cr=2 pr=1 pw=0 time=265 us starts=1 cost=2 size=13 card=1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ cell single block physical read: RDMA 1 0.00 0.00 ******************************************************************************** SQL ID: ac805sb6btmg3 Plan Hash: 663321076 select obj#, owner, node from syn$ where name=:1 and owner=: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 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED SYN$ (cr=2 pr=0 pw=0 time=21 us starts=1 cost=2 size=38 card=1) 0 0 0 INDEX RANGE SCAN I_SYN2 (cr=2 pr=0 pw=0 time=19 us starts=1 cost=1 size=0 card=1)(object id 104) ******************************************************************************** SQL ID: 3c32a4bk574vp Plan Hash: 3139037929 select d.sumobj# from sys.sumdetail$ d, sys.sum$ s where d.sumobj# = s.obj# and bitand(d.flags, 2) = 2 and bitand(s.xpflags, 34359738368) = 34359738368 and d.detailobj# = :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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 HASH JOIN (cr=1 pr=0 pw=0 time=32 us starts=1 cost=1 size=65 card=1) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=25 us starts=1 cost=1 size=65 card=1) 0 0 0 NESTED LOOPS (cr=1 pr=0 pw=0 time=23 us starts=1 cost=1 size=65 card=1) 0 0 0 STATISTICS COLLECTOR (cr=1 pr=0 pw=0 time=22 us starts=1) 0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED SUMDETAIL$ (cr=1 pr=0 pw=0 time=8 us starts=1 cost=1 size=39 card=1) 0 0 0 INDEX RANGE SCAN I_SUMDETAIL$_2 (cr=1 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 1257) 0 0 0 INDEX UNIQUE SCAN I_SUM$_1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 1254) 0 0 0 TABLE ACCESS BY INDEX ROWID SUM$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=26 card=1) 0 0 0 TABLE ACCESS STORAGE FULL SUM$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=26 card=1) ******************************************************************************** SQL ID: arxwfzs160xzf Plan Hash: 0 insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status, remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2,spare3, signature, spare7, spare8, spare9, dflcollid, creappid, creverid, modappid, modverid, crepatchid, modpatchid) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18, :19,:20,:21, :22,decode(:23,0,null,:23),:24,:25,:26,:27,:28,:29) 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 14 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 14 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: bajr90ryjd2w8 Plan Hash: 2574219287 update con$ set con#=:3,spare1=:4 where owner#=:1 and name=:2 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 2 6 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 2 6 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ KJC: Wait for msg sends to complete 1 0.00 0.00 ******************************************************************************** SQL ID: 7ub921xztd5pt Plan Hash: 2367994939 select con#,spare1 from con$ where owner#=:1 and name=:2 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 8nhg2pdrzs3ww Plan Hash: 0 insert into con$(owner#,name,con#,spare1) values (:1,:2,:3,:4) 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 5 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 5 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: 0b639nx4zdzxr Plan Hash: 2321277860 select domain# from sys.im_domain$ where objn = :1 and col# = :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 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: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 0 0 0 TABLE ACCESS BY INDEX ROWID IM_DOMAIN$ (cr=1 pr=0 pw=0 time=7 us starts=1 cost=0 size=39 card=1) 0 0 0 INDEX UNIQUE SCAN IM_DOMAIN_UK (cr=1 pr=0 pw=0 time=6 us starts=1 cost=0 size=0 card=1)(object id 10547) ******************************************************************************** SQL ID: 0ddc2xdhm58jp Plan Hash: 2137499963 SELECT distinct TBL$OR$IDX$PART$NUM("FINTELLIX_BANKING_DATAHUB"."FCT_LIMIT_DE TAIL", 0, 1, 0, "PERIOD_ID") FROM (SELECT "FCT_CURRENCY_RATE"."PERIOD_ID" "PERIOD_ID" FROM "FINTELLIX_BANKING_DATAHUB"."FCT_CURRENCY_RATE" "FCT_CURRENCY_RATE" WHERE "FCT_CURRENCY_RATE"."PERIOD_ID"=20240630) ORDER BY 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.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 117 (recursive depth: 1) Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT UNIQUE (cr=3 pr=0 pw=0 time=103 us starts=1 cost=4 size=6 card=1) 55 55 55 INDEX RANGE SCAN PK_FCTCURRENCYRATE (cr=3 pr=0 pw=0 time=23 us starts=1 cost=3 size=312 card=52)(object id 5213240) ******************************************************************************** SQL ID: 9tgj4g8y4rwy8 Plan Hash: 3755742892 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0), NVL(scanhint,0),NVL(bitmapranges,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 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: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** SQL ID: g7mt7ptq286u7 Plan Hash: 0 insert into seg$ (file#,block#,type#,ts#,blocks,extents,minexts,maxexts, extsize,extpct,user#,iniexts,lists,groups,cachehint,hwmincr, spare1, scanhint, bitmapranges) values (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,DECODE(:17,0,NULL, :17),:18,:19) 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 17 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 4 17 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ KJC: Wait for msg sends to complete 1 0.00 0.00 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.30 0.34 0 9 0 0 Execute 1 92.44 99.48 40579 9136899 34 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 92.74 99.82 40579 9136908 34 0 Misses in library cache during parse: 1 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 2 4.15 4.15 PGA memory operation 132 0.00 0.00 library cache lock 1 0.00 0.00 library cache pin 1 0.00 0.00 gc current block 2-way 886 0.00 0.12 DLM cross inst call completion 12 0.00 0.00 row cache lock 4 0.00 0.00 KJC: Wait for msg sends to complete 4 0.00 0.00 cell single block physical read: RDMA 4355 0.00 0.30 reliable message 1 0.00 0.00 enq: KO - fast object checkpoint 2 0.00 0.00 cell smart table scan 119 0.02 0.03 gc cr grant 2-way 484 0.00 0.06 cell single block physical read: pmem cache 2456 0.00 0.77 cell single block physical read: flash cache 52 0.00 0.03 latch: cache buffers chains 1 0.00 0.00 enq: TS - contention 1 0.00 0.00 gc current grant 2-way 2 0.00 0.00 log file sync 1 0.00 0.00 SQL*Net break/reset to client 1 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 28 0.01 0.01 0 0 0 0 Execute 209 0.07 0.07 0 6 42 6 Fetch 206 0.00 0.00 1 115 0 185 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 443 0.08 0.09 1 121 42 191 Misses in library cache during parse: 17 Misses in library cache during execute: 16 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 24 0.00 0.00 library cache lock 2 0.00 0.00 library cache pin 2 0.00 0.00 gc cr block 2-way 2 0.00 0.00 gc current block 2-way 1 0.00 0.00 cell single block physical read: RDMA 1 0.00 0.00 3 user SQL statements in session. 29 internal SQL statements in session. 32 SQL statements in session. ******************************************************************************** Trace file: finprod1_ora_117631_RC_MCB_SUP0400_LIMIT_CARDS.trc Trace file compatibility: 12.2.0.0 Sort options: default 1 session in tracefile. 3 user SQL statements in trace file. 29 internal SQL statements in trace file. 32 SQL statements in trace file. 29 unique SQL statements in trace file. 12642 lines in trace file. 99 elapsed seconds in trace file.