It could be the client code not returning the connections back to pool as well. No: of active sessions to the DB could be monitored using any DBA tool (ex: TOAD).
Thanks! Isuruwan On Sun, Mar 8, 2015 at 4:38 PM, Ramith Jayasinghe <ram...@wso2.com> wrote: > Hi, > we need the help of folks who are familiar oracle to get this sorted. > Any thoughts ? > regards > Ramith > > On Fri, Mar 6, 2015 at 8:04 PM, Pumudu Ruhunage <pum...@wso2.com> wrote: > >> Hi All, >> >> I'm facing a oracle database issue when trying to test mb in cluster >> environment with oracle database. >> Following are the steps i followed. >> 1. Start two mb nodes (node A, node B) with clustering enabled. >> 2. Subscribe to node A with queue subscription "MyQueue" with a jms >> client. >> 3. Start publish 2000 messages to node B to "MyQueue" using a jms client. >> 4. Attached error log appears while receiving messages. >> >> As a work around i changed number of processes to 2000 with this alter >> statement[1]. Then it worked for 100,000 messages without throwing >> exceptions but it took around 5 minutes to finished receiving messages >> (There's a big performance drop when increase number of processes). >> >> Therefore, changing number of processes doesn't solve this issue. Is >> there a proper fix for this issue ? >> >> I found a jira [2] related to api manager with the same issue. But it >> didn't explain what's the exact fix(database configurations) for this issue. >> >> >> [1] - alter system set processes=2000 scope=spfile; >> [2] - https://wso2.org/jira/browse/APIMANAGER-2304 >> >> -- >> Pumudu Ruhunage >> Associate Software Engineer | WSO2 Inc >> M: +94 779 664493 | http://wso2.com >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Ramith Jayasinghe > Technical Lead > WSO2 Inc., http://wso2.com > lean.enterprise.middleware > > E: ram...@wso2.com > P: +94 777542851 > > -- Isuruwan Herath Technical Lead Contact: +94 776 273 296
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev