In the databases that I currently manage, PL/SQL functions are used everywhere. Honestly, one of the things I do when I try to get serious about tuning a SQL query is to (if it can be easily done) eliminate any PL/SQL functions and try to re-write them as “plain SQL” expressions.
Archive: May 2017
When you’re looking at V$ACTIVE_SESSION_HISTORY, there are two columns that are capable of confusing the heck out of you if you’re not careful because they are named so similarly. I decided to delve into precisely what these columns mean.