Skip to content

Instantly share code, notes, and snippets.

@aryangoti

aryangoti/gist:f2cf46ebcec3920d79f4fb719c01f309

Created March 31, 2022 11:26
Show Gist options
  • Save aryangoti/f2cf46ebcec3920d79f4fb719c01f309 to your computer and use it in GitHub Desktop.
Save aryangoti/f2cf46ebcec3920d79f4fb719c01f309 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
@snapper ash,stats 5 10 2060
Sampling SID 2060 with interval 5 seconds, taking 10 snapshots...
-- Session Snapper v4.24 - by Tanel Poder ( http://blog.tanelpoder.com/snapper ) - Enjoy the Most Advanced Oracle Troubleshooting Script on the Planet! :)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SID @INST, USERNAME , TYPE, STATISTIC , DELTA, HDELTA/SEC, %TIME, GRAPH , NUM_WAITS, WAITS/SEC, AVERAGES
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2060 @1, (W003) , STAT, opened cursors cumulative , 4, .79, , , , , 1 per execution
2060 @1, (W003) , STAT, recursive calls , 59, 11.62, , , , , 0 recursive CPU per recursive call
2060 @1, (W003) , STAT, session logical reads , 31180, 6.14k, , , , , 31.18k total buffer visits
2060 @1, (W003) , STAT, CPU used by this session , 33, 6.5, , , , , 330ms total CPU used by this session
2060 @1, (W003) , STAT, user I/O wait time , 383, 75.4, , , , , 95.75 per execution
2060 @1, (W003) , STAT, non-idle wait time , 382, 75.2, , , , , 95.5 per execution
2060 @1, (W003) , STAT, non-idle wait count , 7403, 1.46k, , , , , 1.85k per execution
2060 @1, (W003) , STAT, in call idle wait time , 128, 25.2, , , , , 32 per execution
2060 @1, (W003) , STAT, messages sent , 4, .79, , , , , 1 per execution
2060 @1, (W003) , STAT, enqueue timeouts , 7, 1.38, , , , , 1.75 per execution
2060 @1, (W003) , STAT, enqueue requests , 239, 47.05, , , , , 59.75 per execution
2060 @1, (W003) , STAT, enqueue conversions , 404, 79.53, , , , , 101 per execution
2060 @1, (W003) , STAT, enqueue releases , 230, 45.28, , , , , 57.5 per execution
2060 @1, (W003) , STAT, global enqueue gets sync , 629, 123.83, , , , , 157.25 per execution
2060 @1, (W003) , STAT, global enqueue releases , 214, 42.13, , , , , 53.5 per execution
2060 @1, (W003) , STAT, physical read total IO requests , 7203, 1.42k, , , , , 1.8k per execution
2060 @1, (W003) , STAT, physical read total bytes , 59006976, 11.62M, , , , , 14.75M per execution
2060 @1, (W003) , STAT, cell physical IO interconnect bytes , 59015168, 11.62M, , , , , 14.75M per execution
2060 @1, (W003) , STAT, db block gets , 8680, 1.71k, , , , , 2.17k per execution
2060 @1, (W003) , STAT, db block gets from cache , 8680, 1.71k, , , , , 2.17k per execution
2060 @1, (W003) , STAT, db block gets from cache (fastpath) , 13, 2.56, , , , , 3.25 per execution
2060 @1, (W003) , STAT, consistent gets , 22504, 4.43k, , , , , 5.63k per execution
2060 @1, (W003) , STAT, consistent gets from cache , 22505, 4.43k, , , , , 5.63k per execution
2060 @1, (W003) , STAT, consistent gets from cache (fastpath) , 15291, 3.01k, , , , , 3.82k per execution
2060 @1, (W003) , STAT, consistent gets - examination , 8, 1.57, , , , , 2 per execution
2060 @1, (W003) , STAT, logical read bytes from cache , 255467520, 50.29M, , , , , 63.87M per execution
2060 @1, (W003) , STAT, physical reads , 7206, 1.42k, , , , , 1.8k per execution
2060 @1, (W003) , STAT, physical reads cache , 7206, 1.42k, , , , , 1.8k per execution
2060 @1, (W003) , STAT, physical read IO requests , 7206, 1.42k, , , , , 8.19k bytes per request
2060 @1, (W003) , STAT, physical read bytes , 59039744, 11.62M, , , , , 14.76M per execution
2060 @1, (W003) , STAT, db block changes , 263, 51.78, , , , , 65.75 per execution
2060 @1, (W003) , STAT, consistent changes , 43, 8.47, , , , , 10.75 per execution
2060 @1, (W003) , STAT, free buffer requested , 7253, 1.43k, , , , , 1.81k per execution
2060 @1, (W003) , STAT, free buffer inspected , 89, 17.52, , , , , 22.25 per execution
2060 @1, (W003) , STAT, CR blocks created , 40, 7.87, , , , , 10 per execution
2060 @1, (W003) , STAT, calls to kcmgcs , 22406, 4.41k, , , , , 5.6k per execution
2060 @1, (W003) , STAT, calls to kcmgas , 5567, 1.1k, , , , , 1.39k per execution
2060 @1, (W003) , STAT, calls to get snapshot scn: kcmgss , 16, 3.15, , , , , 4 per execution
2060 @1, (W003) , STAT, redo entries , 342, 67.33, , , , , 85.5 per execution
2060 @1, (W003) , STAT, redo size , 49504, 9.75k, , , , , ~ bytes per user commit
2060 @1, (W003) , STAT, redo subscn max counts , 3, .59, , , , , .75 per execution
2060 @1, (W003) , STAT, file io wait time , 3835034, 754.99k, , , , , 532.42us bad guess of IO wait time per IO request
2060 @1, (W003) , STAT, gc local grants , 7226, 1.42k, , , , , 1.81k per execution
2060 @1, (W003) , STAT, gc force cr disk read , 7227, 1.42k, , , , , 1.81k per execution
2060 @1, (W003) , STAT, undo change vector size , 960, 188.99, , , , , 240 per execution
2060 @1, (W003) , STAT, segment prealloc ops , 11, 2.17, , , , , 2.75 per execution
2060 @1, (W003) , STAT, segment prealloc time (ms) , 3772, 742.58, , , , , 943 per execution
2060 @1, (W003) , STAT, segment prealloc ufs2cfs bytes , 1490944, 293.52k, , , , , 372.74k per execution
2060 @1, (W003) , STAT, table fetch by rowid , 4, .79, , , , , 1 per execution
2060 @1, (W003) , STAT, rows fetched via callback , 4, .79, , , , , 1 per execution
2060 @1, (W003) , STAT, index fetch by key , 4, .79, , , , , 1 per execution
2060 @1, (W003) , STAT, session cursor cache hits , 4, .79, , , , , 0 softparses avoided thanks to cursor cache
2060 @1, (W003) , STAT, buffer is not pinned count , 12, 2.36, , , , , 3 per execution
2060 @1, (W003) , STAT, parse count (total) , 4, .79, , , , , ~ softparses per hardparse
2060 @1, (W003) , STAT, execute count , 4, .79, , , , , 1 executions per parse
2060 @1, (W003) , TIME, background cpu time , 274958, 54.13ms, 5.4%, [# ], , ,
2060 @1, (W003) , TIME, background elapsed time , 3280318, 645.79ms, 64.6%, [####### ], , , 10.08 % unaccounted time
2060 @1, (W003) , WAIT, db file sequential read , 3877402, 763.33ms, 76.3%, [WWWWWWWW ], 7314, 1.44k, 530.13us average wait
2060 @1, (W003) , WAIT, Space Manager: slave idle wait , 1287194, 253.41ms, 25.3%, [WWW ], 55, 10.83, 23.4ms average wait
2060 @1, (W003) , WAIT, events in waitclass Other , 1407, 276.99us, .0%, [ ], 101, 19.88, 13.93us average wait
-- End of Stats snap 1, end=2022-03-31 06:14:15, seconds=5.1
---------------------------------------------------------------------------------------------------------------
ActSes %Thread | INST | SQL_ID | SQL_CHILD | EVENT | WAIT_CLASS
---------------------------------------------------------------------------------------------------------------
.80 (80%) | 1 | | | db file sequential read | User I/O
-- End of ASH snap 1, end=2022-03-31 06:14:15, seconds=5, samples_taken=10, AAS=.8
2060 @1, (W003) , STAT, opened cursors cumulative , 7, 1.37, , , , , 1 per execution
2060 @1, (W003) , STAT, recursive calls , 101, 19.81, , , , , 0 recursive CPU per recursive call
2060 @1, (W003) , STAT, session logical reads , 34734, 6.81k, , , , , 65.91k total buffer visits
2060 @1, (W003) , STAT, CPU used by this session , 31, 6.08, , , , , 640ms total CPU used by this session
2060 @1, (W003) , STAT, user I/O wait time , 315, 61.79, , , , , 63.45 per execution
2060 @1, (W003) , STAT, non-idle wait time , 316, 61.99, , , , , 63.45 per execution
2060 @1, (W003) , STAT, non-idle wait count , 5972, 1.17k, , , , , 1.22k per execution
2060 @1, (W003) , STAT, in call idle wait time , 174, 34.13, , , , , 27.45 per execution
2060 @1, (W003) , STAT, messages sent , 8, 1.57, , , , , 1.09 per execution
2060 @1, (W003) , STAT, enqueue timeouts , 10, 1.96, , , , , 1.55 per execution
2060 @1, (W003) , STAT, enqueue requests , 77, 15.1, , , , , 28.73 per execution
2060 @1, (W003) , STAT, enqueue conversions , 36, 7.06, , , , , 40 per execution
2060 @1, (W003) , STAT, enqueue releases , 69, 13.54, , , , , 27.18 per execution
2060 @1, (W003) , STAT, global enqueue gets sync , 84, 16.48, , , , , 64.82 per execution
2060 @1, (W003) , STAT, global enqueue releases , 42, 8.24, , , , , 23.27 per execution
2060 @1, (W003) , STAT, physical read total IO requests , 5949, 1.17k, , , , , 1.2k per execution
2060 @1, (W003) , STAT, physical read total bytes , 48734208, 9.56M, , , , , 9.79M per execution
2060 @1, (W003) , STAT, cell physical IO interconnect bytes , 48726016, 9.56M, , , , , 9.79M per execution
2060 @1, (W003) , STAT, db block gets , 10355, 2.03k, , , , , 1.73k per execution
2060 @1, (W003) , STAT, db block gets from cache , 10355, 2.03k, , , , , 1.73k per execution
2060 @1, (W003) , STAT, db block gets from cache (fastpath) , 27, 5.3, , , , , 3.64 per execution
2060 @1, (W003) , STAT, consistent gets , 24375, 4.78k, , , , , 4.26k per execution
2060 @1, (W003) , STAT, consistent gets from cache , 24374, 4.78k, , , , , 4.26k per execution
2060 @1, (W003) , STAT, consistent gets from cache (fastpath) , 18413, 3.61k, , , , , 3.06k per execution
2060 @1, (W003) , STAT, consistent gets - examination , 14, 2.75, , , , , 2 per execution
2060 @1, (W003) , STAT, logical read bytes from cache , 284499968, 55.81M, , , , , 49.09M per execution
2060 @1, (W003) , STAT, physical reads , 5946, 1.17k, , , , , 1.2k per execution
2060 @1, (W003) , STAT, physical reads cache , 5946, 1.17k, , , , , 1.2k per execution
2060 @1, (W003) , STAT, physical read IO requests , 5946, 1.17k, , , , , 8.19k bytes per request
2060 @1, (W003) , STAT, physical read bytes , 48701440, 9.55M, , , , , 9.79M per execution
2060 @1, (W003) , STAT, db block changes , 399, 78.27, , , , , 60.18 per execution
2060 @1, (W003) , STAT, consistent changes , 48, 9.42, , , , , 8.27 per execution
2060 @1, (W003) , STAT, change write time , 1, .2, , , , , .09 per execution
2060 @1, (W003) , STAT, free buffer requested , 5984, 1.17k, , , , , 1.2k per execution
2060 @1, (W003) , STAT, free buffer inspected , 93, 18.24, , , , , 16.55 per execution
2060 @1, (W003) , STAT, CR blocks created , 45, 8.83, , , , , 7.73 per execution
2060 @1, (W003) , STAT, calls to kcmgcs , 24285, 4.76k, , , , , 4.24k per execution
2060 @1, (W003) , STAT, calls to kcmgas , 4302, 843.9, , , , , 897.18 per execution
2060 @1, (W003) , STAT, calls to get snapshot scn: kcmgss , 28, 5.49, , , , , 4 per execution
2060 @1, (W003) , STAT, redo entries , 323, 63.36, , , , , 60.45 per execution
2060 @1, (W003) , STAT, redo size , 351228, 68.9k, , , , , ~ bytes per user commit
2060 @1, (W003) , STAT, redo subscn max counts , 2, .39, , , , , .45 per execution
2060 @1, (W003) , STAT, file io wait time , 3141780, 616.31k, , , , , 530.48us bad guess of IO wait time per IO request
2060 @1, (W003) , STAT, gc local grants , 5926, 1.16k, , , , , 1.2k per execution
2060 @1, (W003) , STAT, gc force cr disk read , 5925, 1.16k, , , , , 1.2k per execution
2060 @1, (W003) , STAT, undo change vector size , 129552, 25.41k, , , , , 11.86k per execution
2060 @1, (W003) , STAT, segment dispenser load tasks , 2, .39, , , , , .18 per execution
2060 @1, (W003) , STAT, segment prealloc tasks , 4, .78, , , , , .36 per execution
2060 @1, (W003) , STAT, segment prealloc ops , 13, 2.55, , , , , 2.18 per execution
2060 @1, (W003) , STAT, segment prealloc time (ms) , 3616, 709.33, , , , , 671.64 per execution
2060 @1, (W003) , STAT, segment prealloc ufs2cfs bytes , 1253376, 245.87k, , , , , 249.48k per execution
2060 @1, (W003) , STAT, table fetch by rowid , 7, 1.37, , , , , 1 per execution
2060 @1, (W003) , STAT, rows fetched via callback , 7, 1.37, , , , , 1 per execution
2060 @1, (W003) , STAT, index fetch by key , 7, 1.37, , , , , 1 per execution
2060 @1, (W003) , STAT, session cursor cache hits , 7, 1.37, , , , , 0 softparses avoided thanks to cursor cache
2060 @1, (W003) , STAT, buffer is not pinned count , 21, 4.12, , , , , 3 per execution
2060 @1, (W003) , STAT, parse count (total) , 7, 1.37, , , , , ~ softparses per hardparse
2060 @1, (W003) , STAT, execute count , 7, 1.37, , , , , 1 executions per parse
2060 @1, (W003) , TIME, background cpu time , 341948, 67.08ms, 6.7%, [# ], , ,
2060 @1, (W003) , TIME, background elapsed time , 4080018, 800.36ms, 80.0%, [######## ], , , -103.59 % unaccounted time
2060 @1, (W003) , WAIT, buffer busy waits , 59, 11.57us, .0%, [ ], 1, .2, 59us average wait
2060 @1, (W003) , WAIT, db file sequential read , 3099412, 608ms, 60.8%, [WWWWWWW ], 5838, 1.15k, 530.9us average wait
2060 @1, (W003) , WAIT, Space Manager: slave idle wait , 1731104, 339.58ms, 34.0%, [WWWW ], 49, 9.61, 35.33ms average wait
2060 @1, (W003) , WAIT, events in waitclass Other , 187, 36.68us, .0%, [ ], 10, 1.96, 18.7us average wait
-- End of Stats snap 2, end=2022-03-31 06:14:20, seconds=5.1
---------------------------------------------------------------------------------------------------------------
ActSes %Thread | INST | SQL_ID | SQL_CHILD | EVENT | WAIT_CLASS
---------------------------------------------------------------------------------------------------------------
.70 (70%) | 1 | | | db file sequential read | User I/O
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment