Skip to content

Instantly share code, notes, and snippets.

@aryangoti

aryangoti/ashsamples

Created March 31, 2022 11:28
Show Gist options
  • Save aryangoti/6674691d7770b6eb667718589633aec5 to your computer and use it in GitHub Desktop.
Save aryangoti/6674691d7770b6eb667718589633aec5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ashsamples
** top sql_ids **
SQL_ID MODULE *CPU* CPU% WAIT IO IO% TOT
------------- ---------------------------------------- -------- ------ -------- -------- ------ ----------
dw4d2s82txm97 OGG-R3_896B-OPEN_DATA_SOURCE 21 53.8 0 73 92.4 94
gz6y52n8yr2tz JDBC Thin Client 7 17.9 0 0 .0 7
1u8puu5uy3620 OGG-R3_896B-OPEN_DATA_SOURCE 6 15.4 0 6 7.6 12
fthscfy6wg50x JDBC Thin Client 3 7.7 0 0 .0 3
gcwwf5j6uh3dw OGG-E1_896B-OCI_META_THREAD 2 5.1 48 0 .0 50
8s2xpw5ct0xvf OGG-E1_896B-OCI_META_THREAD 0 .0 13 0 .0 13
6 rows selected.
** top events **
EVENT SQL_ID WAIT WAIT% IO IO% *TOT* TOT%
-------------------------------- ------------- -------- ------ -------- ------ ---------- ------
direct path write dw4d2s82txm97 0 .0 71 89.9 71 50.7
control file sequential read gcwwf5j6uh3dw 48 78.7 0 .0 48 34.3
control file sequential read 8s2xpw5ct0xvf 13 21.3 0 .0 13 9.3
direct path write 1u8puu5uy3620 0 .0 6 7.6 6 4.3
db file sequential read dw4d2s82txm97 0 .0 2 2.5 2 1.4
5 rows selected.
** top objects **
OBJ# OBJ_NAME WAIT WAIT% IO IO% *TOT* TOT%
-------- ----------------------------------------------------------------- -------- ------ -------- ------ ---------- ------
20993 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1327 0 10 16.9 10 16.9
21005 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1339 0 9 15.3 9 15.3
21003 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1337 0 7 11.9 7 11.9
21007 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1341 0 7 11.9 7 11.9
20998 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1332 0 6 10.2 6 10.2
21012 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1346 0 6 10.2 6 10.2
21011 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1345 0 4 6.8 4 6.8
21015 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1349 0 4 6.8 4 6.8
21006 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1340 0 3 5.1 3 5.1
21002 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1336 0 3 5.1 3 5.1
10 rows selected.
** top modules **
MODULE *CPU* CPU% WAIT WAIT% IO IO% TOT
------------------------------------------------------------ -------- ------ -------- ------ -------- ------ ----------
OGG-R3_896B-OPEN_DATA_SOURCE 211 68.3 0 .0 79 7.5 290
KTSJ 75 24.3 1 1.6 974 92.3 1,050
JDBC Thin Client 10 3.2 0 .0 0 .0 10
GoldenGate 5 1.6 0 .0 1 .1 6
[oracle@c018wzvcpdbqe (PSP0)] 2 .6 0 .0 0 .0 2
OGG-E1_896B-OCI_META_THREAD 2 .6 61 96.8 0 .0 63
[oracle@c018wzvcpdbqe (LCK0)] 1 .3 0 .0 0 .0 1
sqlplus@c018wzvcpdbqe (TNS V1-V3) 1 .3 0 .0 0 .0 1
[oracle@c018wzvcpdbqe (CKPT)] 1 .3 1 1.6 1 .1 3
[oracle@c018wzvcpdbqe (DIA0)] 1 .3 0 .0 0 .0 1
10 rows selected.
** top I/Os by sql_id **
SQL_ID OBJ_NAME WAIT WAIT% *IO* IO% TOT TOT%
------------- ---------------------------------------------------------------- -------- ------ -------- ------ ---------- ------
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1327 0 10 17.9 10 17.9
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1339 0 7 12.5 7 12.5
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1341 0 7 12.5 7 12.5
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1337 0 6 10.7 6 10.7
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1346 0 6 10.7 6 10.7
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1332 0 6 10.7 6 10.7
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1349 0 4 7.1 4 7.1
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1345 0 4 7.1 4 7.1
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1336 0 3 5.4 3 5.4
dw4d2s82txm97 DOC_PERSIST_SECURE.SYS_LOB0000020953C00003$$ - SYS_LOB_P1340 0 3 5.4 3 5.4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment