My Oracle Support Banner

The Database 11.2.x APEX Session Ignores Created SQL Baseline which Affects Performance (Doc ID 1684250.1)

Last updated on SEPTEMBER 21, 2019

Applies to:

Oracle Application Express (APEX) - Version 3.2.1 and later
Information in this document applies to any platform.

Symptoms

Running SQL statements from APEX applications are slow, even though an SQL Baseline was created to speed them up. Tracing the APEX session showed that the database session which was opened by APEX was not taking into account the created SQL Baseline and the optimizer chose another (less effective) execution plan.

Changes

 Upgraded database from 11.1.0.7 to 11.2.0.3. It worked fine in 11.1.0.7

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
Changes
Cause
Solution
References


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