Learning is not a spectator sport

UTL_CALL_STACK lends a helping hand to DBMS_UTILITY

Oracle dinosaurs whoops I mean “experienced professionals” know that for decades we have used the DBMS_UTILITY package to obtain the

Just a quick tip today on doing a “reset” on your optimizer environment. SQL Plan Baselines are an awesome tool

I tweeted about a particular bug fix that interests me for 19.11, namely a critical fix for Flashback Data Archive

I tweeted out this pic yesterday which suggested that by running a SQL query, I could magically keep my OPatch

There is a million books, blogs, presentations etc about SQL Tuning. But it’s time for a different perspective. SQL Tuning

AskTom regular Rajeshwaran Jeyabal posted an interesting comment a few days ago about the use of CURSOR_SHARING when it comes

Your pre-reading warning: I’m quoting some tweets in this post, tweets that definitely contain some NSFW language. The success of

I gave a talk at Kscope21 yesterday about common mistakes that we make during the database development cycle. To kick

I posted late last year about how to query APEX patch updates directly from the database. Now that APEX 21

There are plenty of tools out there that you can use to get DDL scripts for various objects in the