Re: Connecting to database takes 5 seconds

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 25 Jul 2002 00:06:55 +1000
Message-ID: <Uoy%8.43154$Hj3.130166@newsfeeds.bigpond.com>

Hi Wolfram,

It's hard to say but is the listener you're connecting to having to deal with many other connections (how busy is this mamma ?).

Are you using dedicated or shared servers ? If shared, are dispatchers coping ?

If dedicated, have you tried to get the listener to pre-spawn a few dedicated servers (prespawn_max in listener.ora) ?

Are you sure you're not downloading David Bowie's latest album why you're trying to connect ?

Regards

Richard
"Wolfram Roesler" <wr_at_grp.de> wrote in message news:Xns92559D7FA2564wrgrpde_at_62.153.159.134...
> Hello,
>
> we have:
>
> * an Oracle 8i server: 900 MHz, 256 MB RAM, Windows 2000
> * a workstation: 1600 MHz, 640 MB RAM, Windows XP, Oracle 9i client
> software
>
> It takes five to eight seconds to connect to the database from the
> workstation! All init.ora parameters are set to LARGE or larger,
> the server still has some 30 MB RAM free, and there's plenty of LAN
> bandwidth left. Does anybody know how the DB connection can be speeded
> up?
>
> The delay takes places both when starting sqplus (via Start -> Execute)
> and when connecting to the database via ODBC. We are using the 9.0.1.4
> version of the 9i ODBC driver.
>
> Thanks for any help
> W. Roesler
Received on Wed Jul 24 2002 - 09:06:55 CDT