Created
April 1, 2022 12:26
-
-
Save aryangoti/588cc507d222930a6f906683c8115f3b 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
SQL> @snapper stats 10 1 2 2057 | |
Sampling SID 2057 with interval 10 seconds, taking 2 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 | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
2057 @1, GGS , STAT, Requests to/from client , 345, 34.24, , , , , 2.59 per execution | |
2057 @1, GGS , STAT, opened cursors cumulative , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, user commits , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, user calls , 346, 34.34, , , , , 2.6 per execution | |
2057 @1, GGS , STAT, recursive calls , 2, .2, , , , , 0 recursive CPU per recursive call | |
2057 @1, GGS , STAT, pinned cursors current , 1, .1, , , , , 1 actual value in end of snapshot | |
2057 @1, GGS , STAT, session logical reads , 308553, 30.62k, , , , , 308.62k total buffer visits | |
2057 @1, GGS , STAT, CPU used when call started , 821, 81.48, , , , , 8.21s total CPU used when call started | |
2057 @1, GGS , STAT, CPU used by this session , 821, 81.48, , , , , 8.21s total CPU used by this session | |
2057 @1, GGS , STAT, DB time , 972, 96.47, , , , , 7.31 per execution | |
2057 @1, GGS , STAT, user I/O wait time , 141, 13.99, , , , , 1.06 per execution | |
2057 @1, GGS , STAT, non-idle wait time , 144, 14.29, , , , , 1.08 per execution | |
2057 @1, GGS , STAT, non-idle wait count , 4697, 466.17, , , , , 35.32 per execution | |
2057 @1, GGS , STAT, messages sent , 73, 7.25, , , , , .55 per execution | |
2057 @1, GGS , STAT, enqueue requests , 1652, 163.96, , , , , 12.42 per execution | |
2057 @1, GGS , STAT, enqueue conversions , 141, 13.99, , , , , 1.06 per execution | |
2057 @1, GGS , STAT, enqueue releases , 1655, 164.25, , , , , 12.44 per execution | |
2057 @1, GGS , STAT, global enqueue gets sync , 27, 2.68, , , , , .2 per execution | |
2057 @1, GGS , STAT, global enqueue releases , 31, 3.08, , , , , .23 per execution | |
2057 @1, GGS , STAT, physical read total IO requests , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, physical read total bytes , 8192, 813.04, , , , , 61.59 per execution | |
2057 @1, GGS , STAT, physical write total IO requests , 1957, 194.23, , , , , 40.79k bytes per request | |
2057 @1, GGS , STAT, physical write total multi block requests , 224, 22.23, , , , , 1.73k total single block write requests | |
2057 @1, GGS , STAT, physical write total bytes , 79831040, 7.92M, , , , , 600.23k per execution | |
2057 @1, GGS , STAT, cell physical IO interconnect bytes , 79839232, 7.92M, , , , , 600.29k per execution | |
2057 @1, GGS , STAT, db block gets , 289498, 28.73k, , , , , 2.18k per execution | |
2057 @1, GGS , STAT, db block gets from cache , 289506, 28.73k, , , , , 2.18k per execution | |
2057 @1, GGS , STAT, db block gets from cache (fastpath) , 474, 47.04, , , , , 3.56 per execution | |
2057 @1, GGS , STAT, consistent gets , 19452, 1.93k, , , , , 146.26 per execution | |
2057 @1, GGS , STAT, consistent gets from cache , 19455, 1.93k, , , , , 146.28 per execution | |
2057 @1, GGS , STAT, consistent gets from cache (fastpath) , 15699, 1.56k, , , , , 118.04 per execution | |
2057 @1, GGS , STAT, consistent gets - examination , 3574, 354.71, , , , , 26.87 per execution | |
2057 @1, GGS , STAT, logical read bytes from cache , 2531713024, 251.27M, , , , , 19.04M per execution | |
2057 @1, GGS , STAT, physical reads , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, physical reads cache , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, physical read IO requests , 1, .1, , , , , 8.19k bytes per request | |
2057 @1, GGS , STAT, physical read bytes , 8192, 813.04, , , , , 61.59 per execution | |
2057 @1, GGS , STAT, db block changes , 65303, 6.48k, , , , , 491 per execution | |
2057 @1, GGS , STAT, consistent changes , 48306, 4.79k, , , , , 363.2 per execution | |
2057 @1, GGS , STAT, physical writes , 9745, 967.17, , , , , 73.27 per execution | |
2057 @1, GGS , STAT, physical writes direct , 9745, 967.17, , , , , 73.27 per execution | |
2057 @1, GGS , STAT, physical write IO requests , 1957, 194.23, , , , , 40.79k bytes per request | |
2057 @1, GGS , STAT, physical write bytes , 79831040, 7.92M, , , , , 600.23k per execution | |
2057 @1, GGS , STAT, physical writes non checkpoint , 9745, 967.17, , , , , 73.27 per execution | |
2057 @1, GGS , STAT, change write time , 11, 1.09, , , , , .08 per execution | |
2057 @1, GGS , STAT, free buffer requested , 10198, 1.01k, , , , , 76.68 per execution | |
2057 @1, GGS , STAT, free buffer inspected , 4, .4, , , , , .03 per execution | |
2057 @1, GGS , STAT, commit cleanouts , 207, 20.54, , , , , 1.56 per execution | |
2057 @1, GGS , STAT, commit cleanouts successfully completed , 207, 20.54, , , , , 1.56 per execution | |
2057 @1, GGS , STAT, CR blocks created , 310, 30.77, , , , , 2.33 per execution | |
2057 @1, GGS , STAT, switch current to new buffer , 135, 13.4, , , , , 1.02 per execution | |
2057 @1, GGS , STAT, physical writes direct (lob) , 9745, 967.17, , , , , 73.27 per execution | |
2057 @1, GGS , STAT, shared hash latch upgrades - no wait , 45, 4.47, , , , , .34 per execution | |
2057 @1, GGS , STAT, calls to kcmgcs , 21375, 2.12k, , , , , 160.71 per execution | |
2057 @1, GGS , STAT, calls to kcmgas , 1462, 145.1, , , , , 10.99 per execution | |
2057 @1, GGS , STAT, calls to get snapshot scn: kcmgss , 12467, 1.24k, , , , , 93.74 per execution | |
2057 @1, GGS , STAT, redo entries , 24335, 2.42k, , , , , 182.97 per execution | |
2057 @1, GGS , STAT, redo size , 84876472, 8.42M, , , , , 84.88M bytes per user commit | |
2057 @1, GGS , STAT, redo ordering marks , 12, 1.19, , , , , .09 per execution | |
2057 @1, GGS , STAT, redo subscn max counts , 45, 4.47, , , , , .34 per execution | |
2057 @1, GGS , STAT, file io wait time , 350, 34.74, , , , , .18us bad guess of IO wait time per IO request | |
2057 @1, GGS , STAT, gc local grants , 15, 1.49, , , , , .11 per execution | |
2057 @1, GGS , STAT, shared io pool buffer get success , 400, 39.7, , , , , 3.01 per execution | |
2057 @1, GGS , STAT, undo change vector size , 1482900, 147.17k, , , , , 11.15k per execution | |
2057 @1, GGS , STAT, no work - consistent read gets , 253, 25.11, , , , , 1.9 per execution | |
2057 @1, GGS , STAT, immediate (CURRENT) block cleanout applications , 97, 9.63, , , , , .73 per execution | |
2057 @1, GGS , STAT, deferred (CURRENT) block cleanout applications , 95, 9.43, , , , , .71 per execution | |
2057 @1, GGS , STAT, min active SCN optimization applied on CR , 4, .4, , , , , .03 per execution | |
2057 @1, GGS , STAT, commit wait/nowait requested , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, commit nowait requested , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, commit wait/nowait performed , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, commit nowait performed , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, segment dispenser load tasks , 12, 1.19, , , , , .09 per execution | |
2057 @1, GGS , STAT, segment dispenser allocations , 85, 8.44, , , , , .64 per execution | |
2057 @1, GGS , STAT, segment cfs allocations , 14, 1.39, , , , , .11 per execution | |
2057 @1, GGS , STAT, segment chunks allocation from disepnser , 1932, 191.75, , , , , 14.53 per execution | |
2057 @1, GGS , STAT, segment prealloc tasks , 12, 1.19, , , , , .09 per execution | |
2057 @1, GGS , STAT, table fetch by rowid , 134, 13.3, , , , , 1.01 per execution | |
2057 @1, GGS , STAT, table fetch continued row , 49, 4.86, , , , , .37 per execution | |
2057 @1, GGS , STAT, index crx upgrade (positioned) , 46, 4.57, , , , , .35 per execution | |
2057 @1, GGS , STAT, lob reads , 9695, 962.2, , , , , 72.89 per execution | |
2057 @1, GGS , STAT, lob writes , 70, 6.95, , , , , .53 per execution | |
2057 @1, GGS , STAT, index fetch by key , 71, 7.05, , , , , .53 per execution | |
2057 @1, GGS , STAT, index scans kdiixs1 , 109, 10.82, , , , , .82 per execution | |
2057 @1, GGS , STAT, HSC Heap Segment Block Changes , 175, 17.37, , , , , 1.32 per execution | |
2057 @1, GGS , STAT, securefile allocation bytes , 81002496, 8.04M, , , , , 609.04k per execution | |
2057 @1, GGS , STAT, securefile allocation chunks , 1932, 191.75, , , , , 14.53 per execution | |
2057 @1, GGS , STAT, securefile direct write bytes , 81002496, 8.04M, , , , , 609.04k per execution | |
2057 @1, GGS , STAT, securefile direct write ops , 1964, 194.92, , , , , 14.77 per execution | |
2057 @1, GGS , STAT, securefile create dedup set , 71, 7.05, , , , , .53 per execution | |
2057 @1, GGS , STAT, securefile destroy dedup set , 71, 7.05, , , , , .53 per execution | |
2057 @1, GGS , STAT, securefile dedup prefix hash match , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, securefile number of flushes , 70, 6.95, , , , , .53 per execution | |
2057 @1, GGS , STAT, securefile dedup callback oper final , 70, 6.95, , , , , .53 per execution | |
2057 @1, GGS , STAT, session cursor cache hits , 1, .1, , , , , 0 softparses avoided thanks to cursor cache | |
2057 @1, GGS , STAT, buffer is pinned count , 63, 6.25, , , , , .02 % buffer gets avoided thanks to buffer pin caching | |
2057 @1, GGS , STAT, buffer is not pinned count , 445, 44.17, , , , , 3.35 per execution | |
2057 @1, GGS , STAT, parse count (total) , 1, .1, , , , , ~ softparses per hardparse | |
2057 @1, GGS , STAT, execute count , 133, 13.2, , , , , 133 executions per parse | |
2057 @1, GGS , STAT, bytes sent via SQL*Net to client , 61948, 6.15k, , , , , 180.08 bytes per roundtrip | |
2057 @1, GGS , STAT, bytes received via SQL*Net from client , 78834918, 7.82M, , , , , 229.17k bytes per roundtrip | |
2057 @1, GGS , STAT, SQL*Net roundtrips to/from client , 344, 34.14, , , , , 2.59 per execution | |
2057 @1, GGS , TIME, repeated bind elapsed time , 372, 36.92us, .0%, [ ], , , | |
2057 @1, GGS , TIME, parse time elapsed , 25, 2.48us, .0%, [ ], , , | |
2057 @1, GGS , TIME, DB CPU , 8306737, 824.42ms, 82.4%, [@@@@@@@@@ ], , , | |
2057 @1, GGS , TIME, sql execute elapsed time , 2081858, 206.62ms, 20.7%, [### ], , , | |
2057 @1, GGS , TIME, DB time , 9657807, 958.51ms, 95.9%, [##########], , , .21 % unaccounted time | |
2057 @1, GGS , WAIT, buffer busy waits , 97, 9.63us, .0%, [ ], 3, .3, 32.33us average wait | |
2057 @1, GGS , WAIT, db file sequential read , 349, 34.64us, .0%, [ ], 1, .1, 349us average wait | |
2057 @1, GGS , WAIT, direct path write , 1406767, 139.62ms, 14.0%, [WW ], 1955, 194.03, 719.57us average wait | |
2057 @1, GGS , WAIT, SQL*Net message to client , 427, 42.38us, .0%, [ ], 344, 34.14, 1.24us average wait | |
2057 @1, GGS , WAIT, SQL*Net message from client , 396995, 39.4ms, 3.9%, [W ], 344, 34.14, 1.15ms average wait | |
2057 @1, GGS , WAIT, SQL*Net more data from client , 34253, 3.4ms, .3%, [ ], 2371, 235.32, 14.45us average wait | |
-- End of Stats snap 1, end=2022-04-01 03:50:39, seconds=10.1 | |
2057 @1, GGS , STAT, Requests to/from client , 358, 35.52, , , , , 2.58 per execution | |
2057 @1, GGS , STAT, opened cursors cumulative , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, user commits , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, user calls , 359, 35.62, , , , , 2.59 per execution | |
2057 @1, GGS , STAT, recursive calls , 4, .4, , , , , 0 recursive CPU per recursive call | |
2057 @1, GGS , STAT, pinned cursors current , -1, -.1, , , , , 0 actual value in end of snapshot | |
2057 @1, GGS , STAT, session logical reads , 407698, 40.45k, , , , , 716.38k total buffer visits | |
2057 @1, GGS , STAT, CPU used when call started , 760, 75.4, , , , , 15.81s total CPU used when call started | |
2057 @1, GGS , STAT, CPU used by this session , 760, 75.4, , , , , 15.81s total CPU used by this session | |
2057 @1, GGS , STAT, DB time , 963, 95.54, , , , , 7.11 per execution | |
2057 @1, GGS , STAT, user I/O wait time , 206, 20.44, , , , , 1.28 per execution | |
2057 @1, GGS , STAT, non-idle wait time , 209, 20.73, , , , , 1.3 per execution | |
2057 @1, GGS , STAT, non-idle wait count , 5838, 579.17, , , , , 38.73 per execution | |
2057 @1, GGS , STAT, messages sent , 92, 9.13, , , , , .61 per execution | |
2057 @1, GGS , STAT, session pga memory , -327680, -32.51k, , , , , -327.68k actual value in end of snapshot | |
2057 @1, GGS , STAT, enqueue requests , 2593, 257.24, , , , , 15.61 per execution | |
2057 @1, GGS , STAT, enqueue conversions , 145, 14.38, , , , , 1.05 per execution | |
2057 @1, GGS , STAT, enqueue releases , 2594, 257.34, , , , , 15.62 per execution | |
2057 @1, GGS , STAT, global enqueue gets sync , 25, 2.48, , , , , .19 per execution | |
2057 @1, GGS , STAT, global enqueue releases , 25, 2.48, , , , , .21 per execution | |
2057 @1, GGS , STAT, physical read total IO requests , 4, .4, , , , , .02 per execution | |
2057 @1, GGS , STAT, physical read total bytes , 32768, 3.25k, , , , , 150.59 per execution | |
2057 @1, GGS , STAT, physical write total IO requests , 3078, 305.36, , , , , 31.87k bytes per request | |
2057 @1, GGS , STAT, physical write total multi block requests , 162, 16.07, , , , , 4.65k total single block write requests | |
2057 @1, GGS , STAT, physical write total bytes , 80625664, 8M, , , , , 589.91k per execution | |
2057 @1, GGS , STAT, cell physical IO interconnect bytes , 80658432, 8M, , , , , 590.06k per execution | |
2057 @1, GGS , STAT, db block gets , 383669, 38.06k, , , , , 2.47k per execution | |
2057 @1, GGS , STAT, db block gets from cache , 383661, 38.06k, , , , , 2.47k per execution | |
2057 @1, GGS , STAT, db block gets from cache (fastpath) , 484, 48.02, , , , , 3.52 per execution | |
2057 @1, GGS , STAT, consistent gets , 23626, 2.34k, , , , , 158.38 per execution | |
2057 @1, GGS , STAT, consistent gets from cache , 23623, 2.34k, , , , , 158.38 per execution | |
2057 @1, GGS , STAT, consistent gets from cache (fastpath) , 18845, 1.87k, , , , , 127 per execution | |
2057 @1, GGS , STAT, consistent gets - examination , 4577, 454.07, , , , , 29.97 per execution | |
2057 @1, GGS , STAT, logical read bytes from cache , 3335766016, 330.93M, , , , , 21.57M per execution | |
2057 @1, GGS , STAT, physical reads , 4, .4, , , , , .02 per execution | |
2057 @1, GGS , STAT, physical reads cache , 4, .4, , , , , .02 per execution | |
2057 @1, GGS , STAT, physical read IO requests , 4, .4, , , , , 8.19k bytes per request | |
2057 @1, GGS , STAT, physical read bytes , 32768, 3.25k, , , , , 150.59 per execution | |
2057 @1, GGS , STAT, db block changes , 73726, 7.31k, , , , , 511.14 per execution | |
2057 @1, GGS , STAT, consistent changes , 48411, 4.8k, , , , , 355.58 per execution | |
2057 @1, GGS , STAT, physical writes , 9842, 976.39, , , , , 72.01 per execution | |
2057 @1, GGS , STAT, physical writes direct , 9842, 976.39, , , , , 72.01 per execution | |
2057 @1, GGS , STAT, physical write IO requests , 3078, 305.36, , , , , 31.87k bytes per request | |
2057 @1, GGS , STAT, physical write bytes , 80625664, 8M, , , , , 589.91k per execution | |
2057 @1, GGS , STAT, physical writes non checkpoint , 9842, 976.39, , , , , 72.01 per execution | |
2057 @1, GGS , STAT, change write time , 21, 2.08, , , , , .12 per execution | |
2057 @1, GGS , STAT, free buffer requested , 10684, 1.06k, , , , , 76.77 per execution | |
2057 @1, GGS , STAT, dirty buffers inspected , 2, .2, , , , , .01 per execution | |
2057 @1, GGS , STAT, free buffer inspected , 6, .6, , , , , .04 per execution | |
2057 @1, GGS , STAT, commit cleanouts , 201, 19.94, , , , , 1.5 per execution | |
2057 @1, GGS , STAT, commit cleanouts successfully completed , 201, 19.94, , , , , 1.5 per execution | |
2057 @1, GGS , STAT, CR blocks created , 894, 88.69, , , , , 4.43 per execution | |
2057 @1, GGS , STAT, switch current to new buffer , 142, 14.09, , , , , 1.02 per execution | |
2057 @1, GGS , STAT, physical writes direct (lob) , 9842, 976.39, , , , , 72.01 per execution | |
2057 @1, GGS , STAT, shared hash latch upgrades - no wait , 44, 4.37, , , , , .33 per execution | |
2057 @1, GGS , STAT, calls to kcmgcs , 30620, 3.04k, , , , , 191.16 per execution | |
2057 @1, GGS , STAT, calls to kcmgas , 2931, 290.77, , , , , 16.15 per execution | |
2057 @1, GGS , STAT, calls to get snapshot scn: kcmgss , 13188, 1.31k, , , , , 94.32 per execution | |
2057 @1, GGS , STAT, redo entries , 31928, 3.17k, , , , , 206.85 per execution | |
2057 @1, GGS , STAT, redo size , 87941584, 8.72M, , , , , 86.41M bytes per user commit | |
2057 @1, GGS , STAT, redo ordering marks , 24, 2.38, , , , , .13 per execution | |
2057 @1, GGS , STAT, redo subscn max counts , 39, 3.87, , , , , .31 per execution | |
2057 @1, GGS , STAT, file io wait time , 2035, 201.88, , , , , .47us bad guess of IO wait time per IO request | |
2057 @1, GGS , STAT, gc local grants , 40, 3.97, , , , , .2 per execution | |
2057 @1, GGS , STAT, shared io pool buffer get success , 415, 41.17, , , , , 3 per execution | |
2057 @1, GGS , STAT, undo change vector size , 2164340, 214.72k, , , , , 13.41k per execution | |
2057 @1, GGS , STAT, no work - consistent read gets , 250, 24.8, , , , , 1.85 per execution | |
2057 @1, GGS , STAT, immediate (CURRENT) block cleanout applications , 100, 9.92, , , , , .72 per execution | |
2057 @1, GGS , STAT, deferred (CURRENT) block cleanout applications , 92, 9.13, , , , , .69 per execution | |
2057 @1, GGS , STAT, min active SCN optimization applied on CR , 3, .3, , , , , .03 per execution | |
2057 @1, GGS , STAT, commit wait/nowait requested , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, commit nowait requested , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, commit wait/nowait performed , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, commit nowait performed , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, segment dispenser load tasks , 18, 1.79, , , , , .11 per execution | |
2057 @1, GGS , STAT, segment dispenser allocations , 93, 9.23, , , , , .65 per execution | |
2057 @1, GGS , STAT, segment cfs allocations , 30, 2.98, , , , , .16 per execution | |
2057 @1, GGS , STAT, segment chunks allocation from disepnser , 3049, 302.48, , , , , 18.31 per execution | |
2057 @1, GGS , STAT, segment prealloc tasks , 18, 1.79, , , , , .11 per execution | |
2057 @1, GGS , STAT, table fetch by rowid , 138, 13.69, , , , , 1 per execution | |
2057 @1, GGS , STAT, table fetch continued row , 38, 3.77, , , , , .32 per execution | |
2057 @1, GGS , STAT, index crx upgrade (positioned) , 43, 4.27, , , , , .33 per execution | |
2057 @1, GGS , STAT, lob reads , 9608, 953.17, , , , , 70.97 per execution | |
2057 @1, GGS , STAT, lob writes , 72, 7.14, , , , , .52 per execution | |
2057 @1, GGS , STAT, lob writes unaligned , 1, .1, , , , , 0 per execution | |
2057 @1, GGS , STAT, index fetch by key , 73, 7.24, , , , , .53 per execution | |
2057 @1, GGS , STAT, index scans kdiixs1 , 109, 10.81, , , , , .8 per execution | |
2057 @1, GGS , STAT, heap block compress , 1, .1, , , , , 0 per execution | |
2057 @1, GGS , STAT, HSC Heap Segment Block Changes , 179, 17.76, , , , , 1.3 per execution | |
2057 @1, GGS , STAT, securefile allocation bytes , 79454208, 7.88M, , , , , 589.91k per execution | |
2057 @1, GGS , STAT, securefile allocation chunks , 3049, 302.48, , , , , 18.31 per execution | |
2057 @1, GGS , STAT, securefile direct write bytes , 79454208, 7.88M, , , , , 589.91k per execution | |
2057 @1, GGS , STAT, securefile direct write ops , 3071, 304.66, , , , , 18.51 per execution | |
2057 @1, GGS , STAT, securefile create dedup set , 72, 7.14, , , , , .53 per execution | |
2057 @1, GGS , STAT, securefile destroy dedup set , 72, 7.14, , , , , .53 per execution | |
2057 @1, GGS , STAT, securefile dedup prefix hash match , 1, .1, , , , , .01 per execution | |
2057 @1, GGS , STAT, securefile number of flushes , 72, 7.14, , , , , .52 per execution | |
2057 @1, GGS , STAT, securefile dedup callback oper final , 71, 7.04, , , , , .52 per execution | |
2057 @1, GGS , STAT, session cursor cache hits , 1, .1, , , , , 0 softparses avoided thanks to cursor cache | |
2057 @1, GGS , STAT, buffer is pinned count , 67, 6.65, , , , , .02 % buffer gets avoided thanks to buffer pin caching | |
2057 @1, GGS , STAT, buffer is not pinned count , 453, 44.94, , , , , 3.3 per execution | |
2057 @1, GGS , STAT, parse count (total) , 1, .1, , , , , ~ softparses per hardparse | |
2057 @1, GGS , STAT, execute count , 139, 13.79, , , , , 136 executions per parse | |
2057 @1, GGS , STAT, bytes sent via SQL*Net to client , 64532, 6.4k, , , , , 180.17 bytes per roundtrip | |
2057 @1, GGS , STAT, bytes received via SQL*Net from client , 78541879, 7.79M, , , , , 224.18k bytes per roundtrip | |
2057 @1, GGS , STAT, SQL*Net roundtrips to/from client , 358, 35.52, , , , , 2.58 per execution | |
2057 @1, GGS , TIME, repeated bind elapsed time , 474, 47.02us, .0%, [ ], , , | |
2057 @1, GGS , TIME, parse time elapsed , 18, 1.79us, .0%, [ ], , , | |
2057 @1, GGS , TIME, DB CPU , 7766820, 770.52ms, 77.1%, [@@@@@@@@ ], , , | |
2057 @1, GGS , TIME, sql execute elapsed time , 2852053, 282.94ms, 28.3%, [### ], , , | |
2057 @1, GGS , TIME, DB time , 9724652, 964.75ms, 96.5%, [##########], , , -99.89 % unaccounted time | |
2057 @1, GGS , WAIT, local write wait , 25995, 2.58ms, .3%, [ ], 8, .79, 3.25ms average wait | |
2057 @1, GGS , WAIT, buffer busy waits , 279, 27.68us, .0%, [ ], 10, .99, 27.9us average wait | |
2057 @1, GGS , WAIT, db file sequential read , 2033, 201.69us, .0%, [ ], 4, .4, 508.25us average wait | |
2057 @1, GGS , WAIT, direct path write , 2022581, 200.65ms, 20.1%, [WW ], 3071, 304.66, 658.61us average wait | |
2057 @1, GGS , WAIT, SQL*Net message to client , 390, 38.69us, .0%, [ ], 358, 35.52, 1.09us average wait | |
2057 @1, GGS , WAIT, SQL*Net message from client , 369534, 36.66ms, 3.7%, [W ], 358, 35.52, 1.03ms average wait | |
2057 @1, GGS , WAIT, SQL*Net more data from client , 31943, 3.17ms, .3%, [ ], 2367, 234.82, 13.5us average wait | |
-- End of Stats snap 2, end=2022-04-01 03:50:49, seconds=10.1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment