Our db server (shared by multiple databases) was having some performance problems. Remedy was not the actual culprit but management felt that it was a good time to check the settings of all databases on it. The advisor pointed out latch contention because of not sharing cursors. At the same time the DBA turned on the ASMM - Automatic Shared Memory Management feature (and the sga_max_size and SGA_TARGET parameters). <Knocking on Wood>Since adding the cursor_sharing the system has been stable</Knocking on Wood> Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Tuesday, June 19, 2007 9:45 AM To: [email protected] Subject: Re: Slow Performance when migrated from 9i to 10 G ** 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: _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
