Skip to content

Instantly share code, notes, and snippets.

@aryangoti

aryangoti/gist:f49660a4bbb23c58a9f403ac9270eb7a

Created March 31, 2022 11:21
Show Gist options
  • Save aryangoti/f49660a4bbb23c58a9f403ac9270eb7a to your computer and use it in GitHub Desktop.
Save aryangoti/f49660a4bbb23c58a9f403ac9270eb7a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
********************************************************************************
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: 1v717nvrhgbn9 Plan Hash: 1388734953
SELECT USER
FROM
SYS.DUAL
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 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 0 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 0 0 2
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 97 (recursive depth: 1)
********************************************************************************
SQL ID: faw55katfd4wg Plan Hash: 0
INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "COLLECTOR"."GG_HRTBT_R3_896"
("ORIG_SITE","ORIG_DATABASE","CREATED_TIME","APPLY_TIME")
VALUES
(:a0,:a1,:a2,:a3)
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 6 2
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 0 6 2
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 65
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
SQL*Net message from client 2 0.00 0.00
********************************************************************************
SQL ID: 5310q13vtuwbh Plan Hash: 1821481723
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "DOC_PERSIST_SECURE"."PERSISTED_METADATA"
SET "DOC_GUID" = :a3,"CHECKSUM" = :a4,"BLOB_ID" = :a5,"CREATED_DATE" = :a6,
"MODIFIED_DATE" = :a7,"REMOVED_DATE" = :a8,"REMOVED_REASON" = :a9,
"IS_REMOVED" = :a10,"ORIGINAL_DOC_SIZE" = :a11,"PERSIST_DOC_SIZE" = :a12,
"PART_IDENTIFIER" = :a13,"PERSISTED_TYPE" = :a14
WHERE
"DOC_GUID" = :b0 AND "CHECKSUM" = :b1 AND "BLOB_ID" = :b2 AND "CREATED_DATE"
= :b3 AND "MODIFIED_DATE" = :b4 AND "REMOVED_DATE" is NULL AND
"REMOVED_REASON" is NULL AND "IS_REMOVED" = :b7 AND "ORIGINAL_DOC_SIZE" =
:b8 AND "PERSIST_DOC_SIZE" = :b9 AND "PART_IDENTIFIER" is NULL AND
"PERSISTED_TYPE" = :b11 AND "REMOVED_REASON_CODE" is NULL AND
"HARD_DELETE_DATE" is NULL
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 763 0.01 0.11 0 3067 3169 763
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 763 0.01 0.11 0 3067 3169 763
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 65
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 763 0.00 0.00
SQL*Net message from client 763 0.20 3.88
********************************************************************************
SQL ID: dw4d2s82txm97 Plan Hash: 3998643120
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "DOC_PERSIST_SECURE"."PERSISTED_BLOB" SET
"CREATED_DATE" = :a1,"DOC_BLOB" = :a2,"MODIFIED_DATE" = :a3
WHERE
"BLOB_ID" = :b0 AND "CREATED_DATE" = :b1 AND "MODIFIED_DATE" = :b2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 757 14.24 52.36 816 568765 3866185 757
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 757 14.24 52.36 816 568765 3866185 757
Misses in library cache during parse: 0
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 65
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE PERSISTED_BLOB (cr=1012 pr=12 pw=141 time=106304 us)
1 1 1 TABLE ACCESS BY GLOBAL INDEX ROWID PERSISTED_BLOB PARTITION: ROW LOCATION ROW LOCATION (cr=5 pr=0 pw=0 time=58 us cost=3 size=470 card=1)
1 1 1 INDEX UNIQUE SCAN PERSISTED_BLOB_PK (cr=3 pr=0 pw=0 time=18 us cost=2 size=0 card=1)(object id 21242)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
direct path write 55686 0.21 38.67
SQL*Net message to client 757 0.00 0.00
SQL*Net message from client 757 0.01 0.67
db file sequential read 816 0.01 0.47
buffer busy waits 284 0.00 0.00
log file switch completion 1 0.02 0.02
********************************************************************************
SQL ID: 1u8puu5uy3620 Plan Hash: 3998643120
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "DOC_PERSIST_SECURE"."PERSISTED_BLOB" SET
"DOC_BLOB" = :a1
WHERE
"BLOB_ID" = :b0 AND "CREATED_DATE" = :b1 AND "MODIFIED_DATE" = :b2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 88 1.98 7.15 98 71827 609379 88
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 88 1.98 7.15 98 71827 609379 88
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 65
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
direct path write 7993 0.13 5.28
SQL*Net message to client 88 0.00 0.00
SQL*Net message from client 88 0.00 0.02
db file sequential read 96 0.00 0.04
direct path read 2 0.00 0.00
buffer busy waits 40 0.00 0.00
********************************************************************************
SQL ID: aku0d40kctg28 Plan Hash: 4129878806
UPDATE ggs.ggs_checkpoint SET last_update_ts = sysdate, seqno = :seqno, rba =
:rba, audit_ts = :audit_ts, log_csn = :log_csn, log_xid = :log_xid,
log_cmplt_csn = :log_cmplt_csn, log_cmplt_xids = :log_cmplt_xids, version =
:version
WHERE
group_name = :group_name AND group_key = :key
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 14 0.00 0.00 0 0 0 0
Execute 14 0.00 0.01 0 14 14 14
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 28 0.00 0.01 0 14 14 14
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 65
Number of plan statistics captured: 3
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
0 0 0 UPDATE GGS_CHECKPOINT (cr=1 pr=0 pw=0 time=50 us)
1 1 1 INDEX UNIQUE SCAN SYS_C004004 (cr=1 pr=0 pw=0 time=8 us cost=0 size=133 card=1)(object id 14331)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 14 0.00 0.00
SQL*Net message from client 14 0.00 0.00
********************************************************************************
SQL ID: 5xk9m5x31cp7m Plan Hash: 3998643120
UPDATE /*+ RESTRICT_ALL_REF_CONS */ "DOC_PERSIST_SECURE"."PERSISTED_BLOB" SET
"CREATED_DATE" = :a1,"MODIFIED_DATE" = :a2
WHERE
"BLOB_ID" = :b0 AND "CREATED_DATE" = :b1 AND "MODIFIED_DATE" = :b2
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 10 8 2
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 0.00 0.00 0 10 8 2
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 65
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
SQL*Net message from client 2 0.00 0.00
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 14 0.00 0.00 0 0 0 0
Execute 1626 16.24 59.65 914 643683 4478761 1626
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1640 16.24 59.65 914 643683 4478761 1626
Misses in library cache during parse: 1
Misses in library cache during execute: 2
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 4176 0.00 0.01
SQL*Net message from client 4176 0.20 4.91
SQL*Net more data from client 27215 0.00 0.42
direct path write 63679 0.21 43.95
db file sequential read 912 0.01 0.52
buffer busy waits 324 0.00 0.01
direct path read 2 0.00 0.00
log file switch completion 1 0.02 0.02
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 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 0 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 0 0 2
Misses in library cache during parse: 0
9 user SQL statements in session.
0 internal SQL statements in session.
9 SQL statements in session.
********************************************************************************
Trace file: xxxxb1_ora_33722.trc
Trace file compatibility: 11.1.0.7
Sort options: default
1 session in tracefile.
9 user SQL statements in trace file.
0 internal SQL statements in trace file.
9 SQL statements in trace file.
7 unique SQL statements in trace file.
105039 lines in trace file.
138 elapsed seconds in trace file.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment