Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: shared pool kghupr1

Re: shared pool kghupr1

From: Fred DENIS <forums_at_oradream.com>
Date: Thu, 25 Mar 2004 20:44:11 +0100
Message-ID: <4063367d$0$5580$626a14ce@news.free.fr>


"Brian Peasland" <dba_at_remove_spam.peasland.com> a écrit dans le message de news:4062FF4E.FCAF89DA_at_remove_spam.peasland.com...
> As in many cases, if one doesn't understand these sorts of things, a
> quick search of Steve Adams' web site helps a lot!
>
> http://www.ixora.com.au/newsletter/2001_02.htm
>
> As this article suggests, you might want to see if the application is
> rebinding values excessively.
>
> HTH,
> Brian
>

Sure, a look at Steve Adams' always help :-)

Anyway, i am a bit surprised about this article you pointed out : Why - and how !? - the application can "re bind" a SQL statement ?

"The only possibility that we could think of was if the application was consistently rebinding each cursor prior to re-execution" => ?

Thx by advance, Received on Thu Mar 25 2004 - 13:44:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US