TKPROF: Release 19.0.0.0.0 - Development on Tue Nov 1 18:15:03 2022
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Trace file: backdbpp1_ora_2986367_ERICNORMAL.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: 6m60pcnk9jt5c Plan Hash: 821094412
SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE
RESULT_CACHE(SNAPSHOT=3600) opt_param('parallel_execution_enabled', 'false')
NO_PARALLEL(SAMPLESUB) NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */
NVL(SUM(C1),:"SYS_B_00"), NVL(SUM(C2),:"SYS_B_01")
FROM
(SELECT /*+ IGNORE_WHERE_CLAUSE */ :"SYS_B_02" AS C1, CASE WHEN
"AUDITMESSA0_"."SA_ID"=:"SYS_B_03" AND "AUDITMESSA0_"."EVENT_TIME">=
TIMESTAMP:"SYS_B_04" AND "AUDITMESSA0_"."EVENT_TIME"<TIMESTAMP:"SYS_B_05"
THEN :"SYS_B_06" ELSE :"SYS_B_07" END AS C2 FROM (SELECT /*+
NO_PARALLEL("AUDITMESSA0_") FULL("AUDITMESSA0_")
NO_PARALLEL_INDEX("AUDITMESSA0_") */ * FROM
"AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" SAMPLE BLOCK (:"SYS_B_08" ,
:"SYS_B_09") SEED (:"SYS_B_10") "AUDITMESSA0_" WHERE
TBL$OR$IDX$PART$NUM("AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST",:"SYS_B_11",
:"SYS_B_12",:"SYS_B_13",ROWID) IN (:"SYS_B_14",:"SYS_B_15",:"SYS_B_16",
:"SYS_B_17",:"SYS_B_18",:"SYS_B_19",:"SYS_B_20",:"SYS_B_21",:"SYS_B_22",
:"SYS_B_23",:"SYS_B_24",:"SYS_B_25",:"SYS_B_26",:"SYS_B_27"))
"AUDITMESSA0_") SAMPLESUB
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 0 0 1
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 377 (recursive depth: 1)
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
1 1 1 RESULT CACHE gjtjgbbsytf8f7w9xb8x11k35w (cr=0 pr=0 pw=0 time=16 us starts=1)
0 0 0 SORT AGGREGATE (cr=0 pr=0 pw=0 time=0 us starts=0)
0 0 0 PARTITION COMBINED ITERATOR PARTITION: KEY KEY (cr=0 pr=0 pw=0 time=0 us starts=0 cost=130 size=102871556 card=3025634)
0 0 0 TABLE ACCESS SAMPLE AUDIT_MESSAGETEST PARTITION: KEY KEY (cr=0 pr=0 pw=0 time=0 us starts=0 cost=130 size=102871556 card=3025634)
********************************************************************************
select auditmessa0_.id as id1_0_,
auditmessa0_.additions as additions2_0_,
auditmessa0_.emulator_domain as emulator_domain3_0_,
auditmessa0_.emulator_user_id as emulator_user_id4_0_,
auditmessa0_.emulator_username as emulator_username5_0_,
auditmessa0_.error as error6_0_,
auditmessa0_.event_action as event_action7_0_,
auditmessa0_.event_category as event_category8_0_,
auditmessa0_.event_desc as event_desc9_0_,
auditmessa0_.metadata as metadata10_0_,
auditmessa0_.ip_address as ip_address11_0_,
auditmessa0_.legal_entity_id as legal_entity_id12_0_,
auditmessa0_.message_set_id as message_set_id13_0_,
auditmessa0_.object_type as object_type14_0_,
auditmessa0_.schema_version as schema_version15_0_,
auditmessa0_.sa_id as sa_id16_0_,
auditmessa0_.status as status17_0_,
auditmessa0_.temp_legacy_id as temp_legacy_id18_0_,
auditmessa0_.event_time as event_time19_0_,
auditmessa0_.user_agent as user_agent20_0_,
auditmessa0_.actor_user_id as actor_user_id21_0_,
auditmessa0_.actor_username as actor_username22_0_
from audit_messagetest auditmessa0_
where auditmessa0_.event_time >= to_timestamp('Jan 01 09:40:08 2022', 'Mon DD HH:MI:SS YYYY')
and auditmessa0_.event_time < to_timestamp('Oct 23 09:40:09 2022', 'Mon DD HH:MI:SS YYYY')
and auditmessa0_.sa_id = '8a00861780ce9dba0180fe6e971c058c'
order by auditmessa0_.event_time desc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 64 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 67 0.00 0.00 0 511 0 66
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 69 0.01 0.01 0 575 0 66
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 377
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
66 66 66 PARTITION RANGE ITERATOR PARTITION: 203 194 (cr=511 pr=0 pw=0 time=903 us starts=1 cost=687 size=44639 card=49)
66 66 66 SORT ORDER BY (cr=511 pr=0 pw=0 time=3767 us starts=10 cost=687 size=44639 card=49)
66 66 66 PARTITION HASH ALL PARTITION: 32 1 (cr=511 pr=0 pw=0 time=3572 us starts=10 cost=686 size=44639 card=49)
66 66 66 TABLE ACCESS BY LOCAL INDEX ROWID BATCHED AUDIT_MESSAGETEST PARTITION: 6496 6177 (cr=511 pr=0 pw=0 time=3512 us starts=320 cost=686 size=44639 card=49)
66 66 66 INDEX RANGE SCAN INDTEST PARTITION: 6496 6177 (cr=448 pr=0 pw=0 time=2396 us starts=320 cost=641 size=0 card=49)(object id 214568)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 68 0.00 0.00
SQL*Net message from client 68 4.75 4.95
********************************************************************************
SQL ID: 7cfz5wy9caaf4 Plan Hash: 4015672053
SELECT NAME NAME_COL_PLUS_SHOW_PARAM,DECODE(TYPE,1,'boolean',2,'string',3,
'integer',4,'file',5,'number', 6,'big integer', 'unknown') TYPE,
DISPLAY_VALUE VALUE_COL_PLUS_SHOW_PARAM
FROM
V$PARAMETER WHERE UPPER(NAME) LIKE UPPER(:NMBIND_SHOW_OBJ) ORDER BY
NAME_COL_PLUS_SHOW_PARAM,ROWNUM
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 0 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 0 0 6
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 377
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
6 6 6 SORT ORDER BY (cr=0 pr=0 pw=0 time=7657 us starts=1 cost=2 size=59 card=1)
6 6 6 COUNT (cr=0 pr=0 pw=0 time=7543 us starts=1)
6 6 6 HASH JOIN (cr=0 pr=0 pw=0 time=7533 us starts=1 cost=1 size=59 card=1)
85 85 85 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=3536 us starts=1 cost=1 size=574 card=14)
5412 5412 5412 FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=3747 us starts=1 cost=1 size=97416 card=5412)
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
PGA memory operation 9 0.00 0.00
SQL*Net message from client 2 0.79 0.80
********************************************************************************
SQL ID: 0bzyrc5yb4m22 Plan Hash: 0
insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,
userhost,terminal,action#,returncode, logoff$lread,logoff$pread,
logoff$lwrite,logoff$dead, logoff$time,comment$text,spare1,clientid,
sessioncpu,proxy$sid,user$guid, instance#,process#,auditid,dbid,
current_user)
values
(:1,:2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,
:12, cast(SYS_EXTRACT_UTC(systimestamp) as date),:13,:14,:15,:16,:17,
:18, :19,:20,:21,:22,:23)
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 4 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 4 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
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL AUD$ (cr=0 pr=0 pw=0 time=231 us starts=1)
********************************************************************************
SQL ID: b3853arjnybzv Plan Hash: 0
INSERT INTO AUDSYS.AUD$UNIFIED (AUDIT_TYPE, SESSIONID, PROXY_SESSIONID,
OS_USER, HOST_NAME, TERMINAL, INSTANCE_ID, DBID, AUTHENTICATION_TYPE,
USERID, PROXY_USERID, EXTERNAL_USERID, GLOBAL_USERID, CLIENT_PROGRAM_NAME,
DBLINK_INFO, XS_USER_NAME, XS_SESSIONID, ENTRY_ID, STATEMENT_ID,
EVENT_TIMESTAMP, ACTION, RETURN_CODE, OS_PROCESS, TRANSACTION_ID, SCN,
EXECUTION_ID, OBJ_OWNER, OBJ_NAME, CLIENT_IDENTIFIER, NEW_OWNER, NEW_NAME,
OBJECT_EDITION, SYSTEM_PRIVILEGE_USED, SYSTEM_PRIVILEGE, AUDIT_OPTION,
OBJECT_PRIVILEGES, ROLE, TARGET_USER, EXCLUDED_USER, EXCLUDED_SCHEMA,
EXCLUDED_OBJECT, CURRENT_USER, ADDITIONAL_INFO, UNIFIED_AUDIT_POLICIES)
values
(:AUDIT_TYPE, :SESSIONID, :PROXY_SESSIONID, :OS_USER, :HOST_NAME, :TERMINAL,
:INSTANCE_ID, :DBID, :AUTHENTICATION_TYPE, :USERID, :PROXY_USERID,
:EXTERNAL_USERID, :GLOBAL_USERID, :CLIENT_PROGRAM_NAME, :DBLINK_INFO,
:XS_USER_NAME, :XS_SESSIONID, :ENTRY_ID, :STATEMENT_ID, :EVENT_TIMESTAMP,
:ACTION, :RETURN_CODE, :OS_PROCESS, :TRANSACTION_ID, :SCN, :EXECUTION_ID,
:OBJ_OWNER, :OBJ_NAME, :CLIENT_IDENTIFIER, :NEW_OWNER, :NEW_NAME,
:OBJECT_EDITION, :SYSTEM_PRIVILEGE_USED, :SYSTEM_PRIVILEGE, :AUDIT_OPTION,
:OBJECT_PRIVILEGES, :ROLE, :TARGET_USER, :EXCLUDED_USER, :EXCLUDED_SCHEMA,
:EXCLUDED_OBJECT, :CURRENT_USER, :ADDITIONAL_INFO, :UNIFIED_AUDIT_POLICIES)
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 1 6 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 0 1 6 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
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL AUD$UNIFIED (cr=1 pr=0 pw=0 time=214 us starts=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 6 0.00 0.00
log file sync 1 0.00 0.00
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 64 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 69 0.01 0.01 0 511 0 72
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 73 0.01 0.02 0 575 0 72
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 125 0.00 0.00
SQL*Net message from client 125 4.75 10.98
PGA memory operation 15 0.00 0.00
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 0.00 0 0 0 0
Execute 3 0.00 0.00 0 1 10 2
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 6 0.00 0.00 0 1 10 3
Misses in library cache during parse: 0
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
log file sync 1 0.00 0.00
3 user SQL statements in session.
2 internal SQL statements in session.
5 SQL statements in session.
********************************************************************************
Trace file: backdbpp1_ora_2986367_ERICNORMAL.trc
Trace file compatibility: 12.2.0.0
Sort options: default
1 session in tracefile.
3 user SQL statements in trace file.
2 internal SQL statements in trace file.
5 SQL statements in trace file.
5 unique SQL statements in trace file.
506 lines in trace file.
6 elapsed seconds in trace file.
[oracle@ORAX8PPD1 trace]$