Last updated on FEBRUARY 14, 2016
Applies to:Oracle Application Express (formerly HTML DB) - Version 3.2.1 and later
Information in this document applies to any platform.
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.
Upgraded database from 126.96.36.199 to 188.8.131.52. It worked fine in 184.108.40.206
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