Re: shared pool size

chao_ping wrote:
>
> Nomatter you hit bug or not, 4M shared pool size is rather too small for
> any application, not to mention that oracle designer, which heavily used
> the shared pool. According to the memory of your machine, give it
> min{50M,4/1 of your memory} is needed.
>

Hmmm whole new way of determining how big your shared pool should be? 4 times your machines memory? Gues that's a typo, and 1/4th was meant, but the principle remains...

25 to 30MB would suffice, if you're the one user. Else, just read the fine material that comes with Designer; all hardware and SGA considerations are listed.

-- 
Gtrz,

Frank van Bortel