*
The moose likes JDBC and the fly likes JDBC Clustered Oracle Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Clustered Oracle Problem" Watch "JDBC Clustered Oracle Problem" New topic
Author

JDBC Clustered Oracle Problem

Chris Hurst
Ranch Hand

Joined: Oct 26, 2003
Posts: 412
    
    2

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
Chris Hurst
Ranch Hand

Joined: Oct 26, 2003
Posts: 412
    
    2

Since no one commented ;-) I'll post the solution in case anyone else finds the same problem. The issue was the redo logs that are written to on a commit were set to switch way too frequently. So although the database, app and network all reported extremely fast performance everything was blocked on these logs.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Clustered Oracle Problem
 
Similar Threads
problem with thindrivr when connecting to RAC
best programming practises of JDBC
Performance - XA Vs Non XA
JDBC driver
XSU