Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle position on hints

Re: Oracle position on hints

From: Bjørn Engsig <>
Date: Wed, 12 Mar 2003 03:48:40 -0800
Message-ID: <>

Undskyld, I should have added a wide ironic smily. I am very much aware of the far too many poorly written applications out there - you are sometimes amazed that even large software producing companies seem to thoroughly make every effort to produce bad code or simply ignore well established guidelines.

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.


Jamadagni, Rajendra wrote:

> I doubt there are "some incorrectly applications", I think that is a
> rule rather than an exception.
> Raj
> -------------------------------------------------------------
> 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-----
> From: Bjørn Engsig []
> Sent: Tuesday, March 11, 2003 12:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle position on hints
> 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.
>********************************************************************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

Bjørn Engsig, Miracle A/S
Member of Oak Table Network <> -

Please see the official ORACLE-L FAQ:
Author: =?ISO-8859-1?Q?Bj=F8rn_Engsig?=

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Wed Mar 12 2003 - 05:48:40 CST

Original text of this message