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: 44s2u9vmxqzhy 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"), NVL(SUM(C3),:"SYS_B_02")
FROM
(SELECT /*+ IGNORE_WHERE_CLAUSE */ :"SYS_B_03" AS C1, CASE WHEN
LOWER("AUDITMESSA0_"."SA_ID")=:"SYS_B_04" AND "AUDITMESSA0_"."EVENT_TIME">=
TIMESTAMP:"SYS_B_05" AND "AUDITMESSA0_"."EVENT_TIME"<TIMESTAMP:"SYS_B_06"
THEN :"SYS_B_07" ELSE :"SYS_B_08" END AS C2, CASE WHEN
LOWER("AUDITMESSA0_"."SA_ID")=:"SYS_B_09" THEN :"SYS_B_10" ELSE :"SYS_B_11"
END AS C3 FROM (SELECT /*+ NO_PARALLEL("AUDITMESSA0_") FULL("AUDITMESSA0_")
NO_PARALLEL_INDEX("AUDITMESSA0_") */ * FROM
"AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST" SAMPLE BLOCK (:"SYS_B_12" ,
:"SYS_B_13") SEED (:"SYS_B_14") "AUDITMESSA0_" WHERE
TBL$OR$IDX$PART$NUM("AUDIT_PERSISTENCE"."AUDIT_MESSAGETEST",:"SYS_B_15",
:"SYS_B_16",:"SYS_B_17",ROWID) IN (:"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",:"SYS_B_28",:"SYS_B_29",:"SYS_B_30",:"SYS_B_31"))
"AUDITMESSA0_") SAMPLESUB
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 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
Misses in library cache during execute: 1
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 f21vya5dv5vxxg6wmxy5qfbmkt (cr=0 pr=0 pw=0 time=14 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)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 13 0.00 0.00
********************************************************************************
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 lower(sa_id) = '8a00861780ce9dba0180fe6e971c058c'
order by auditmessa0_.event_time desc
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.01 0.02 0 64 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 134 0.01 0.03 69 1022 0 132
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 138 0.03 0.05 69 1086 0 132
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 377
Number of plan statistics captured: 2
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
66 66 66 PARTITION RANGE ITERATOR PARTITION: 203 194 (cr=511 pr=34 pw=0 time=4072 us starts=1 cost=687 size=44639 card=49)
66 66 66 SORT ORDER BY (cr=511 pr=34 pw=0 time=14386 us starts=10 cost=687 size=44639 card=49)
66 66 66 PARTITION HASH ALL PARTITION: 32 1 (cr=511 pr=34 pw=0 time=23832 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=34 pw=0 time=27684 us starts=320 cost=686 size=44639 card=49)
66 66 66 INDEX RANGE SCAN INDTEST PARTITION: 6496 6177 (cr=448 pr=3 pw=0 time=7574 us starts=320 cost=641 size=0 card=49)(object id 212946)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 5 0.00 0.00
SQL*Net message to client 136 0.00 0.00
SQL*Net message from client 143 30.54 247.31
db file sequential read 8 0.00 0.00
gc cr grant 2-way 4 0.00 0.00
gc cr multi block grant 2 0.00 0.00
db file parallel read 2 0.00 0.00
gc current grant busy 2 0.00 0.00
********************************************************************************
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.03 0.06 0 0 0 0
Fetch 2 0.00 0.00 0 0 0 6
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.04 0.07 0 0 0 6
Misses in library cache during parse: 1
Misses in library cache during execute: 1
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=7008 us starts=1 cost=2 size=59 card=1)
6 6 6 COUNT (cr=0 pr=0 pw=0 time=6976 us starts=1)
6 6 6 HASH JOIN (cr=0 pr=0 pw=0 time=6971 us starts=1 cost=1 size=59 card=1)
85 85 85 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=3560 us starts=1 cost=1 size=574 card=14)
5412 5412 5412 FIXED TABLE FULL X$KSPPCV (cr=0 pr=0 pw=0 time=1940 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 ---------- ------------
PGA memory operation 6 0.00 0.00
SQL*Net message to client 2 0.00 0.00
SQL*Net message from client 2 0.63 0.63
********************************************************************************
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 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 4 7 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 0.00 0.01 4 7 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
---------- ---------- ---------- ---------------------------------------------------
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=3 pr=1 pw=0 time=3074 us starts=1 cost=4 size=113 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ2 (cr=3 pr=1 pw=0 time=3071 us starts=1 cost=3 size=0 card=1)(object id 37)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 4 0.00 0.00
Disk file operations I/O 1 0.00 0.00
gc current block 2-way 2 0.00 0.00
gc cr grant 2-way 3 0.00 0.00
db file sequential read 4 0.00 0.00
********************************************************************************
SQL ID: 1mjd9xp80vuqa Plan Hash: 3023518864
select node,owner,name
from
syn$ where 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 1 0.00 0.00 2 3 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 2 3 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 BY INDEX ROWID SYN$ (cr=3 pr=2 pw=0 time=1897 us starts=1 cost=2 size=38 card=1)
1 1 1 INDEX UNIQUE SCAN I_SYN1 (cr=2 pr=1 pw=0 time=1403 us starts=1 cost=1 size=0 card=1)(object id 103)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
gc cr grant 2-way 1 0.00 0.00
db file sequential read 2 0.00 0.00
gc current block 2-way 1 0.00 0.00
********************************************************************************
SQL ID: 3un99a0zwp4vd Plan Hash: 1475428744
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#,
nvl(property,0),subname,type#,flags,d_attrs
from
dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
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 1 7 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 1 7 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 SORT ORDER BY (cr=7 pr=1 pw=0 time=3373 us starts=1 cost=15 size=700 card=5)
1 1 1 HASH JOIN OUTER (cr=7 pr=1 pw=0 time=3352 us starts=1 cost=14 size=700 card=5)
1 1 1 NESTED LOOPS OUTER (cr=7 pr=1 pw=0 time=3325 us starts=1 cost=14 size=700 card=5)
1 1 1 STATISTICS COLLECTOR (cr=4 pr=0 pw=0 time=1813 us starts=1)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED DEPENDENCY$ (cr=4 pr=0 pw=0 time=1427 us starts=1 cost=4 size=135 card=5)
1 1 1 INDEX RANGE SCAN I_DEPENDENCY1 (cr=3 pr=0 pw=0 time=942 us starts=1 cost=3 size=0 card=5)(object id 85)
1 1 1 TABLE ACCESS BY INDEX ROWID BATCHED OBJ$ (cr=3 pr=1 pw=0 time=1500 us starts=1 cost=2 size=113 card=1)
1 1 1 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=1 pw=0 time=1494 us starts=1 cost=1 size=0 card=1)(object id 36)
0 0 0 TABLE ACCESS FULL OBJ$ (cr=0 pr=0 pw=0 time=0 us starts=0 cost=2 size=113 card=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
gc current block 2-way 4 0.00 0.00
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 8swypbbr0m372 Plan Hash: 570326988
select order#,columns,types
from
access$ where d_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 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
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 ACCESS$ (cr=2 pr=1 pw=0 time=956 us starts=1 cost=3 size=150 card=6)
0 0 0 INDEX RANGE SCAN I_ACCESS1 (cr=2 pr=1 pw=0 time=954 us starts=1 cost=2 size=0 card=6)(object id 87)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: grwydz59pu6mc Plan Hash: 3684871272
select text
from
view$ where rowid=: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 1 2 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 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 BY USER ROWID VIEW$ (cr=1 pr=1 pw=0 time=1013 us starts=1 cost=1 size=15 card=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
SQL ID: 6h3cwmunz5z8q Plan Hash: 2968095032
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)),
max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16),
max(bitand(nvl(option$,0),64) /64), max(bitand(nvl(option$,0), 128) /128)
from
objauth$ where obj#=:1 and col# is not null group by privilege#, col#,
grantee# order by col#, grantee#
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 SORT GROUP BY (cr=2 pr=0 pw=0 time=1287 us starts=1 cost=4 size=16 card=1)
0 0 0 TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=2 pr=0 pw=0 time=1265 us starts=1 cost=3 size=16 card=1)
0 0 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=1262 us starts=1 cost=2 size=0 card=1)(object id 62)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
gc current block 2-way 2 0.00 0.00
********************************************************************************
SQL ID: a4n4ayr88dbhy Plan Hash: 2968095032
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)),
max(bitand(nvl(option$,0), 8) /8), max(bitand(nvl(option$,0), 16) /16),
max(bitand(nvl(option$,0),64) /64), max(bitand(nvl(option$,0), 128) /128)
from
objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by
grantee#
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 10 0.00 0.00 7 11 0 9
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 12 0.00 0.00 7 11 0 9
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
---------- ---------- ---------- ---------------------------------------------------
9 9 9 SORT GROUP BY (cr=11 pr=7 pw=0 time=4457 us starts=1 cost=4 size=16 card=1)
9 9 9 TABLE ACCESS BY INDEX ROWID BATCHED OBJAUTH$ (cr=11 pr=7 pw=0 time=10587 us starts=1 cost=3 size=16 card=1)
9 9 9 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=18 us starts=1 cost=2 size=0 card=1)(object id 62)
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
db file sequential read 1 0.00 0.00
gc cr multi block mixed 1 0.00 0.00
db file parallel read 1 0.00 0.00
********************************************************************************
SQL ID: 7nuw4xwrnuwxq Plan Hash: 1720483994
select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#,
nvl(typidcol#, 0)
from
coltype$ where obj#=:1 order by intcol# desc
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 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 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 SORT ORDER BY (cr=3 pr=0 pw=0 time=7803 us starts=1 cost=3 size=192 card=4)
0 0 0 TABLE ACCESS CLUSTER COLTYPE$ (cr=3 pr=0 pw=0 time=7794 us starts=1 cost=2 size=192 card=4)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=7237 us starts=1 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 ---------- ------------
gc current block 2-way 3 0.00 0.00
********************************************************************************
SQL ID: 9rfqm06xmuwu0 Plan Hash: 832500465
select intcol#, toid, version#, intcols, intcol#s, flags, synobj#
from
subcoltype$ where obj#=:1 order by intcol# asc
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 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 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 SORT ORDER BY (cr=3 pr=0 pw=0 time=19 us starts=1 cost=3 size=2021 card=43)
0 0 0 TABLE ACCESS CLUSTER SUBCOLTYPE$ (cr=3 pr=0 pw=0 time=14 us starts=1 cost=2 size=2021 card=43)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=9 us starts=1 cost=1 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: f3g84j69n0tjh Plan Hash: 914792125
select col#,intcol#,ntab#
from
ntab$ where obj#=:1 order by intcol# asc
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 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 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 SORT ORDER BY (cr=3 pr=0 pw=0 time=18 us starts=1 cost=3 size=28 card=2)
0 0 0 TABLE ACCESS CLUSTER NTAB$ (cr=3 pr=0 pw=0 time=13 us starts=1 cost=2 size=28 card=2)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=5 us starts=1 cost=1 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: 6qz82dptj0qr7 Plan Hash: 2819763574
select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk,
l.pctversion$, l.flags, l.property, l.retention, l.freepools
from
lob$ l where l.obj# = :1 order by l.intcol# asc
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 3 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 3 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 SORT ORDER BY (cr=3 pr=0 pw=0 time=18 us starts=1 cost=3 size=104 card=2)
0 0 0 TABLE ACCESS CLUSTER LOB$ (cr=3 pr=0 pw=0 time=12 us starts=1 cost=2 size=104 card=2)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=7 us starts=1 cost=1 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: 9g485acn2n30m Plan Hash: 3483575214
select col#,intcol#,reftyp,stabid,expctoid
from
refcon$ where obj#=:1 order by intcol# asc
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 REFCON$ (cr=1 pr=0 pw=0 time=385 us starts=1 cost=0 size=72 card=1)
0 0 0 INDEX RANGE SCAN I_REFCON2 (cr=1 pr=0 pw=0 time=383 us starts=1 cost=0 size=0 card=1)(object id 123)
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: 32bhha21dkv0v Plan Hash: 3765558045
select col#,intcol#,charsetid,charsetform
from
col$ where obj#=:1 order by intcol# asc
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 20 0.00 0.00 0 3 0 19
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 22 0.00 0.00 0 3 0 19
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
---------- ---------- ---------- ---------------------------------------------------
19 19 19 SORT ORDER BY (cr=3 pr=0 pw=0 time=42 us starts=1 cost=3 size=234 card=13)
19 19 19 TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=11 us starts=1 cost=2 size=234 card=13)
1 1 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=18 us starts=1 cost=1 size=0 card=1)(object id 3)
********************************************************************************
SQL ID: 0fr8zhn4ymu3v Plan Hash: 1231101765
select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum
from
opqtype$ where obj# = :1 order by intcol# asc
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 1 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 1 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 OPQTYPE$ (cr=1 pr=1 pw=0 time=497 us starts=1 cost=2 size=25 card=1)
0 0 0 INDEX RANGE SCAN I_OPQTYPE1 (cr=1 pr=1 pw=0 time=494 us starts=1 cost=1 size=0 card=1)(object id 125)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
db file sequential read 1 0.00 0.00
********************************************************************************
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 1 0.00 0.00 0 0 0 0
Execute 5 0.00 0.00 0 0 0 0
Fetch 5 0.00 0.00 0 10 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 11 0.00 0.00 0 10 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 OBJ$ (cr=2 pr=0 pw=0 time=32 us starts=1 cost=3 size=113 card=1)
0 0 0 INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=30 us starts=1 cost=2 size=0 card=1)(object id 36)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 6 0.00 0.00
********************************************************************************
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 1 0 4 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 1 0 4 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
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL AUD$ (cr=0 pr=1 pw=0 time=1065 us starts=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
Disk file operations I/O 1 0.00 0.00
db file sequential read 1 0.00 0.00
********************************************************************************
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 1 0 4 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 1 0 4 1
Misses in library cache during parse: 0
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 LOAD TABLE CONVENTIONAL AUD$UNIFIED (cr=0 pr=1 pw=0 time=1386 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
Disk file operations I/O 1 0.00 0.00
gc current grant 2-way 1 0.00 0.00
db file sequential read 1 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 3 0.01 0.02 0 64 0 0
Execute 3 0.03 0.06 0 0 0 0
Fetch 136 0.02 0.04 69 1022 0 138
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 142 0.07 0.13 69 1086 0 138
Misses in library cache during parse: 2
Misses in library cache during execute: 1
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 247 0.00 0.00
SQL*Net message from client 254 30.54 268.24
PGA memory operation 20 0.00 0.00
db file sequential read 9 0.00 0.00
gc cr grant 2-way 4 0.00 0.00
gc cr multi block grant 2 0.00 0.00
db file parallel read 2 0.00 0.00
gc current grant busy 2 0.00 0.00
Disk file operations I/O 1 0.00 0.00
gc current grant 2-way 1 0.00 0.00
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 17 0.00 0.00 0 0 0 0
Execute 23 0.03 0.04 2 0 8 2
Fetch 50 0.00 0.02 17 61 0 33
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 90 0.04 0.08 19 61 8 35
Misses in library cache during parse: 17
Misses in library cache during execute: 18
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 21 0.00 0.00
db file sequential read 12 0.00 0.00
gc cr grant 2-way 4 0.00 0.00
db file parallel read 1 0.00 0.00
Disk file operations I/O 2 0.00 0.00
gc current block 2-way 14 0.00 0.01
gc cr multi block mixed 1 0.00 0.00
log file sync 1 0.00 0.00
4 user SQL statements in session.
17 internal SQL statements in session.
21 SQL statements in session.
********************************************************************************
Trace file: backdbpp1_ora_196862_ERIC.trc
Trace file compatibility: 12.2.0.0
Sort options: default
1 session in tracefile.
4 user SQL statements in trace file.
17 internal SQL statements in trace file.
21 SQL statements in trace file.
20 unique SQL statements in trace file.
1238 lines in trace file.
259 elapsed seconds in trace file.
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 1 0 4 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 1 0 4 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
---------- ---------- ---------- ---------------------------------------------------
0 0 0 LOAD TABLE CONVENTIONAL AUD$ (cr=0 pr=1 pw=0 time=1065 us starts=1)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
Disk file operations I/O 1 0.00 0.00
db file sequential read 1 0.00 0.00
********************************************************************************
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 1 0 4 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 0.00 0.00 1 0 4 1
Misses in library cache during parse: 0
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 LOAD TABLE CONVENTIONAL AUD$UNIFIED (cr=0 pr=1 pw=0 time=1386 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
Disk file operations I/O 1 0.00 0.00
gc current grant 2-way 1 0.00 0.00
db file sequential read 1 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 3 0.01 0.02 0 64 0 0
Execute 3 0.03 0.06 0 0 0 0
Fetch 136 0.02 0.04 69 1022 0 138
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 142 0.07 0.13 69 1086 0 138
Misses in library cache during parse: 2
Misses in library cache during execute: 1
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 247 0.00 0.00
SQL*Net message from client 254 30.54 268.24
PGA memory operation 20 0.00 0.00
db file sequential read 9 0.00 0.00
gc cr grant 2-way 4 0.00 0.00
gc cr multi block grant 2 0.00 0.00
db file parallel read 2 0.00 0.00
gc current grant busy 2 0.00 0.00
Disk file operations I/O 1 0.00 0.00
gc current grant 2-way 1 0.00 0.00
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 17 0.00 0.00 0 0 0 0
Execute 23 0.03 0.04 2 0 8 2
Fetch 50 0.00 0.02 17 61 0 33
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 90 0.04 0.08 19 61 8 35
Misses in library cache during parse: 17
Misses in library cache during execute: 18
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 21 0.00 0.00
db file sequential read 12 0.00 0.00
gc cr grant 2-way 4 0.00 0.00
db file parallel read 1 0.00 0.00
Disk file operations I/O 2 0.00 0.00
gc current block 2-way 14 0.00 0.01
gc cr multi block mixed 1 0.00 0.00
log file sync 1 0.00 0.00
4 user SQL statements in session.
17 internal SQL statements in session.
21 SQL statements in session.
********************************************************************************
Trace file: backdbpp1_ora_196862_ERIC.trc
Trace file compatibility: 12.2.0.0
Sort options: default
1 session in tracefile.
4 user SQL statements in trace file.
17 internal SQL statements in trace file.
21 SQL statements in trace file.
20 unique SQL statements in trace file.
1238 lines in trace file.
259 elapsed seconds in trace file.