My Oracle Support Banner

Multiple Database Processes Spawned for Long Running Report When using Oracle REST Data Services (ORDS) / Weblogic (Doc ID 2004539.1)

Last updated on JULY 29, 2019

Applies to:

Oracle REST Data Services - Version 2.0 and later
Oracle WebLogic Server - Version 10.3.4.0.1 and later
Oracle HTTP Server - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

Several reports are running in acceptable times on the database (they have been optimised) as monitored through AWR reports and through SQLPLUS from the Weblogic but there is a significant delay in the data being displayed in the Apex application in the browser.

In monitoring the SQL sessions generated on the database by an APEX session, it has been observed that:


Other Information

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 Option 1: Turn OFF Idempotent in the Web Server Plug-in Configuration
 
   Option 2: Modify the Failover Timeout (WLIOTimeoutSecs) in the Web Server Plug-in Configuration
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.