Thanks, I'll give that a try
CliffA
__20060125_______________________This posting was submitted with HTML in it___-----Original Message-----**
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Thad Esser
Sent: 26 July 2006 18:45
To: arslist@ARSLIST.ORG
Subject: Re: ARS slow to start
SQL logging will be your definitive source. We had an issue with long startup times that the SQL logs revealed was caused by one of our view forms. This view form pointed to a table on another database that had "suddenly" been decommissioned. It didn't affect anything once ARS was up, but when starting, it was trying to access that external table and wouldn't move on until it received the timeout.
Thad
"Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away." - Antoine de Saint-Exupéry
"Jarl Grøneng" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG>07/26/2006 10:34 AM
arslist@ARSLIST.ORG
arslist@ARSLIST.ORG Re: ARS slow to start
Turn on sql logging and examine which sql statement that takes long time.
We had similar issue, and it was because Oracle wold not use index on
the arreferenece table. As soon as that was fixed the problem was
fixed.
--
Jarl
On 7/26/06, Cliff A <[EMAIL PROTECTED]> wrote:
> Hi
>
> We have just upgraded our development server to oracle9i. I noticed after
> this that remedy was taking 3 times as long to start but put it down to the
> fact that we had v5.1.2. However, I have just installed arsv6.3 patch17
> and there is still an very long delay in the remedy startup. I have added
> ulimit -n 8192 to the strat up script but to no discernible improvement -
> it still takes 26 minutes to come up. Has anyone else had similar
> problems?
>
> NB O/S is solaris 9.
> top command shows this...
> Memory: 1.2G real, 556M free, 509M swap in use, 1.4G swap free
>
> Many thanks for any help.
> Cliff
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
==============================================================================
__20060125_______________________This posting was submitted with HTML in it___
IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.
==============================================================================
