Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » tuning queries run through APEX (DB12.2.0.1, APEX 5.1.4)
tuning queries run through APEX [message #687828] Thu, 22 June 2023 11:51
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
I'm trying to tune an APEX app declaratively: by setting parameters for the database instance, not by hacking the code. Specifically, I need some dynamic sampling. I make the parameter change, run the code through SQL*Plus, and it works perfectly: the exec plan I want, sampling and all. But when it is run through the APEX app, it is still using the bad plan. So I asked the developer to embed the dynamic sampling hint in the code. It still doesn't work! The Statspack SQL report shows the code with the hint there, but the cardinality estimates are those I get without any sampling. Is there something in APEX or ORDS that means hints get ignored? That instance parameters get ignored? Is there anything special you need to do if code is invoked by APEX?

Thank you for any insight.
Previous Topic: migrate APEX from Oracle 11g to Oracle XE 21
Next Topic: arabic translation of customer tracker productivity appp in Apex (3 merged)
Goto Forum:

Current Time: Sat May 18 21:31:46 CDT 2024