Re: SQL*Net connecting time

> 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.