Oracle Database Discussions

Hi,

I am having a problem in a number of databases and I can't track it down.

The problem presents itself in the front end to the user as the software hanging every now and again when performing any database querry.

I have reproduced the problem (which seems to be system wide) in TOAD by running a simple query: 'select * from com_ref_box;'. The table is small (388 rows) but this problem presents itself on all queries that I run.

Basically, about 80% of the time when I run it, it will return the result set in 15 to 30 msec, but the rest of the time, it can take anything from 3 to 9 seconds.

This is without any other users on the database.

I have tried everything that I can think of to track this down but I am lost now!

It isn't a network issue because I have run the query on the server.
It doesn't seem to be a problem with conflicting processes on the server because I compared it to another machine that was running fine.
the database seems to be generating the same plan each time.


If anyone can offer any advice it would be greatly appreciated!

Thanks

Phil