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: Binding Variable Benefit Across Sessions ?

Re: Binding Variable Benefit Across Sessions ?

From: R Chin <rchin_at_panix.com>
Date: Fri, 5 Apr 2002 14:36:26 -0500
Message-ID: <a8kua5$52t$1@news.panix.com>


Thanks guys !
I should have said 'ONE single DYNAMIC SQL'

So if SessionA fired 'select X form TABOA where X = :w' and SessionB fired 'select Y form TABOA where X = :z'

Now the hash_values are different, no ?
is there gonna be a hard parse then ?

robert

Sybrand Bakker wrote in message ...
>No, if the statement in session B has the same hash_value (ie is *exactly*
>identical), you will at least avoid the hard parse.

Thomas Kyte wrote in message ...
>
>session b will avoid the hard parse.
>the soft parse is unavoidable -- you gotta get started somehow.
Received on Fri Apr 05 2002 - 13:36:26 CST

Original text of this message

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