TKPROF: Release 21.0.0.0.0 - Development on Sun Jun 18 15:33:28 2023 Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved. Trace file: /app/oracle/base/admin/SITHPRD/diag/rdbms/sithprd/SITHPRD/trace/SITHPRD_ora_3396.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: 2ajc7pwz9jsx3 Plan Hash: 2536448058 select max(scn) from smon_scn_time call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 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 3 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 3 0 3 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Number of plan statistics captured: 3 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 SORT AGGREGATE (cr=1 pr=0 pw=0 time=20 us starts=1) 1 1 1 INDEX FULL SCAN (MIN/MAX) SMON_SCN_TIME_SCN_IDX (cr=1 pr=0 pw=0 time=12 us starts=1 cost=1 size=6 card=1)(object id 425) ******************************************************************************** SQL ID: 41dzdw7ca24a1 Plan Hash: 1159443182 select count(*) from "USR".SYS_FBA_DDL_COLMAP_26338 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: 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 SORT AGGREGATE (cr=6 pr=0 pw=0 time=95 us starts=1) 5 5 5 TABLE ACCESS FULL SYS_FBA_DDL_COLMAP_26338 (cr=6 pr=0 pw=0 time=92 us starts=1 cost=3 size=0 card=3) ******************************************************************************** SQL ID: 15fqvf9xff3hm Plan Hash: 3966719185 select HISTORICAL_COLUMN_NAME, COLUMN_NAME from "USR".SYS_FBA_DDL_COLMAP_26338 where (STARTSCN<=4336404 or STARTSCN is NULL) and (ENDSCN > 4336404 or ENDSCN is NULL) order by STARTSCN, ROWID call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 6 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 3 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 ---------- ---------- ---------- --------------------------------------------------- 3 3 3 SORT ORDER BY (cr=6 pr=0 pw=0 time=61 us starts=1 cost=4 size=60 card=3) 3 3 3 TABLE ACCESS FULL SYS_FBA_DDL_COLMAP_26338 (cr=6 pr=0 pw=0 time=42 us starts=1 cost=3 size=60 card=3) ******************************************************************************** SQL ID: 5ty7pv13y930m 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 and (cols_range is null and length(:4) = 0 or cols_range is not null and cols_range = dbms_auto_index_internal.merge_cols_str(cols_range, :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 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 2 0 1 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 67 0.00 0.00 ******************************************************************************** SQL ID: g0181my81qz4x Plan Hash: 303836101 select * from TAB2 as of scn 4336404 where N1=1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 16 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 93 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.01 0 109 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 84 Number of plan statistics captured: 1 Rows (1st) Rows (avg) Rows (max) Row Source Operation ---------- ---------- ---------- --------------------------------------------------- 1 1 1 VIEW (cr=110 pr=0 pw=0 time=102 us starts=1 cost=282 size=58 card=2) 1 1 1 UNION-ALL (cr=110 pr=0 pw=0 time=100 us starts=1) 1 1 1 PARTITION RANGE SINGLE PARTITION: 1 1 (cr=100 pr=0 pw=0 time=100 us starts=1 cost=274 size=29 card=1) 1 1 1 TABLE ACCESS FULL SYS_FBA_HIST_26338 PARTITION: 1 1 (cr=100 pr=0 pw=0 time=94 us starts=1 cost=274 size=29 card=1) 0 0 0 FILTER (cr=10 pr=0 pw=0 time=571 us starts=1) 1 1 1 NESTED LOOPS OUTER (cr=10 pr=0 pw=0 time=571 us starts=1 cost=8 size=44 card=1) 1 1 1 TABLE ACCESS FULL TAB2 (cr=7 pr=0 pw=0 time=528 us starts=1 cost=6 size=16 card=1) 1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED SYS_FBA_TCRV_26338 (cr=3 pr=0 pw=0 time=24 us starts=1 cost=2 size=28 card=1) 3 3 3 INDEX RANGE SCAN SYS_FBA_TCRV_IDX1_26338 (cr=1 pr=0 pw=0 time=8 us starts=1 cost=1 size=0 card=1)(object id 26344) 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*Net message to client 2 0.00 0.00 SQL*Net message from client 2 12.15 12.16 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 16 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 93 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.01 0 109 0 1 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 3 47.08 59.24 PGA memory operation 4 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 9 0.00 0.00 0 17 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20 0.00 0.00 0 17 0 8 Misses in library cache during parse: 3 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PGA memory operation 67 0.00 0.00 1 user SQL statements in session. 6 internal SQL statements in session. 7 SQL statements in session. ******************************************************************************** Trace file: /app/oracle/base/admin/SITHPRD/diag/rdbms/sithprd/SITHPRD/trace/SITHPRD_ora_3396.trc Trace file compatibility: 12.2.0.0 Sort options: default 1 session in tracefile. 1 user SQL statements in trace file. 6 internal SQL statements in trace file. 7 SQL statements in trace file. 5 unique SQL statements in trace file. 218 lines in trace file. 12 elapsed seconds in trace file.