Re: Connecting to database takes 5 seconds

From: Wolfram Roesler <wr_at_grp.de>
Date: Fri, 26 Jul 2002 17:36:42 +0200
Message-ID: <Xns9257B3B179E6wrgrpde@62.153.159.134>

Hi,

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in news:v8c09.673301$cQ3.104652_at_sccrnsc01:

> If you do a sqlPlus (command line ) from the server how fast to do
> sqlplus username/password_at_mydb
> vs
> sqlplus username/password

About two seconds each, no difference.

> If there is not a real difference then it is NOT the network or the
> NIC it is the thread spawning. (Just trying to eliminate things).

This seems to be the case here.

> It isn't swapping when it tries to make the connection is it? In task
> manager how much memory is available when Oracle is running?

About 50 MB, going down to 45 after running sqlplus as described above.

Thanks for your help
W. Roesler Received on Fri Jul 26 2002 - 10:36:42 CDT