Hi,
Just on the off chance anyone recognises the symptoms (yeah I know long shot but you never know ;-) ) ...
I have several
java processes running against a clustered Oracle database, the SQL is in some cases trivial. On certain days I get problems where it appears all the SQL takes ages to run >50s for normally sub second queries and it looks like the different SQL acting on different tables returns at the same instance even though executed at different start times but within a small window. The DBA believes the SQL in question is executing incredibly fast but stuck waiting for a commit(s) from the network, the connection is auto commit. The database is showing no signs of strain (very under worked), the network guy says the network is under light load (we're watching network traffic for issues) and the infrastructure bod says disk latency is low. The driver I am using is the one via OCI client ie not the thin driver. Some days we get only get small acceptable problems when the database has its backup task executing, other days melt down.
Any thoughts, wild guesses ...
Chris
"Eagles may soar but weasels don't get sucked into jet engines" SCJP 1.6, SCWCD 1.4, SCJD 1.5,SCBCD 5