[sknmail@rediffmail.com]

Hi Everybody,

Well on our test environment, using integration simulation using JMeter tool, we were pumping in transorder xmls.. well for after about 30 mins of succesful upload of transorders.. glog.exception.log display error "DEDICATED SECURITY CONNECTION POOL EXHAUSTED" and further the process continued.

Actually we are doing some volume testing on one of the instance (migrated to 5.5 CU3 + RU#2 from 5.0).

The test acutally releases the order and automation tool actually select the preidentified patterns of orders from each page one after the other and does the bulk plan.. so finally when the test was over we could find that in couple of bulkplans the no. of order selected were less from than expected.. so I guess because of the above error the upload was not done successfully. Now I guess since connection itself was lost.. so I don't think this would be present in the transmission.

Did anybody encounter the same issue anytime on their setup.. what could be possible cause of this issue.. do you database's max shared connection was finished..

Please let me know if found a solution for this...

Thanks and Regards,
Suresh

[nick.polites]

Suresh,

I have seen this on a few client instances. Oracle development is unable to determine what causes this issue. The only resolution is to increase the connection pool. The database table which has this value is called Connection_Pool. After you update the MAX_CAPACITY you will need to restart the application. I would suggest you increase it to 30 for now and if you need to increase it further do it at increments of 10.


Nick

[sknmail@rediffmail.com]

Dear Nick,

Thanks very much for that information. In our case it was set to 10, so probably during the test this limit was crossed.

Thanks and Regards,
Suresh

[chrisplough]

Suresh,

I agree with Nick, especially with the tons of OTM sysadmin and performance tuning experience he has.

In my own experience, I've had to set this as high as 30, under very high performance testing scenarios. In the real world, I've rarely seen this higher than 10.

--Chris