Which is the actual shared pool size?

Hi,

When i execute the following sql, I get 33,554,432 bytes.   SELECT * FROM v$system_parameter WHERE NAME = 'shared_pool_size';

But when i execute the following sql, I get 67,108,864 bytes.   SELECT pool, SUM(bytes)
  FROM v$sgastat
  WHERE pool = 'shared pool'
  GROUP BY pool;

So, I'm confuse on which is the actual size of the shared pool in SGA.

Please advice. Thank you.

Best Regards,
Jeffrey Yee Received on Sun Aug 03 2003 - 21:08:28 CDT