| Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi [message #521817] |
Fri, 02 September 2011 05:15  |
 |
msol25
Messages: 396
Registered: June 2011
|
Senior Member |
|
|
hi,
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
[code}
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.
[/code]
but it should match?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
