
TKPROF: Release 21.0.0.0.0 - Development on Sun Jun 18 15:55:49 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_3510.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: 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: 0
Optimizer mode: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
         1          1          1  SORT AGGREGATE (cr=6 pr=0 pw=0 time=67 us starts=1)
         5          5          5   TABLE ACCESS FULL SYS_FBA_DDL_COLMAP_26338 (cr=6 pr=0 pw=0 time=59 us starts=1 cost=3 size=0 card=3)

********************************************************************************

SQL ID: 2syvqzbxp4k9z Plan Hash: 533170135

select u.name, o.name, a.interface_version#, o.obj#      
from
 association$ a, user$ u, obj$ o                     where a.obj# = :1        
                                    and a.property = :2                       
                 and a.statstype# = o.obj#                                and 
  u.user# = o.owner#


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        6      0.00       0.00          0          0          0           0
Execute      6      0.00       0.00          0          0          0           0
Fetch        6      0.00       0.00          0         12          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       18      0.00       0.00          0         12          0           0

Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
         0          0          0  HASH JOIN  (cr=2 pr=0 pw=0 time=39 us starts=1 cost=5 size=62 card=1)
         0          0          0   NESTED LOOPS  (cr=2 pr=0 pw=0 time=35 us starts=1 cost=5 size=62 card=1)
         0          0          0    STATISTICS COLLECTOR  (cr=2 pr=0 pw=0 time=33 us starts=1)
         0          0          0     HASH JOIN  (cr=2 pr=0 pw=0 time=26 us starts=1 cost=4 size=44 card=1)
         0          0          0      NESTED LOOPS  (cr=2 pr=0 pw=0 time=26 us starts=1 cost=4 size=44 card=1)
         0          0          0       STATISTICS COLLECTOR  (cr=2 pr=0 pw=0 time=26 us starts=1)
         0          0          0        TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=24 us starts=1 cost=2 size=16 card=1)
         0          0          0       TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=28 card=1)
         0          0          0        INDEX RANGE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=0 card=1)(object id 36)
         0          0          0      INDEX FAST FULL SCAN I_OBJ2 (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=28 card=1)(object id 37)
         0          0          0    TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)
         0          0          0     INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us starts=0 cost=0 size=0 card=1)(object id 11)
         0          0          0   TABLE ACCESS FULL USER$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=1 size=18 card=1)

********************************************************************************

SQL ID: 2xyb5d6xg9srh Plan Hash: 785096182

select a.default_cpu_cost, a.default_io_cost             
from
 association$ a                                      where a.obj# = :1        
                                    and a.property = :2


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        6      0.00       0.00          0          0          0           0
Execute      6      0.00       0.00          0          0          0           0
Fetch        6      0.00       0.00          0         12          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       18      0.00       0.00          0         12          0           0

Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
         0          0          0  TABLE ACCESS FULL ASSOCIATION$ (cr=2 pr=0 pw=0 time=16 us starts=1 cost=2 size=18 card=1)

********************************************************************************

SQL ID: 476v06tzdhkhc Plan Hash: 3966719185

select HISTORICAL_COLUMN_NAME, COLUMN_NAME 
from
 "USR".SYS_FBA_DDL_COLMAP_26338 where (STARTSCN<=
  TIMESTAMP_TO_SCN(systimestamp-1/24+21/24/60) or STARTSCN is NULL) and 
  (ENDSCN > TIMESTAMP_TO_SCN(systimestamp-1/24+21/24/60) 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=13 pr=0 pw=0 time=1075 us starts=1 cost=4 size=20 card=1)
         3          3          3   TABLE ACCESS FULL SYS_FBA_DDL_COLMAP_26338 (cr=13 pr=0 pw=0 time=1061 us starts=1 cost=3 size=20 card=1)

********************************************************************************

SQL ID: 4jrkd9ymavb8x Plan Hash: 3631124065

select max(time_mp) 
from
 smon_scn_time


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       20      0.00       0.00          0          0          0           0
Execute     20      0.00       0.00          0          0          0           0
Fetch       20      0.00       0.00          0         20          0          20
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       60      0.00       0.00          0         20          0          20

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
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=1 pr=0 pw=0 time=19 us starts=1)
         1          1          1   INDEX FULL SCAN (MIN/MAX) SMON_SCN_TIME_TIM_IDX (cr=1 pr=0 pw=0 time=12 us starts=1 cost=1 size=7 card=1)(object id 424)

********************************************************************************

SQL ID: 2ajc7pwz9jsx3 Plan Hash: 2536448058

select max(scn) 
from
 smon_scn_time


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        2      0.00       0.00          0          0          0           0
Execute      2      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.00          0          2          0           2
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.00       0.00          0          2          0           2

Misses in library cache during parse: 0
Optimizer mode: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
         1          1          1  SORT AGGREGATE (cr=1 pr=0 pw=0 time=12 us starts=1)
         1          1          1   INDEX FULL SCAN (MIN/MAX) SMON_SCN_TIME_SCN_IDX (cr=1 pr=0 pw=0 time=6 us starts=1 cost=1 size=6 card=1)(object id 425)

********************************************************************************

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                           75        0.00          0.00
********************************************************************************

SQL ID: 36g2pydn13abk Plan Hash: 2739728740

select * 
from
 TAB2 as of timestamp systimestamp-1/24+21/24/60 where N1=1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.00          0        109          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=123 pr=0 pw=0 time=1775 us starts=1 cost=282 size=58 card=2)
         1          1          1   UNION-ALL  (cr=123 pr=0 pw=0 time=1772 us starts=1)
         1          1          1    FILTER  (cr=112 pr=0 pw=0 time=1769 us starts=1)
         1          1          1     PARTITION RANGE SINGLE PARTITION: 1 1 (cr=111 pr=0 pw=0 time=1530 us starts=1 cost=274 size=29 card=1)
         1          1          1      TABLE ACCESS FULL SYS_FBA_HIST_26338 PARTITION: 1 1 (cr=111 pr=0 pw=0 time=1526 us starts=1 cost=274 size=29 card=1)
         0          0          0    FILTER  (cr=11 pr=0 pw=0 time=410 us starts=1)
         1          1          1     NESTED LOOPS OUTER (cr=10 pr=0 pw=0 time=245 us starts=1 cost=8 size=44 card=1)
         1          1          1      TABLE ACCESS FULL TAB2 (cr=7 pr=0 pw=0 time=215 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=20 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=7 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                            3        0.00          0.00
  SQL*Net message to client                       2        0.00          0.00
  SQL*Net message from client                     2        2.20          2.20



********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.00          0        109          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        5.67          7.88
  PGA memory operation                            3        0.00          0.00


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       36      0.00       0.00          0          0          0           0
Execute     37      0.00       0.00          0          0          0           0
Fetch       40      0.00       0.00          0         60          0          27
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      113      0.01       0.01          0         60          0          27

Misses in library cache during parse: 1

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  PGA memory operation                           75        0.00          0.00

    1  user  SQL statements in session.
    7  internal SQL statements in session.
    8  SQL statements in session.
********************************************************************************
Trace file: /app/oracle/base/admin/SITHPRD/diag/rdbms/sithprd/SITHPRD/trace/SITHPRD_ora_3510.trc
Trace file compatibility: 12.2.0.0
Sort options: default

       1  session in tracefile.
       1  user  SQL statements in trace file.
       7  internal SQL statements in trace file.
       8  SQL statements in trace file.
       8  unique SQL statements in trace file.
     509  lines in trace file.
       2  elapsed seconds in trace file.


