Apex Performance Degraded While Using Interactive Reports
Last updated on OCTOBER 27, 2016
Applies to:Oracle Application Express (formerly HTML DB) - Version 3.1.0.00.32 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:
SELECT * FROM WWV_FLOW_WORKSHEET_CONDITIONS ...
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
Million Knowledge Articles and hundreds of Community platforms