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

On Sat, 31 May 2003 22:35:13 +0000, Holger Marzen wrote:

> We run a customer's application on Oracle 8.1.7. From time to time it's
> not possible to log in anymore. The shared seems to be fragmented. A
> restart of the instance helps, but then the application has to be
> restarted as well.
>
> Is it possible to de-fragment the shared pool or at least clear it while
> the instance is up and the application stays connected?

Have you tried "alter system flush shared_pool;"? It's an emergency solution only, but can make your instance survive until the next maintenance.

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