: Multiple recipients of list ORACLE-L
> Subject: RE: Cursor Sharing Continued
>
>
>
> Rich, you don't mind providing more info on 2225065 ? You
> mean its not even fixed in 8.1.7.4 ?
>
> Can you provide a bit more on the circ
Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Johnson, Michael [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 25, 2002 7:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Cursor Sharing Continued
>
>
> Setting i
Michael - So . . . since you have a work-around that is relatively easy from
the developer point of view, how do you plan to convince them to rewrite
their programs? Or do you have a really big hammer?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursda
Take your case to management with that statistics
of how long queries take with and without bind
variables. Let them decide when to make the
developers re-code their apps. If your management
doesnt make them correct it then I dont know what
to say from there.My management has said "It w
l [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 25, 2002 7:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Cursor Sharing Continued
>
>
> Setting it to Force worked well as the
> pool has been cleared on many queries
> using literals any many of those hard
Setting it to Force worked well as the
pool has been cleared on many queries
using literals any many of those hard
parses went away. So far ... So good.
I aint sayin nothin to the developers
although some have already noticed an
improvement.
I am going to put the hammer down on
them to rewrit