Skip to content

Instantly share code, notes, and snippets.

@databasetech0073

databasetech0073/gist:99026ff9530e343f85924795382dca14 Secret

Created March 3, 2023 12:49
Show Gist options
  • Save databasetech0073/99026ff9530e343f85924795382dca14 to your computer and use it in GitHub Desktop.
Save databasetech0073/99026ff9530e343f85924795382dca14 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
below is the output from three different small duration
@databasetech0073
Copy link
Author

<style> </style>
SECONDS AAS DISTINCT_SIDS WAIT_CHAIN FIRST_SEEN LAST_SEEN
3450 57.5 4 -> (app_gfl) enq: TX - allocate ITL entry [mode=4]  -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) block change tracking buffer space 2/14/2023 20:02 2/14/2023 20:02
3400 56.7 4 -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) block change tracking buffer space 2/14/2023 20:02 2/14/2023 20:02
3030 50.5 229 -> (app_gfl) block change tracking buffer space 2/14/2023 20:02 2/14/2023 20:02
2740 45.7 120 -> (app_gfl) enq: TX - allocate ITL entry [mode=4]  -> (app_gfl) block change tracking buffer space 2/14/2023 20:02 2/14/2023 20:02
2110 35.2 177 -> (app_gfl) ON CPU 2/14/2023 20:02 2/14/2023 20:02
1520 25.3 55 -> (app_gfl) enq: TX - allocate ITL entry [mode=4]  -> (app_gfl) ON CPU 2/14/2023 20:02 2/14/2023 20:02
1500 25 136 -> (app_gfl) cell single block physical read: pmem cache 2/14/2023 20:02 2/14/2023 20:02
1060 17.7 100 -> (app_gfl) latch: ges resource hash list 2/14/2023 20:02 2/14/2023 20:02
1000 16.7 36 -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) block change tracking buffer space 2/14/2023 20:02 2/14/2023 20:02
770 12.8 23 -> (app_gfl) enq: TX - allocate ITL entry [mode=4]  -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) block change tracking buffer space 2/14/2023 20:02 2/14/2023 20:02
690 11.5 27 -> (app_gfl) enq: TX - allocate ITL entry [mode=4]  -> (app_gfl) cell single block physical read: pmem cache 2/14/2023 20:02 2/14/2023 20:02
680 11.3 30 -> (app_gfl) enq: TX - allocate ITL entry [mode=4]  -> (app_gfl) latch: ges resource hash list 2/14/2023 20:02 2/14/2023 20:02
390 6.5 1 -> (app_gmn) buffer busy waits [data block]  -> (app_gmn) buffer busy waits [data block] 2/14/2023 20:02 2/14/2023 20:02
350 5.8 8 -> (Pnnn) ON CPU 2/14/2023 20:02 2/14/2023 20:02
340 5.7 6 -> (app_gfl) buffer busy waits [1st level bmb]  -> (app_gfl) block change tracking buffer space 2/14/2023 20:02 2/14/2023 20:02
           
           
SECONDS AAS DISTINCT_SIDS WAIT_CHAIN FIRST_SEEN LAST_SEEN
2600 260 260 -> (app_gmn) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
1960 196 21 -> (app_gmn) buffer busy waits [1st level bmb]  -> (app_gmn) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
1930 193 3 -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
1280 128 1 -> (app_gfl) enq: TX - allocate ITL entry [mode=4]  -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
570 57 20 -> (app_gmn) buffer busy waits [data block]  -> (app_gmn) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
350 35 35 -> (app_gfl) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
150 15 1 -> (app_gmn) row cache lock  -> (app_gmn) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
150 15 1 -> (oracle) enq: SQ - contention [mode=4]  -> (oracle) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
110 11 1 -> (app_sch) buffer busy waits [data block]  -> (app_sch) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
90 9 9 -> (app_scm) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
90 9 1 -> (app_gfl) buffer busy waits [undo @bclass 1561]  -> (app_gmn) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
70 7 5 -> (app_scm) buffer busy waits [data block]  -> (app_scm) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
60 6 6 -> (oracle) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
50 5 1 -> (app_gfl) buffer busy waits [undo @bclass 461]  -> (JDBC Thin Client) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
50 5 5 -> (JDBC Thin Client) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 2/14/2023 20:03 2/14/2023 20:03
           
           
SECONDS AAS DISTINCT_SIDS WAIT_CHAIN FIRST_SEEN LAST_SEEN
1850 30.8 148 -> (app_gfl) ON CPU 3/1/2023 20:03 3/1/2023 20:03
1600 26.7 160 -> (app_gmn) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 3/1/2023 20:03 3/1/2023 20:03
1530 25.5 133 -> (app_gfl) library cache: mutex X 3/1/2023 20:03 3/1/2023 20:03
1530 25.5 128 -> (app_gfl) block change tracking buffer space 3/1/2023 20:03 3/1/2023 20:03
1300 21.7 20 -> (app_gmn) buffer busy waits [data block]  -> (app_gmn) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 3/1/2023 20:03 3/1/2023 20:03
1090 18.2 99 -> (app_gfl) cell single block physical read: pmem cache 3/1/2023 20:03 3/1/2023 20:03
1030 17.2 103 -> (app_gfl) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 3/1/2023 20:03 3/1/2023 20:03
970 16.2 16 -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) block change tracking buffer space 3/1/2023 20:03 3/1/2023 20:03
800 13.3 1 -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) buffer busy waits [data block]  -> (app_gfl) block change tracking buffer space 3/1/2023 20:03 3/1/2023 20:03
690 11.5 44 -> (app_gfl) enq: TX - allocate ITL entry [mode=4]  -> (app_gfl) library cache: mutex X 3/1/2023 20:03 3/1/2023 20:03
580 9.7 11 -> (app_gmn) buffer busy waits [1st level bmb]  -> (app_gmn) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 3/1/2023 20:03 3/1/2023 20:03
520 8.7 47 -> (app_gfl) gc cr grant 2-way 3/1/2023 20:03 3/1/2023 20:03
510 8.5 3 -> (app_gfl) buffer busy waits [1st level bmb]  -> (app_gfl) block change tracking buffer space 3/1/2023 20:03 3/1/2023 20:03
400 6.7 2 -> (app_gfl) free buffer waits  -> (DBWn) db file async I/O submit 3/1/2023 20:03 3/1/2023 20:03
360 6 6 -> (app_gfl) buffer busy waits [1st level bmb]  -> (app_gfl) log file switch (checkpoint incomplete)  -> [idle blocker 1,2395,8486 (oracle@XXXXXX.com (DBW0))] 3/1/2023 20:03 3/1/2023 20:03

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment