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 #162: About Display Only Items in Oracle APEX
In this week's tip, any time you set a value in the browser, a user could...
Read moreAPEX Instant Tips #161: More about hashing than you could possibly want to know…but you should.
Marwa and Anton take you through hashing and checksums. Maybe more than you could possibly want...
Read moreAPEX Instant Tips #160: APEX utilities you may never need, but if you do, they’re good to know.
Anton and Marwa show you the utilities you can find in APEX Object Reports, and there...
Read moreAPEX #159: Recipes from the IG Cookbook
Marwa and Anton show you amazing things you can do with an Interactive Grid through recipes...
Read moreAPEX Instant Tips #158: Opening multiple browser tabs
Are you concerned about users opening multiple browser tabs? You should be...Marwa and Anton explain.
Read moreAPEX #157: Refreshing Region Plugin Regions
Anton and Marwa discuss how to make region plugins regions refreshable. Anton provides a boilerplate plugin...
Read moreAPEX 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 moreAPEX 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