1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
SQL> SELECT name, gets, misses,
2 immediate_gets, immediate_misses, sleeps, 'Ratio of MISSES to GETS: '||
3 round((sum(misses)/(sum(gets)+0.00000000001) * 100),2)||'%', 'Ratio of IMMEDIATE_MISSES to IMMEDIATE_GETS: '||
4 round((sum(immediate_misses)/
5 (sum(immediate_misses+immediate_gets)+0.00000000001) * 100),2)||'%'
6 FROM v$latch
7 WHERE name IN ('redo allocation', 'redo copy')
8 GROUP BY name, gets, misses,immediate_gets, immediate_misses, sleeps;
NAME GETS
---------------------------------------------------------------- ----------
MISSES IMMEDIATE_GETS IMMEDIATE_MISSES SLEEPS
---------- -------------- ---------------- ----------
'RATIOOFMISSESTOGETS:'||ROUND((SUM(MISSES)/(SUM(GETS)+0.0000000000
------------------------------------------------------------------
'RATIOOFIMMEDIATE_MISSESTOIMMEDIATE_GETS:'||ROUND((SUM(IMMEDIATE_MISSES)/(SUM(IM
--------------------------------------------------------------------------------
redo copy 3232
0 87739 66 0
Ratio of MISSES to GETS: 0%
Ratio of IMMEDIATE_MISSES to IMMEDIATE_GETS: .08%
NAME GETS
---------------------------------------------------------------- ----------
MISSES IMMEDIATE_GETS IMMEDIATE_MISSES SLEEPS
---------- -------------- ---------------- ----------
'RATIOOFMISSESTOGETS:'||ROUND((SUM(MISSES)/(SUM(GETS)+0.0000000000
------------------------------------------------------------------
'RATIOOFIMMEDIATE_MISSESTOIMMEDIATE_GETS:'||ROUND((SUM(IMMEDIATE_MISSES)/(SUM(IM
--------------------------------------------------------------------------------
redo allocation 93273
7 0 0 0
Ratio of MISSES to GETS: .01%
Ratio of IMMEDIATE_MISSES to IMMEDIATE_GETS: 0% |
Partager