Re: Binding Variable Benefit Across Sessions ?

In article <a8kenf$nm6$1_at_news.panix.com>, "R says...
>
>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
>?

session b will avoid the hard parse.

the soft parse is unavoidable -- you gotta get started somehow.

>
>Are the benefits ONLY realized in the current session then "wiped clean" ?
>

nope.

>Thanks
>
>Robert
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp