This is a known issue with a remote Oracle database. Search the archives and you will find quite a few messages about it. BMC has responded that it is as designed and there is nothing you can do to increase the performance.
The large tables that are fetched are field_dispprop, field, etc. Search the KB on the article about startup logging - you can see the server fetching the rows from the DB and then will understand why it takes so long. :-) Axton had a good post on it dated 9 Jul 2007. hth, tony Tony Worthington Sr. Technical Analyst Kohl's Department Stores N56 W17000 Ridgewood Drive Menomonee Falls, WI 53051 262.703.5911 (phone) [EMAIL PROTECTED] www.Kohls.com Frex Popo <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 11/13/2008 01:30 PM Please respond to [email protected] To [email protected] cc Subject ARS with news Change Management install refusing to start. ** Hello again, ARS 7.1 AM/IM 7.0.3 OS: MS 2003 Enterprise DB: Oracle 10 At short notice I have been asked to help some fellow worker having problems with Change Management 7.0.3. The truth is, I have not worked with previous versions let alone 7.0 but this may not have anything to do with ITSM anyway. I am told they have recently installed CM on top of a working ITSM7.0.3 with IM and AM . The problem they are having at the moment is starting up the server. It takes, I am told, some 30 minutes to get the system up and running. I need to prepeare myself as I have very little time and need to know where to look. Have you had the same problem in the past? Have you had a problem not too disimilar to this one and how did you go about resolving it? I am thinking the first step to take is to enable the server logs API/SQL and scan them for any dogy queries and check the ar.cfg file for anything that could be slowing the server at start up. There must surely be other things to check not only at the sever level but the databse as well!!! Your help is very much appreciated. Regards frex __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ********************************************************************** CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent.
<<image/jpeg>>
