Oracle Application Express (MOSC)

MOSC Banner

Performance improvement in queries run by APEX pages

Environment : APEX 18.1

Problem: An apex page is taking lot of time while the query runs faster in SQL developer.

Analysis: Every query run by APEX seems to be wrapped and then run , resulting in varying sql id every time it runs. Due to this, DBAs are unable to tune or apply a system suggested profile that can improve performance.

Question: Is there a way out to make this query unique or identifiable by the database so that whatever tuning efforts database puts does not go waste, rather once tuned can be of use for every run of that query through APEX irrespective of user or session.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center