Re: Oracle 7.3.2.2 - Login taking forever

From: Susan Halligan <susan.halligan_at_unisys.com>
Date: Tue, 13 Jul 1999 17:17:06 -0400
Message-ID: <378BACD2.5486820B@unisys.com>

Many Thanks!!!!!!
That was it! Login back down to 1 second!!!

THANKS!!

Denny Koovakattu wrote:

Hi,
This could be due to Oracle writing to the trace files process.dat and
regid.dat . Go to $ORACLE_HOME/otrace/admin directory and check for the
size of these files. Run otrccref to reset these file to the default
size. Also set the environment variable EPC_DISABLED to TRUE and/or add
the following entry in the $TNS_ADMIN/listener.ora.
SID_LIST_TEST =
   (SID_LIST =
      (SID_DESC =
         (ORACLE_HOME = /u01/app/oracle/product/734)
         (SID_NAME = TEST)
         (ENVS='EPC_DISABLED=TRUE')         <------- Add this line
      )
   )
Regards,
Denny
In article <378A5E64.E340BAF5@unisys.com>,
Susan Halligan <susan.halligan@unisys.com> wrote:
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> We are running an Oracle 7.3.2.2 on Solaris 2.6   It has
been
> up and running for almost a year with no problems.  We have
noticed
> in the past month or so that when we login using SQL*Plus 2.3.2.2.0
that
> it is taking up to 90 seconds to get to the SQL prompt.  Any
ideas? 
> We are not running auditing, redo logs are ok, temp TS is ok. 
Once
> logged in performance is fine.
> <p>Thanks,
> <br>Susan</html>
--
Denny Koovakattu
denny@vitalsol.com
http://vitalsol.com/
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

Received on Tue Jul 13 1999 - 16:17:06 CDT