Re: Shared Pool: Can it be filled *over* 100% ? - maybe a solution ...

• Post for FREE via your newsreader at post.usenet.com ****

Hi Jan

> SQL> select name, value from v$parameter
> 2 where name like 'shared_pool%';
>
> NAME
> ----------------------------------------------
> VALUE
> ----------------------------------------------
> shared_pool_size
> 100000000
>
> shared_pool_reserved_size
> 10000000
>
> Now I am not sure: is shared_pool_reserved_size
> *a part of* the shared pool size as defined
> or is it *added* to it ?

The reserved size is part of it.

Did you missed by posts? As I wrote, the shared pool size is probably bigger than the parameter shared_pool_size. Now, that I see your configuration, I'm sure about that. Oracle will NEVER create a shared pool of 100000000 bytes! It will round up the value to something like 106943288. Just check it with:

select sum(bytes) from v$sgastat where pool = 'shared pool'

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=