Do you have APEX application processes that are unexplainably slow? Hayden demonstrates how to locate the problematic code with DBMS_HPROF.
Useful link: Hayden’s query to find problem code
https://gist.github.com/hhudson/8755719ce7a6cc71519b861346b5819d#file-v_execution_stats-sql
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #152: APEX.debug
In this episode, Anton and Marwa compare Console.log, APEX_debug.log, APEX_debug.message, and APEX.debug.setlevel.
Read more
APEX Instant Tips #151: Updates to tips 148, 146 & 53
A review and update of 3 previous instant tips: Checksum, Faceted Search, and Multilingual Apps from...
Read more
APEX Instant Tips #150: Rarely Used Region Types (RURTs)
Different Region Types, including the Toggle Column Report Region, Avatar Region, Reflow Region, and Smart Filters.
Read more
APEX Instant Tips #149: APEX Dev Team Magic: APEX Item Plug-in
Anton and Marwa show you a magical query. No matter what type of LOV definition you...
Read more
APEX Instant Tips #148: Protect Ajax Callback processes from hacking
Last week, we made it easy to use Ajax Callback processes. This week, we show how...
Read more
APEX Instant Tips #147: Why are Ajax Callback processes so hard to use?
Ajax callbacks are hard to use: Learn the javascript and be careful about syntax. Marwa and...
Read more
APEX #146: APEX Instant Tips #146: Extending Faceted Search
Hosts Anton and Marwa talk about how to make a page item look and behave like...
Read more
APEX Instant Tips #145: How to know if the data in your Interactive Grid row changed
:APEX$ROW_STATUS is a pseudo column that can be used in PL/SQL, just like any other interactive...
Read more