Interestingly enough, a company like the one I work for is getting a lot of business from assisting in performance optimizing, where the real cause of the problems is poorly written applications. Personally, I would much rather advise people in how to design and produce applications rather than pointing out at a far too late stage, that mistakes have been made very early in the process.
/Bjørn.
Jamadagni, Rajendra wrote:
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!-----Original Message-----Seems like we are starting Yet Another Bind Discussion!
From: Bjørn Engsig [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 11, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Oracle position on hints
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.
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
