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