Binding Variable Benefit Across Sessions ?

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 Received on Fri Apr 05 2002 - 09:10:27 CST