Re: Connecting to database takes 5 seconds

If you do a sqlPlus (command line ) from the server how fast to do sqlplus username/password_at_mydb
vs
sqlplus username/password

Why?
I think the first one goes throught the NIC and the second will go throught the bequeath adapter. Nice to know if there is a difference. If there is not a real difference then it is NOT the network or the NIC it is the thread spawning. (Just trying to eliminate things).

I have 8.1.7 on a laptop and it doesn't take anywhere near 7 seconds, but I am connecting locally for my work.

It isn't swapping when it tries to make the connection is it? In task manager how much memory is available when Oracle is running?

Jim
"Wolfram Roesler" <wr_at_grp.de> wrote in message news:Xns92575EE674FB9wrgrpde_at_62.153.159.134...
> Hi,
>
> nsouto_at_optushome.com.au (Nuno Souto) wrote in
> news:dd5cc559.0207251739.31bc4e32_at_posting.google.com:
>
> >FWIW, 99% of problems with slow connections in NT are related to
> >IP address resolution and handling . I've got a similar config to yours
> >and get connections in half a second or less. Same size lan.
>
> This gives me some hope still, although I'm beginning to believe
> that I'm in that remaining one percent.
>
> > Can you post your sqlnet.ora file, client and server?
>
> Yes, of course. Here the client's sqlnet.ora (minus comments):
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> And here's the server's, identical to the client's:
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> Don't know what the NTS is used for.
>
> tnsping'ing the server from my workstation finishes successfully in
> 10-30 msec. pinging both IP address and host name display no delay.
>
> > Also, you sure that all your client side exe and dlls coming from
> > local workstation disk? As opposed to a shared folder.
>
> Definitely, since the server is Oracle 8i but the client has
> Windows XP on which the 8i client software won't work, so it's
> using the 9.0.1 client software.
>
> Could it have something to do with client and server using
> different versions of the Oracle software (8.1.6 vs. 9.0.1)?
>
> Thanks for your help
> W. Roesler
Received on Fri Jul 26 2002 - 08:28:59 CDT