Re: SQL*Net connecting time

In article <2eigo2$f17_at_bsdns.brooks.af.mil>, eckhardg_at_radon.brooks.af.mil (Gary Eckhardt, Bldg 613, Rm Dev, X2826) 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:
|>
|> If you're connecting to a server via SQL*Net, you might want to check and see
|> exactly what's being run based on your instance. I know that in VMS, you can
|> specify a startup file that the process runs when it does it's physical
|> login to the system. Trimming this file down to just the bare minimum
|> (SQL*Plus logicals, etc) can greatly improve your connect time.
|>
|> ---
|>
|> --------------------------------+------------------------+--------------------
|> Gary B. Eckhardt | Software Development | This space for
|> Computer Sciences Corporation | MISTS HSC Support | rent or lease.
|> eckhardg_at_radon.brooks.af.mil | (210) 536-2826 | (Cheap!)
|>
|> It's called "GOLF" because all the other four-letter words were taken.
|>

Same here... we added a check for network login to eliminate all the unnecessary stuff from the login.com, it greatly improved startup time.

-Joel

-- 
Joel Fedorko                                Remember Bit Hopper, 
Sr. Consultant                      You must become one with the machine.
Day Data                         It's not the easy way, it's the cowboy way. 
jfedorko_at_ncsa.uiuc.edu             Any opinions I express will be ignored.