• 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 ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

need insight: tomcat to oracle db

Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I am running tomcat 5.5 to Oracle 10G.

We just experienced db crash & loss of data, etc...

Our problem is that once our dba got the system back up,
everything is slow & he is blaming it on tomcat & java db pooling.

what we are seeing in oracle is that tomcat has about
~200-300 sleeping processes in oracle & ~50-100 active ones.

This is taxing our system as cpu is 90+ & load is 100+,
of course tomcat isn't the only thing hitting the db ...

my question is that given our large client base this does not seem
unusual. what do 'sleeping' processes (these are tomcat processes)
in oracle mean? is it oracle's way of caching requests ...

we use db pooling:
with max 60 connections & this is never exceeded & has worked in the past.
all of our conn are closed properly, code is cleaned, etc ...

but our dba is blaming the dev team saying its tomcat/java where as i
see it as our hardware just sucks plus we had 3 db servers now we are
down to 2.

anyways is this unusually large amount of 'sleeping' processes within
oracle ? should we use a better pooling mechanism.

any thoughts much appreciated

thomas Fuchs
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

figured it out;

tomcat connects to oracle in dedicated mode.
with connection pooling implemented in tomcat and with ~5 front end servers we get about 5*100 = 500
dedicated processes in oracle specifically for tomcat.

majority are sleeping since the 'connection' remains open until tomcat is shut down.
apparently sleeping processes consume a minimal amount of resources and add to the overall db server load ...

and our hardware just sucks. Anyways this might be useful for someone else down the line ...
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic