Response and performance issue

Hi all,

I have a problem with a 8.1.6.2.0 database. When I run a query, the responce is about 25s. But when I run the same query in an other window while the first query is executing, I get an immediate (1-2s) response, even before the first query is finished. I can easily reproduce these results. It does not matter if I run the query from sqlplus or from the VB-client. There is no or litle CPU and disk activity. Load is about 0.3. After the first query finishes the performace dies again, so this should not be a caching issue. I have to start another 'slow' query before I will get fast responses again.

The network-man checked the connection with ping and traceroute, but could't find something suspicious. There are no collisions or other errors on the network, and the overall network performance is quite acceptable.

Box parameters are as follows:
HP 9000/889 / HPUX 11.0 / 1 GB RAM, internal disks

Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option
JServer Release 8.1.6.2.0 - Production

thanks for your advice!

Peter Balon Received on Mon Feb 19 2001 - 13:40:14 CST