v$sgastat and shared_pool_size inconsistency

  • From: "LS Cheng" <exriscer@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 22 Aug 2006 11:19:15 +0200

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2006