Oracle Database Discussions

Hi all,

I have an application that works on connecting and making queries on an oracle DB. Every now and then, for no apparent reason, every query it does becomes extremely slow. I don't know if anyone ever had a similar problem.

To make a few tests I created a simple procedure that connects to the DB and does the same select (select * from dual) in a loop for 100K times. I still get the same problem, most of the queries go instantly, but sometimes, in groups of 3 or more, the queries take up to 10 seconds!! I don't know what to do!

I have Windows server 2003 64bit R2 and Oracle 10.2.0.4.

I have verified that it is not a network problem (I get the issue also locally) or a Windows problem (I have plenty of RAM and free disk space)

Any hints? Let me know if you need more info.

P.s. I can't tell you anything about the application because I don't know how it is written and I am not allowed to know....