I recently used it on 8.1.7.4 and 9i.
I gained 33% performance gain. It would be different depending on how
much literal SQL is used in your code.
My process ran fine, and I was able to load the data. However, I have
not fully checked the data yet.
Shakir
- "Johnson, Michael " <Michael.Johnson_at_oln-afmc.af.mil> wrote:
> I went thru this recently ...
>
> The best thing to do is to FORCE the developers to use
> bind variables and then this is no longer an issue.
>
> If you do set it to FORCE , I believe there is a problem
> with it in versions 8.1.6 and before and it should not be
> used. Double Check with Metalink on this.
>
> FWIW ... Mike
>
> -----Original Message-----
> Sent: Friday, September 27, 2002 1:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
> We are looking into setting up cursor_sharing parameter to FORCE.
> Has
> anyone seen any bad effects of setting Cursor_sharing=FORCE. Are
> there any
> real bad effects of setting it..?
>
> I was thinking of going back to my developers and make them use bind
> variables in their code.
> If I set the above parameter, they may continue to develop their code
> the
> way it is now.
>
> Let me know what you all think about it..
>
> Thanks in advance,
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nat
> INET: nat2710_at_hotmail.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Johnson, Michael
> INET: Michael.Johnson_at_oln-afmc.af.mil
>
> 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).
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammed Shakir
INET: mshakir08816_at_yahoo.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 Fri Sep 27 2002 - 17:03:46 CDT