Re: SLOW CONNECT TIME

One thing to check is whether Oracle Trace is turned on. I remember there was an article on this on Metalink. Oracle Trace is turned on by default during installation. I am not positive how to turn it off. They say you need to delete all *.dat files from otrace/admin or use EPC_DISABLED.

Another thing - check whether tracing/loggin is turned on. It is possible, f.e., that you've got a huge listener.log file and it takes time to log the connection attempt there. Try turning everything off first and see if it makes a difference.

Something else to try - if you have a lot of databases handled by the same listener - start it on a different port.

One more thing to try - replace host names by IP addresses. If this speeds the things up, look if you have a problem with DNS.

If you are using Oracle Names, there can be more issues.

Regards
Karen

Marcin Buchwald wrote:

> I've been using oracle server since 7.x
> Every version has the same problem.
> It is connect time. A windows application
> with oo4o and oracle 8i requires 5 seconds
> to connect. The same was with odbc.
>
> This application runs 4 times faster then
> its former incarnation based on sybase.
>
> But sybase connect time was non-noticable.
>
> Every database I know eg. MS, Informix, Sybase
> connets faster then 0.5 sec.
>
> My network is fine, my tnsping is fine
> my database performance is fine,
> but why connect time is so long.
>
> I wonder of some magic instruction
> in sqlnet.ora
>
> SQLNET.CONNECT_TIME = FAST ( :-))))
>
> I just don't believe in the answer:
> Oracle is Oracle and users must wait 5 sec. to connect
Received on Fri Nov 10 2000 - 13:32:10 CST