| tuning queries run through APEX [message #687828] |
Thu, 22 June 2023 11:51 |
John Watson
Messages: 8960
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
