Created
March 31, 2022 11:28
-
-
Save aryangoti/6674691d7770b6eb667718589633aec5 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
** 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