Re: Who and What is using the shared pool.

From: Kathryn L. Zimmerman <kzimmer1_at_csc.com>
Date: Tue, 22 Aug 2000 12:54:40 -0400
Message-Id: <10597.115238@fatcity.com>

>
> You aren't dreaming. You are thinking of cursor_sharing=force. Default is
> exact, which is the pre 8.1.6 way. I haven't used it myself, but I know of
> someone that recommended it to a customer that had an application not using
> bind variables, the performance was very bad and they were already in
> production. From what I understand, it shouldn't be used in place of bind
> variables, since the cbo may choose sub-optimal plans.
>

This may be something to check, then, along with the thing about buckets and hashing that made my eyes go around in my head. It may not be a perfect solution, but may help.

Diana said, among other things:

>
> ... Oracle ... smarter

Oxymoron?

:::: running away cackling madly ::::

KLZ
Certified ORACLE Geezer Received on Tue Aug 22 2000 - 11:54:40 CDT