Re: LOOOONG delay for connect

In addition to setting the environmental variable EPC_DISABLED=TRUE, you can run $ORACLE_HOME/bin/otrccref even while the database is up in order to shrink back the sizes of the files. This will get you an immediate improvement in connection time. Then, when the database is down, remove all the *.dat files in otrace/admin if you don't want trace on at all.

Kevin Loney wrote:
>
> Check to see if your database has Oracle Trace enabled - this is a known
> cause of slow login times. Look in the otrace/admin directory. If there
> are large (>5 MB) .dat files there, then trace is enabled and is slowing you
> down (it's enabled by default on many Unix systems). To disable it for
> SQL*Net connections, you need to add an environment variable to your
> listener.ora files.
>
> >
> >When I try to connect to the server, whether from SQL+ or VB, it takes
 almost
> >2 minutes to get connected. After that, everything seems to work at normal
> >speed. Also, if I reconnect repeated over the course of the day, the delay
> >seems to gradually get much smaller.
> >
Received on Fri Jun 05 1998 - 00:00:00 CDT