Re: Binding Variable Benefit Across Sessions ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 5 Apr 2002 19:37:37 +0200
Message-ID: <uarp37lbe4cp51@corp.supernews.com>

"R Chin" <rchin_at_panix.com> wrote in message news:a8kenf$nm6$1_at_news.panix.com...
> I understand that BV is important and all....
>
> My question is :
> If Session A runs my PL/SQL program that issues ONE single
> SQL that I took the "pain" to use BV.
>
> Then Session B logs in (shortly) and exec the SAME
> program, Is this session going to benefit
> from User A's session by virtue of the BV
> used in that session ?
> i.e. Is session B able to avoid the hard parse ? how about soft p.
possible
> ?
>
> Are the benefits ONLY realized in the current session then "wiped clean" ?
>
> Thanks
>
> Robert
>
>

No, if the statement in session B has the same hash_value (ie is *exactly* identical), you will at least avoid the hard parse. You can see that in v$sqlarea, if you order your statements by hash_value, address and sid.

Hth Received on Fri Apr 05 2002 - 11:37:37 CST