You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@activemq.apache.org by "Hans Huber (JIRA)" <ji...@apache.org> on 2006/05/29 11:11:51 UTC

[jira] Created: (AMQ-728) Active MQ is creating great number of Oracle processes

Active MQ is creating great number of Oracle processes
------------------------------------------------------

         Key: AMQ-728
         URL: https://issues.apache.org/activemq/browse/AMQ-728
     Project: ActiveMQ
        Type: Bug

  Components: Message Store  
    Versions: 3.2.1    
 Environment: Sun Solaris 8, Oracle 9i2, Java 1.4.2_08
    Reporter: Hans Huber
 Attachments: OracleAfter.png, OracleBefore.png

We migrated from derby to Oracle as message persistence layer. We discoverd now, that ActiveMQ is creating a lot of Oracle resource intensive processes. Please see attached diagrams:

OracleBefore.png = Orace processes with derby as persistence layer
OraceAfter.png = Oracle processes with Oracele as persistence layer

Any help is much appreciated. If you need any additional information, pls don't hesitate to contact me

Best regards, Hans Huber

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   https://issues.apache.org/activemq/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Commented: (AMQ-728) Active MQ is creating great number of Oracle processes

Posted by "Hiram Chirino (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/activemq/browse/AMQ-728?page=comments#action_36300 ] 

Hiram Chirino commented on AMQ-728:
-----------------------------------

Hans,

Could you try setting up activemq to use the c3p0 http://sourceforge.net/projects/c3p0 datasource instead of the commons datasource?
We have had reports that it works much better.  Could you confirm?



> Active MQ is creating great number of Oracle processes
> ------------------------------------------------------
>
>          Key: AMQ-728
>          URL: https://issues.apache.org/activemq/browse/AMQ-728
>      Project: ActiveMQ
>         Type: Bug

>   Components: Message Store
>     Versions: 3.2.1
>  Environment: Sun Solaris 8, Oracle 9i2, Java 1.4.2_08
>     Reporter: Hans Huber
>  Attachments: OracleAfter.png, OracleBefore.png
>
>
> We migrated from derby to Oracle as message persistence layer. We discoverd now, that ActiveMQ is creating a lot of Oracle resource intensive processes. Please see attached diagrams:
> OracleBefore.png = Orace processes with derby as persistence layer
> OraceAfter.png = Oracle processes with Oracele as persistence layer
> Any help is much appreciated. If you need any additional information, pls don't hesitate to contact me
> Best regards, Hans Huber

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   https://issues.apache.org/activemq/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Resolved: (AMQ-728) Active MQ is creating great number of Oracle processes

Posted by "james strachan (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/activemq/browse/AMQ-728?page=all ]

james strachan resolved AMQ-728.
--------------------------------

    Fix Version/s: 4.2.0
       Resolution: Fixed

I think this is now resolved - if it isn't please let us know and we can reopen

> Active MQ is creating great number of Oracle processes
> ------------------------------------------------------
>
>                 Key: AMQ-728
>                 URL: https://issues.apache.org/activemq/browse/AMQ-728
>             Project: ActiveMQ
>          Issue Type: Bug
>          Components: Message Store
>    Affects Versions: 3.2.1
>         Environment: Sun Solaris 8, Oracle 9i2, Java 1.4.2_08
>            Reporter: Hans Huber
>             Fix For: 4.2.0
>
>         Attachments: OracleAfter.png, OracleBefore.png
>
>
> We migrated from derby to Oracle as message persistence layer. We discoverd now, that ActiveMQ is creating a lot of Oracle resource intensive processes. Please see attached diagrams:
> OracleBefore.png = Orace processes with derby as persistence layer
> OraceAfter.png = Oracle processes with Oracele as persistence layer
> Any help is much appreciated. If you need any additional information, pls don't hesitate to contact me
> Best regards, Hans Huber

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/activemq/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (AMQ-728) Active MQ is creating great number of Oracle processes

Posted by "Hans Huber (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/activemq/browse/AMQ-728?page=comments#action_36468 ] 

Hans Huber commented on AMQ-728:
--------------------------------

Hi Hiram

Thanks four your help. We will test this in a test environment. I will keep you updated.

regards, Hans

> Active MQ is creating great number of Oracle processes
> ------------------------------------------------------
>
>          Key: AMQ-728
>          URL: https://issues.apache.org/activemq/browse/AMQ-728
>      Project: ActiveMQ
>         Type: Bug

>   Components: Message Store
>     Versions: 3.2.1
>  Environment: Sun Solaris 8, Oracle 9i2, Java 1.4.2_08
>     Reporter: Hans Huber
>  Attachments: OracleAfter.png, OracleBefore.png
>
>
> We migrated from derby to Oracle as message persistence layer. We discoverd now, that ActiveMQ is creating a lot of Oracle resource intensive processes. Please see attached diagrams:
> OracleBefore.png = Orace processes with derby as persistence layer
> OraceAfter.png = Oracle processes with Oracele as persistence layer
> Any help is much appreciated. If you need any additional information, pls don't hesitate to contact me
> Best regards, Hans Huber

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   https://issues.apache.org/activemq/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira