Win a copy of The Journey To Enterprise Agility this week in the Agile and Other Processes forum! And see the welcome thread for 20% off.
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
Bartenders:
  • Carey Brown
  • Tim Holloway
  • Joe Ess

JDBC Clustered Oracle Problem  RSS feed

 
Ranch Hand
Posts: 443
3
C++ Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • 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
C++ Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • 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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!