Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it correct that APEX recompiles any PL/SQL package before calling it with every call?

j.siebenMay 17 2023

Hi,

I added some instrumentation to my packages which are called by APEX and it seems that anytime I open a page or make an AJAX call, every package gets recompiled, as it is constantly calling the initialization code of these packages.

I always assumed that the packages are cached within their respective connect pool sessions, but I can't see this effect.

So my question is: Does APEX always recompile any package prior to using it or is there something I'm doing wrong? Plus: Is it possible to somehow control that and probably avoid this from happening?

Best regards,

Jürgen

This post has been answered by fac586 on May 17 2023
Jump to Answer
Comments
Post Details
Added on May 17 2023
4 comments
297 views