Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LOOOONG delay for connect
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 Tue Jun 02 1998 - 00:00:00 CDT