Apex Performance Degraded While Using Interactive Reports

(Doc ID 836146.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version to 3.2.0
Information in this document applies to any platform.
***Checked for relevance on 20-Jul-2012***


1. The table WWV_FLOW_WORKSHEET_CONDITIONS contains a lot of rows (e.g. 407,633).

2. A query like the following is found to consume significant database time:


3. Multiple ORA-04030 errors are found in the DB alert.log:

ORA-04030: out of process memory when trying to allocate xxxxx bytes

4. Performance of Interactive Reports may have degraded over time.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms