Re: Login delay

From: Mani Visweswaran <maniv_at_nycmail.com>
Date: Wed, 17 Jan 2001 08:38:12 -0500
Message-ID: <9446n1$hrc$1@slb1.atl.mindspring.net>

<timf97_at_earthlink.net> wrote in message
news:3a64e6b4.2056507_at_news.earthlink.net...

> I have installed Oracle 8.1.6 Enterprise Server on a laptop with the
> following specs:
> 800 MHz
> Pentium III
> 256M memory
> 20G HD
>
> The probnlem is that logging into the database takes app. 13 sec.
> every time I have to open a new session (SQLPlus, DBA Studio, or
> whatever).
>
> I know that it doesn't sound like much, but I have an application that
> needs to login everytime that it puts out an HTML page, and 13 seconds
> plus the actual DB access does end up being a long time.

I recently upgraded from Oracle 8.0.5 to 8.1.7 on a Pentium III, and the login time went from 3 sec. to just about immediate.

Also, if you're logging in to the database for every HTML page you serve up, you definitely need to rethink your application.

Mani Received on Wed Jan 17 2001 - 07:38:12 CST