Skip to content

Instantly share code, notes, and snippets.

@oraclelearner

oraclelearner/Select query Secret

Last active November 28, 2022 10:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save oraclelearner/44394ab8206fc7bd51041eb3d45bdf9f to your computer and use it in GitHub Desktop.
Save oraclelearner/44394ab8206fc7bd51041eb3d45bdf9f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ash top
TOTALSECONDS AAS %This USERNAME SQL_ID FIRST_SEEN LAST_SEEN DIST_SQLEXEC_SEEN DIST_TIMESTAMPS
31727 -105.8 79% | EAEAUSER1 f9XXXXXXXfq 11/27/2022 19:00 11/27/2022 19:03 2135 124
3033 -10.1 8% | EAEAUSER1 7uXXXXXXXw3 11/27/2022 19:00 11/27/2022 19:03 2111 109
701 -2.3 2% | EAEAUSER1 7wXXXXXXXzb 11/27/2022 19:00 11/27/2022 19:03 701 35
594 -2 1% | EAEAUSER1 2pXXXXXXXnq 11/27/2022 19:00 11/27/2022 19:03 594 36
466 -1.6 1% | EAEAUSER1 4yXXXXXXXwq 11/27/2022 19:00 11/27/2022 19:04 80 86
388 -1.3 1% | RUSER 01XXXXXXXXym 11/27/2022 19:00 11/27/2022 19:04 241 164
353 -1.2 1% | EAEAUSER1 3xXXXXXXXXXfu 11/27/2022 19:00 11/27/2022 19:03 353 35
329 -1.1 1% | ORBATCH 11/27/2022 19:02 11/27/2022 19:03 1 33
290 -1 1% | ORBATCH d2XXXXXXXXX66 11/27/2022 19:02 11/27/2022 19:04 28 34
280 -0.9 1% | EAEAUSER1 grXXXXXXXXX0x 11/27/2022 19:00 11/27/2022 19:04 279 90
178 -0.6 0% | EAEAUSER1 5wXXXXXXXXxn 11/27/2022 19:00 11/27/2022 19:03 62 47
125 -0.4 0% | MTUSER dxXXXXXXXXxh 11/27/2022 19:00 11/27/2022 19:04 9 34
98 -0.3 0% | RUSER a4XXXXXXXXX8u 11/27/2022 19:02 11/27/2022 19:03 4 29
97 -0.3 0% | MTUSER bfXXXXXXXXXvk 11/27/2022 19:00 11/27/2022 19:04 41 54
Raw
ash wait chain
%This SECONDS AAS DISTINCT_SIDS WAIT_CHAIN FIRST_SEEN LAST_SEEN
58% 23383 -77.9 1731 -> EAUSER1:(gwman) reliable message 11/27/2022 19:00 11/27/2022 19:03
19% 7600 -25.3 1546 -> EAUSER1:(gwman) enq: KO - fast object checkpoint [mode=6] 11/27/2022 19:00 11/27/2022 19:03
5% 2045 -6.8 1006 -> EAUSER1:(gwman) reliable message -> [idle blocker 2,884,64533 (oracle@EX07db02.XXXXXXX.com (CKPT))] 11/27/2022 19:03 11/27/2022 19:03
4% 1692 -5.6 1617 -> EAUSER1:(gwman) cell smart table scan 11/27/2022 19:00 11/27/2022 19:03
2% 925 -3.1 279 -> EAUSER1:(gwman) gcs drm freeze in enter server mode -> [idle blocker 1,1387,26870 (oracle@EX07db01.XXXXXXX.com (LMON))] 11/27/2022 19:02 11/27/2022 19:03
2% 851 -2.8 599 -> EAUSER1:(gwman) ON CPU 11/27/2022 19:00 11/27/2022 19:04
1% 480 -1.6 51 -> EAUSER1:(gwoff) ON CPU 11/27/2022 19:00 11/27/2022 19:04
1% 285 -1 284 -> EAUSER1:(gwman) enq: KO - fast object checkpoint [mode=1] 11/27/2022 19:00 11/27/2022 19:03
1% 231 -0.8 27 -> EAUSER1:(autstl@vmsnnnnnnn) enq: TX - row lock contention [mode=6] -> EAUSER1:(autstl@vmsnnnnnnn) cell smart table scan 11/27/2022 19:00 11/27/2022 19:04
1% 224 -0.7 2 -> ORBATCH:(oracle@xnnndbnn.XXXXXXX.com (TNS V) enq: SQ - contention [mode=4] -> ORBATCH:(oracle@xnnndbnn.XXXXXXX.com (TNS V) KJC: Wait for msg sends to complete 11/27/2022 19:02 11/27/2022 19:03
0% 192 -0.6 7 -> RUSER:(JDBC Thin Client) ON CPU 11/27/2022 19:00 11/27/2022 19:04
0% 176 -0.6 3 -> ORBATCH:(oracle@xnnndbnn.XXXXXXX.com (TNS V) rdbms ipc reply -> SYS:(GTXn) DFS lock handle 11/27/2022 19:02 11/27/2022 19:03
0% 174 -0.6 47 -> EAUSER1:(gwoff) cell single block physical read: pmem cache 11/27/2022 19:00 11/27/2022 19:04
0% 141 -0.5 19 -> EAUSER1:(autstl@vmsnnnnnnn) enq: TX - row lock contention [mode=6] -> EAUSER1:(autstl@vmsnnnnnnn) ON CPU 11/27/2022 19:00 11/27/2022 19:04
0% 134 -0.4 10 -> MTUSER:(JDBC Thin Client) reliable message 11/27/2022 19:02 11/27/2022 19:03
0% 112 -0.4 8 -> RUSER:(JDBC Thin Client) reliable message 11/27/2022 19:00 11/27/2022 19:04
0% 85 -0.3 3 -> DBSNMP:(oracle) ON CPU 11/27/2022 19:01 11/27/2022 19:04
0% 83 -0.3 7 -> ORBATCH:(oracle@xnnndbnn.XXXXXXX.com (TNS V) KJC: Wait for msg sends to complete 11/27/2022 19:02 11/27/2022 19:03
0% 72 -0.2 6 -> RUSER:(JDBC Thin Client) enq: KO - fast object checkpoint [mode=6] 11/27/2022 19:00 11/27/2022 19:04
0% 69 -0.2 3 -> RUSER:(JDBC Thin Client) row cache lock -> RUSER:(JDBC Thin Client) DLM cross inst call completion 11/27/2022 19:02 11/27/2022 19:03
0% 64 -0.2 6 -> ORBATCH:(oracle@xnnndbnn.XXXXXXX.com (TNS V) DFS lock handle 11/27/2022 19:02 11/27/2022 19:03
0% 54 -0.2 54 -> EAUSER1:(gwman) cell single block physical read: pmem cache 11/27/2022 19:00 11/27/2022 19:03
0% 54 -0.2 28 -> EAUSER1:(autstl@vmsnnnnnnn) cell smart table scan 11/27/2022 19:00 11/27/2022 19:04
Raw
Select query
SELECT CASE WHEN COUNT (1) > 0 THEN 'Y' ELSE 'N' END FROM
MCB MCB, CB CB WHERE MCB.ABID = :B3
AND MCB.MID = :B2 AND CB.CB_NAME = :B1 AND
MCB.CB_ID = CB.CB_ID
-------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 5 (100)| |
| 1 | SORT AGGREGATE | | 1 | 31 | | |
| 2 | HASH JOIN | | 1 | 31 | 5 (0)| 00:00:01 |
| 3 | INDEX RANGE SCAN | PK_MCB | 2 | 48 | 3 (0)| 00:00:01 |
| 4 | TABLE ACCESS STORAGE FULL| CB | 1 | 7 | 1 (0)| 00:00:01 |
-------------------------------------------------------------------------------------------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment