• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC Clustered Oracle Problem

 
Ranch Hand
Posts: 443
3
Eclipse IDE C++ Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Chris Hurst
Ranch Hand
Posts: 443
3
Eclipse IDE C++ Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
reply
    Bookmark Topic Watch Topic
  • New Topic