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.