Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle position on hints
I doubt there are "some incorrectly applications", I think that is a rule
rather than an exception.
Raj
-----Original Message-----
Sent: Tuesday, March 11, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
Seems like we are starting Yet Another Bind Discussion!
Anyway, the peeking into bind variables is basically done when a hard parse is done. Hence, if multiple sessions execute the same shared SQL statement, only the first one will actually do the peek and hence, the optimization for all executions in all sessions will be as this first one.
In my opinion, cursor_sharing and bind variable peeking should be useless features. However, I realize there are some incorrectly written applications out there that can have marginal need for them.
/Bjørn.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Mar 11 2003 - 11:55:39 CST
- text/plain attachment: ESPN_Disclaimer.txt