That seems consistent with the performance tradeoffs that are endemic to DB settings. Either searches are slow but submits/modifies are fast, or the other way around.
Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rocky Rockwell Sent: Tuesday, June 19, 2007 1:54 PM To: [email protected] Subject: Re: Slow Performance when migrated from 9i to 10 G I would like to ask a question. The slow performance seen was for doing a search or submit/modify of tickets? We are seeing slow performance on submit and modify but our searches are pretty fast. *Rocky* Rocky Rockwell eMA Team - Remedy Developer [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Ph#1: 214-567-8874 Ph#2: 325-884-1263 Grooms, Frederick W wrote: > 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" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
