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

From: Holger Marzen <holger_at_marzen.de>
Date: 7 Jun 2003 10:41:30 GMT
Message-ID: <bbsfgq$8q1$1@bluebell.marzen.de>

On Sun, 01 Jun 2003 18:35:39 GMT, Mladen Gogala wrote:

> 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.

There is another installation without these problems, it runs 8.1.7.4 instead of our 8.1.7.3. I'll upgrade and see if it was simply a bug that has been fixed. Received on Sat Jun 07 2003 - 05:41:30 CDT