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

From: http://www.webyourcompany.com <xzhang88_at_hotmail.com>
Date: 31 May 2003 23:02:08 -0700
Message-ID: <2f50b64b.0305312202.4c1f2b0d@posting.google.com>

Please set up statspack and to diagnose and then correctt it. If it's due to not using bind variables, then try to set CURSOR_SHARING=FORCE as a temporary solution until you totally fix the root cause Please check all the log files to see if you have any ORA ERROR.

HTH,
http://www.webyourcompany.com

Holger Marzen <holger_at_marzen.de> wrote in message news:<bbban1$gos$1_at_bluebell.marzen.de>...
> 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?
Received on Sun Jun 01 2003 - 01:02:08 CDT