What should be the recommended JDBC Maximum capacity for EPMSystemRegistry in weblogic
We are using Hyperion 11.1.2.3.501 version. Last week our Hyperion application went down without any reason and back online post service restart. As part of RCA we have identified that the JDBC connection pool size for EPMSystemRegistry in weblogic seems to be set low i.e. 30. As per Oracle best practice guide, it is recommended to keep at least max capacity as 150 for EPMSystemRegistry. Can some once suggest on this please? System hardware specifications are listed below
Datasource | Initial Capacity | Maximum Capacity | Minimum Capacity |
EPMSystemRegistry | 1 | 30 | 1 |
aif_datasource | 1 | 1500 | 1 |
calc_datasource | 1 | 15 | 1 |
eas_datasource | 1 | 15 | 1 |
financialclose_datasource | 1 | 150 | 1 |
mds-owsm | 0 | 150 | 0 |
mds-soa | 0 | 150 | 0 |
odiMasterRepository | 1 | 120 | 1 |
odiWorkRepository | 1 | 15 | 1 |
OraSDPMDataSource | 0 | 200 | 0 |
planning_datasource | 1 | 15 | 1 |
raframework_datasource |