Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> v$sgastat and shared_pool_size inconsistency
Hi
Anyone know why v$sgastat shows a different shared pool value than the parameter?
I have a 8.1.74 database in HP-UX:
show parameter shared_pool
shared_pool_size string 1572864000
select sum(bytes)/(1024*1024) value from v$sgastat where pool = 'shared pool';
VALUE
2086
in 9.2.0.7
show parameter shared_pool
shared_pool_size big integer 1577058304
select sum(bytes)/(1024*1024) value from v$sgastat where pool = 'shared pool';
VALUE
2256
The difference is huge, 500mb and 700mb aproximately.
Cheers
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 22 2006 - 04:19:15 CDT
![]() |
![]() |