Oracle 7.3.4 performance: First Query takes enormous amount of time

From: <narayana_ck_at_my-deja.com>
Date: Tue, 08 Jun 1999 17:57:45 GMT
Message-ID: <7jjlih$rpf$1@nnrp1.deja.com>

Hi There,
This is a very strange and unique problem i have been facing on Oracle 7.3.4 running on NT4.0 with SP4.

The first time Oracle instance is up and running, any query(virtually any simple query) i try executing, takes an enormous amount of time(runs into minutes)...After that, things begin to improve and the system starts responding well for other and more complex queries as well.

I usually tend to use the default Oracle configuration parameters. Machine Details: Pentium II 450Mhz with 128MB RAM and 256MB virtual memory(swap space) and database size of 100 MB.

Any clues???

thanks
ck

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 12:57:45 CDT