My wife and I are celebrating 20 years married (to each other!!!) , and I will not be here answering questions or posting new content for the next two weeks. However, there is a LOT scheduled to happen in the database tools world while I’m out. So be sure to follow @krisrice for news and updates. Oh, and if you like to torture yourself by watching others having fun, you can find me pretty easily…

I have a PL/SQL block of code – I wonder where most of the time is being spent to execute it? Well guess what? The PL/SQL team has given us an interface to answer this exact question. The PL/SQL Hierarchical Profiler does 3 things of note: Reports the dynamic execution profile of your PL/SQL program, organized by subprogram callsAccounts for SQL and PL/SQL execution times separatelyMakes me feel like an idiot whenever I try to…