Re: Hints on optimizing Oracle!

From: David Sisk <davesisk_at_ipass.net>
Date: Tue, 03 Nov 1998 01:28:03 GMT
Message-ID: <D_s%1.244$Dm.7212251@news.ipass.net>

Yes and yes. Check the web site below for some NT-specific ORACLE info. In the listener.ora file, you can set a PRESPAWN parameter that will pre-create the specified number of user threads. Check the SQL*Net docs......

Regards,

--
David C. Sisk
http://www.ipass.net/~davesisk/ORACLEonNT.htm

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 Mon Nov 02 1998 - 19:28:03 CST