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"
