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