This is unlikely we are not doing anything fancy here. if that was the case we should hit similar problems with MSSQL and MySQL as well.
On Sun, Mar 8, 2015 at 7:25 PM, Isuruwan Herath <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> 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 >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Ramith Jayasinghe >> Technical Lead >> WSO2 Inc., http://wso2.com >> lean.enterprise.middleware >> >> E: [email protected] >> P: +94 777542851 >> >> > > > -- > Isuruwan Herath > Technical Lead > > Contact: +94 776 273 296 > -- Ramith Jayasinghe Technical Lead WSO2 Inc., http://wso2.com lean.enterprise.middleware E: [email protected] P: +94 777542851
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
