2 Replies Latest reply on Feb 15, 2002 5:34 AM by Stephen White

    Oracle Sessions / Connection pool growth??

    Stephen White Newbie

      Hi,
      hope this topic finds you all well and happy and full of the joys of enterprise development...
      Well Im currently moving into a testing phase of our ejb app utilizing Oracle and Jboss 2.4.3 and have run into a somewhat huge problem..
      Basically the Connection pool seems to have got tired of just being a pool and seems to have turned into a flood..
      The scenerio :-
      Sun server
      Jboss 2.4.3 Jetty
      Monitoring Oracle sessions on sun server with Toad
      Loading the app with Rational Robot

      The robot contains a script that bombbards our web app with requests and searchs, simulating uses.
      When monitoring the Oracle Sessions in Toad we seem to get a new Session created each time a call to oracle is made ( select insert etc ).
      In Jboss.jcml I have set up the usual oracle datasource properties and made sure the Min (0) and Max (10) sizes are there.
      Because of the min and max sizes set on the datasource on e would imagine only ten Oracel sessions :-
      One Oracel session for one connection in the pool (??)
      But instead we're getting a new session for each DB call. In toad we can see the sessions and even the sql that has been committed, of which we got to about 400 Oracle sessions before the server collapsed under the pool bursting it's banks...
      If any one has any info on setting up and closeing connection pools ( thought it was as simple as :-
      #
      #Wed Aug 15 16:17:29 EDT 2001
      BlockingTimeoutMillis=50000
      IdleTimeoutMinutes=30
      MaxSize=10
      CleanupIntervalMinutes=10
      MinSize=0
      MaxIdleTimeoutPercent=1.0

      ) then plase reply asap..
      Look forward to a reply,
      Stephen.

        • 1. Re: Oracle Sessions / Connection pool growth??
          David Jencks Master

          If you set logging detailed enough you should see a lot of messages like

          handing out object [0/0/10] from pool xxx

          returning object [1/3/99] to pool yyy
          in server.log.

          Can you find them and what do they say?

          Does session == connection?

          XA or local transactions?

          • 2. Re: Oracle Sessions / Connection pool growth??
            Stephen White Newbie

            Hi David,
            many thanks for the swift reply.
            Iv been trying to set logging on the sql and may need some help.
            1. set logging in the mbean descriptor for the datasource :-

            jdbc/Oracle/gaxdev6/br01
            org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
            jdbc:oracle:thin:@gaxdev6:1526:BR01

            ba_adm
            ba_adm
            1.0
            true
            1000
            60000
            60000
            true
            false
            true
            true

            true

            1
            2

            2. have set loggin enabled in the standardjaws.xml file ( however not useing CMP only using BMP so a little confused about this ) : -
            true

            sooo is there some place else I need to set logging??
            Iv brought the documentation ( have actually read it ) and still little confused..
            Help appreciated,
            Stephen.