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 #158: Opening multiple browser tabs
Are you concerned about users opening multiple browser tabs? You should be...Marwa and Anton explain.
Read more
APEX #157: Refreshing Region Plugin Regions
Anton and Marwa discuss how to make region plugins regions refreshable. Anton provides a boilerplate plugin...
Read more
APEX Instant Tips #156: Informing users about background processes
Anton and Marwa discuss Background processes: informing users of what is happening and what occurs upon...
Read more
APEX Instant Tips #155: About icons and buttons builder
We have extended the Universal Theme application to allow more customization within the icon and button...
Read more
APEX Instant Tips #154: How to Recenter a Map Region
What is this episode about? Hint: Initial position in zoom, isn’t enough…
Read more
APEX Instant Tips #153: Everything you always wanted to know about combobox but never thought to ask
With Combo boxes, you must manage your business rules and watch for multi-user concurrency issues. Anton...
Read more
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
