Fred - did you follow the ADDM (advisor) or did you do this because of another reason?
On 6/19/07, Grooms, Frederick W <[EMAIL PROTECTED]> wrote:
** According to our DBA Oracle 10G does not support the Rule based optimizer that you may have been using inder 9i. Look into the Oracle's Cursor Sharing for BMC(r) Remedy(r) Products white paper on setting your cursor sharing to similar or force After we changed this parameter (In the db and the ar.conf) our speed increased Fred ------------------------------ *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Francois - BTT *Sent:* Tuesday, June 19, 2007 3:42 AM *To:* [email protected] *Subject:* Re: Slow Performance when migrated from 9i to 10 G Hi Shamhoon Did you get any feedback from the list regarding this issue. We experience a similar problem now. Regards Francois *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Jaffaree, Shamhoon *Sent:* 24 April 2007 05:25 PM *To:* [email protected] *Subject:* Slow Performance when migrated from 9i to 10 G Did any one experience performance slowness after migrating to 10G from 9i Oracle? We did an upgrade from 9i to 10G with ARS 7.0 and performance has gone down badly. The DBA is investigating with Oracle did any one of you had the same problem. Any information would be helpful. Thanks *Shamhoon Zenath Jaffaree* *Remedy Application Architect* *Tel. 609-520-5890* [EMAIL PROTECTED] __20060125_______________________This posting was submitted with HTML in it___
-- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
