Re: SQL*Net connecting time

In article <2ei637$13l_at_Joanna.Wes.Army.Mil> u4imcehb_at_apollo.wes.army.mil (Ernest Boswell) writes:
>Liang Lin (llin_at_med.umich.edu) wrote:
>: Hi everyone,
 

>: Does it take a minute to connect to Oracle servers thru SQL*Net?
>: I am writing a phone book type application using an Oracle personnel
>: database. The connecting time is too long for such a small application.
 

>: Thanks for any ideas.
>
>
>: Liang Lin
>: Internal Medicine Network Service llin_at_med.umich.edu
>: University of Michigan Medical Center (313) 936-8305
>
>My access time is almost immediate to a UNIX server, via SQL*Net TCP/IP.
>Could be different for another protocol, though (e.g., SNA, Async). I
>have no experience with any other than TCP/IP.
>
>Harry Boswell
>
>Information Technology Laboratory
>U.S. Army Corps of Engineers
>
>"select std_disclaimer from opinions_not_shared_by_employer"

I'm pretty new to the Oracle world, but it seems to me that SQL*Net connect times would be dependent on all sorts of variables such as network traffic, network configuration and hardware configuration as well as network protocol. The variation in (subjective) connect times for some TCP/IP sites which have responded to this thread so far would tend to support this view.

-- 
Peter Sterne, Sr. Software Engineer
Greenwich Associates, Greenwich Connecticut
pete_at_greenwich.com, voice (203)625-5089, fax (203)629-1200