It sounds like you guys have a solution, but I wanted a POC for this that we could check into our library, so I came up with this… SQL> create or replace type expr_skulist_type as object(skulist number, 2 item varchar2(25),…
Category: Real Life Analysis
Poor man’s way to calculate query time from app server
I wanted to understand where an app was spending time. I couldn’t get the granularity I needed from New Relic, and SSMS aggregated the data so I couldn’t see it. I came up with what is below, admittedly, somewhat obtuse,…
Gotcha on automatic PL/SQL recompilation
What is below is taken from an actual analysis of heavy latching and invalid objects after a change was made. This was done in early 2011. For a long period of time, we have avoided making changes that would result…