Re: Oracle 8.1.7: shared pool fragmented - can I clear it on-the-fly?

On Sun, 01 Jun 2003 10:36:17 +0000, Holger Marzen wrote:

>> maybe try to allocate a bigger dedicated space for large PL/SQL blocks
>> (someting like "shared_pool_reserved_size").

Also, make sure that you don't have CURSOR_SPACE_FOR_TIME set to true. Believe it or not, I've frequently found that parameter set on the instances with shared pool problems.

-- 
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds