Re: anyone using shared_cursors=FORCE under 8.1.6?

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Wed, 11 Oct 2000 08:47:18 +0200
Message-ID: <39E40CF6.79DE6AD1@0800-einwahl.de>

Hi Dave,

yes, I found that selecting from all_objects or from some other system views yield ORA-00600 [17182]. I switched it off and the problem was gone.

I suppose it has something to do with synonyms because these synonyms affect the name scope that has to be scanned for identifiers.

Martin

Dave A wrote:
>
> We have an application that is very high transaction which uses no bind
> variables. The sqlarea portion of the library cache had a hit ratio around
> 45%. We set shared_cursors=FORCE in our init.ora and after a week of being
> up the ratio is now 97.8%
>
> Wondering if anyone else is using this parameter and if so, have there been
> any problems that you have noticed other than some statements may choose an
> undesireable execution plan (which we have not noticed)
>
> --
> Dave A
Received on Wed Oct 11 2000 - 01:47:18 CDT