OBIEE can suffer Stuck threads, which is often hard to get to the bottom of the route cause. In searching for helpful documents some reference materials below.
Oracle Load Test Tool – could be used for Pre-Production Load testing
- OBIEE: Load Testing OBIEE Using Oracle Load Testing (OLT) 12.x (Doc ID 1611188.1)
Tuning notes
- OBIEE 11g Infrastructure Performance Tuning Guide (Doc ID 1333049.1)
- https://support.oracle.com/epmos/main/downloadattachmentprocessor?parent=DOCUMENT&sourceId=1333049.1&attachid=1333049.1:V420140127&clickstream=yes
Automated checking script
- https://blogs.oracle.com/pa/entry/obiee_tuning_guide_script
- https://blogs.oracle.com/pa/resource/CheckObieeTuningGuidev4_01-2014.zip