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] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
