We killed sequence contention!
A few months back I gave a talk on the importance of good physical design if you need to meet
Blockchain tables … the usage model
When you hear the word “blockchain” we typically think of the properties associated with tamper-proof information, with terminology such as
Time zones, blockchain and stopping hackers
I posted a few months ago about the availability of blockchain tables in 19c, and a fundamental mantra with anything
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
Drop all baselines
Just a quick tip today on doing a “reset” on your optimizer environment. SQL Plan Baselines are an awesome tool
19.11 Database Release Update
I tweeted about a particular bug fix that interests me for 19.11, namely a critical fix for Flashback Data Archive
Keeping OPatch updated with a simple SQL query
I tweeted out this pic yesterday which suggested that by running a SQL query, I could magically keep my OPatch
New Podcast Episode! Lets talk about SQL Tuning
There is a million books, blogs, presentations etc about SQL Tuning. But it’s time for a different perspective. SQL Tuning
CURSOR_SHARING and ORDER BY
AskTom regular Rajeshwaran Jeyabal posted an interesting comment a few days ago about the use of CURSOR_SHARING when it comes
More analysis, less assassination
Your pre-reading warning: I’m quoting some tweets in this post, tweets that definitely contain some NSFW language. The success of
