Axton,
When we set up our 7.1 servers a couple years ago, I set our cursor sharing
to "similar" based on the BMC white paper:
"Best practices mandate specifically that, with 6.0.1, users should use
force, and *with 6.3 or 7.0, users should use similar*, but the difference
between the two settings is small."
In the dba-oracle.com link you sent, there's a note:
Note: The cursor_sharing=similar option has been deprecated in Oracle 11g
and will be removed in version 12 per MOSC Note 1169017.1
In your opinion (I'm not experienced enough in this area), should I change
the setting on my servers to "force" now, or wait until we need to upgrade
the database (we're on 10g now)? Do you think I'd see any performance
improvements (CMDB2.1 and full ITSM 7.0.3 on ARS 7.1)?
Thanks,
Thad
On Fri, Dec 3, 2010 at 9:01 AM, Axton <[email protected]> wrote:
> ** http://www.dba-oracle.com/t_cursor_sharing.htm
>
> <http://www.dba-oracle.com/t_cursor_sharing.htm>This is something I wrote
> up years ago on the subject:
>
> http://arswiki.org/wiki/Oracle_Performance_Tuning#Cursor_Sharing.2FBind_Variables
>
>
> <http://arswiki.org/wiki/Oracle_Performance_Tuning#Cursor_Sharing.2FBind_Variables>
> Axton
>
> On Fri, Dec 3, 2010 at 10:05 AM, Arshad M <[email protected]> wrote:
>
>> Hi Dave,
>>
>> Thanks for response.
>>
>> My current application is in performance dip, Can any shed some light on
>> cursor sharing? Is this really improves performance?
>>
>> Thanks & Regards
>>
>> Arshad Mahammad
>>
>>
>>
>>
>>
>>
>> "Shellman, David"
>> <dave.shell...@ty
>> COELECTRONICS.COM To
>> > [email protected]
>> Sent by: "Action cc
>> Request System
>> discussion list Subject
>> (ARSList)" Re: test mail
>> <arsl...@arslist.
>> ORG>
>>
>>
>> 3 December 2010
>> 10:58 AM EST
>>
>>
>> Please respond to
>> [email protected]
>> RG
>>
>>
>>
>>
>>
>>
>> The email was successful. You testing anything else like a response from
>> me?
>>
>> Dave
>>
>> -----Original Message-----
>> From: Action Request System discussion list(ARSList)
>> [mailto:[email protected]] On Behalf Of Arshad M
>> Sent: Friday, December 03, 2010 10:47 AM
>> To: [email protected]
>> Subject: test mail
>>
>> Hello All,
>>
>> This is a test mail.
>>
>>
>> Thanks & Regards
>>
>> Arshad Mahammad
>>
>>
>>
>> This email originates from Steria*. It, and any attachments, may contain
>> confidential information and may be subject to copyright or other
>> intellectual property rights. It is only for the use of the addressee(s).
>> You may not copy, forward, disclose, save or otherwise use it in any way
>> if
>> you are not the addressee(s) or responsible for delivery.
>> If you receive this email by mistake, please advise the sender and cancel
>> it immediately.
>> Steria may monitor the content of emails within its network to ensure
>> compliance with its policies and procedures.
>> Any email is susceptible to alteration and its integrity cannot be
>> assured.
>> Steria shall not be liable if the message is altered, modified, falsified,
>> or edited.
>> _____________________________________________________
>> * Steria Limited, number 4077975;
>> Steria Recruitment Limited, number 1437998.
>> Registered in England and Wales; registered office Three Cherry Trees
>> Lane,
>> Hemel Hempstead, Hertfordshire HP2 7AH
>>
>>
>> _______________________________________________________________________________
>>
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
>>
>> _______________________________________________________________________________
>>
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
>>
>>
>> This email originates from Steria*. It, and any attachments, may contain
>> confidential information and may be subject to copyright or other
>> intellectual property rights. It is only for the use of the addressee(s).
>> You may not copy, forward, disclose, save or otherwise use it in any way if
>> you are not the addressee(s) or responsible for delivery.
>> If you receive this email by mistake, please advise the sender and cancel
>> it immediately.
>> Steria may monitor the content of emails within its network to ensure
>> compliance with its policies and procedures.
>> Any email is susceptible to alteration and its integrity cannot be
>> assured. Steria shall not be liable if the message is altered, modified,
>> falsified, or edited.
>> _____________________________________________________
>> * Steria Limited, number 4077975;
>> Steria Recruitment Limited, number 1437998.
>> Registered in England and Wales; registered office Three Cherry Trees
>> Lane, Hemel Hempstead, Hertfordshire HP2 7AH
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
>
> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
