Re: Oracle 7.3.2.2 - Login taking forever

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 14 Jul 1999 23:29:57 -0400
Message-ID: <378D55B4.82424222@bigfoot.com>

This sounds like a great success story but help me out here..what are those files?

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_at_unisys.com>,
> Susan Halligan <susan.halligan_at_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_at_vitalsol.com
> http://vitalsol.com/
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Jul 14 1999 - 22:29:57 CDT