This week, special guest Joel Kallman joins Hayden and Anton to show how one can remote debug a user’s session using:
Monitor Activity — Active Sessions — Enable Debug.
Setting the Debug Level to ‘APEX Trace’ will get you the query’s execution plan.
Not an APEX Workspace Administrator? Not to worry! Joel’s got you covered with a set of queries you can build right into your app.
View Past Episodes
Full episode list on YouTube here.
Past Episodes
APEX Instant Tips #139: How to hide inactive rows in an LOV _unless_ the record has that value
Every APEX user can appreciate this. Once you get there, the route seems obvious, but most...
Read moreAPEX Instant Tips #138: How to read & understand the help for PopUp LOV JS Initialization Code
Anton and Marwa discuss how to read and understand the help for PopUp LOV > Javascript...
Read moreAPEX Instant Tips #137: How many APEX developers does it take to screw in a lightbulb?
Anton explains why all your tables with foreign keys should have an index on the foreign...
Read moreAPEX Instant Tips #136: Expertly crafted with love by Insum using Oracle APEX
From creating text messages in the shared component application (tip #86) to how you can change...
Read moreAPEX Instant Tips #135: It’s valuable for developers to understand the APEX Infrastructure
It's important to understand how ORDS handles the connection pool and connection security. ORDS connections to...
Read moreAPEX Instant Tips #134 : Weighted Page Performance reporting in Dev, in UAT, and, oh yeah, in Prod.
Anton and Marwa go over 3 interesting tips on Weighted Page performance that can be used...
Read moreAPEX Instant Tips #133: Tiny Tips for Teams Tackling Tasks Together
Quick tips to customize your APEX Workspace, Anton adds his Wisdom of the week: "Step back...
Read moreAPEX Instant Tips #132 AuthN vs AuthZ
Anton and Marwa talk about the difference between Authentication and Authorization in particular when applied to...
Read more