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