1. Designing Pixel-Perfect Reports in Oracle Transactional Business Intelligence
  2. Model Data for Pixel-Perfect Reports
  3. Performance Best Practices
  4. Know Oracle WebLogic Server Default Time Out Setting

Know Oracle WebLogic Server Default Time Out Setting

WebLogic Server has a default time out of 600 seconds for each request thread.

When the time exceeds 600 seconds, Oracle WebLogic Server marks the thread as Stuck. When the number of Stuck threads reaches 25, the server shuts down.

To avoid this problem, verify that your SQL execution time doesn't exceed the WebLogic Server setting.