how we can match variable sga using v$sga and v$sgastat views [message #521832] |
Fri, 02 September 2011 05:29 |
|
msol25
Messages: 396 Registered: June 2011
|
Senior Member |
|
|
I am querrying v$sga and getting variable size : 211337216 bytes.when querrying
v$sgastat then getting
java Pool : 16777216
Large Pool : 41943040
Shared pool : 398560392
But as per my knowledge following condition should satisfy,but not getting
Variable sga = java pool + large pool + shared pool
select pool,name,sum(bytes)
from v$sgastat
where pool in ('shared pool','java pool','large pool')
group by pool,name;
Here variable size using v$sga : 211337216 bytes
and java pool + large pool + shared pool : 211302536 bytes.
but it should match?
|
|
|
|
|
|
|
|
|
|
|
|
|