Re: Hints on optimizing Oracle!

From: Murali Kazhipurath <murali_at_jps.net>
Date: Sun, 1 Nov 1998 04:35:04 -0800
Message-ID: <363c570a.0@blushng.jps.net>

Your connection time seems to be high. What is your hardware configuration? Do you have a lot of programs/services running on your machine? What protocol are you using? Could you publish your SQL*Net configuration information?

---

Murali Kazhipurath                                          E-Mail:

murali_at_jps.net
President and Lead Technical Consultant Phone: (916) 773 1918

Kaustubam Systems, Inc.                              Fax:    (916) 773 8147
5098 Foothills Blvd., Ste 3-377                    Mobile:(916) 508 8147
Roseville, CA 95747                                      Pager :(530) 883

2300 or

www.smartpage.net/murali/

---

Adrian Harrison wrote in message
<363d4dce.5572833_at_read.news.globalnet.co.uk>...
>Using Oracle 7.3 NT, VB 6 enterprise on same NT 4 server PC!
>
>I'm a VB/C++ programmer developing VB front end/ Oracle backend
applications
>
>My main concern is the length of time it takes to connect to Oracle -
especially the first time in
>the morning - it may take on average 8-10 sec's - I know this doesn't sound
alot but when your
>constantly connnecting/disconnecting maybe 50 ot more times a day it
becomes a real pain!
>
>Is there any setting in Oracle that can reduce this connection time?
>
>Any good Oracle web sites that might offer optimization advice?
>
>Thanks in advance
>
>Adrian Harrison
>
Received on Sun Nov 01 1998 - 06:35:04 CST