Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: explain plan changes if using bind vars

Re: explain plan changes if using bind vars

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Tue, 02 Aug 2005 17:36:30 GMT
Message-ID: <42efaef7.1219554750@localhost>


On 2 Aug 2005 10:18:30 -0700, "AK" <AK_TIREDOFSPAM_at_hotmail.COM> wrote:

>I used /*+ CURSOR_SHARING_EXACT */ in a similar situation
>

Great.. didn't know this existed.
This will work for now, and won't look as ugly as wrapping with to alter session statements.

Thanks.
.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Aug 02 2005 - 12:36:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US