dba – Learning is not a spectator sport

Nulls are not stored in indexes … most of the time

This question got posed on Twitter today I answered briefly on Twitter, but I thought I should give it some

Man, it gets my goat when people start pontificating nonsense on Twitter. Yeah, I know, I know, I shouldn’t get

I had someone say to me at an event recently: “We’re are going to upgrade to 18c, because 19c is

Anyone that has used SQL Plus since its inception will be familiar with this frustration: There is my window, with

When the scheduler came into existence in Oracle 10g, there was a cool API call that could be used to

A quick tip just in time for Christmas I logged on to my database this morning, and things just didn’t

If you take a look at the log files created by the listener, there is obviously a nice wealth of