Look into the Oracle's Cursor Sharing for BMC(r) Remedy(r) Products white paper on setting your cursor sharing to similar or force. Ask your DBA if cursor_sharing is set in the init.ora. If it is not then it defaults to "cursor_sharing = EXACT". Setting it to similiar or force will help eliminate this issue. Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, June 19, 2007 9:04 AM To: [email protected] Subject: Re: CMDB Performance Issue - Heads Up out there ** Our Oracle DBA noted what he thought was a design flaw yesterday - on retrievals, the SQL isn't binding any of the variables (like form ID), so it's having to re-fetch each of those each time, instead of having it locally cached like a server variable. That causes the searches to take FAR longer than they otherwise would. Rick ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Terry Bootsma Sent: Tuesday, June 19, 2007 5:35 AM To: [email protected] Subject: Re: CMDB Performance Issue - Heads Up out there ** Roger.... interesting.... how many rows are in your BMC:CORE:BMC:BaseElement and BMC:CORE:BMC_BaseRelationship table? Are you on Oracle or SQLServer? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Roger Justice Sent: Monday, June 18, 2007 4:49 PM To: [email protected] Subject: Re: CMDB Performance Issue - Heads Up out there ** ITSM 7 CMDB 2.X each computer had 100-200 software items related and the loading of the individual computer and the selection of the related items tab was 1-3 seconds. Maybe it was improved. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
