I’ve just come back from OracleCode Singapore. It was a great event – the venue was awesome and the attendees
Just a quick post here so I could consolidate some information about histograms in 12c. On my last Office Hours
We had an AskTOM question recently about being able to search for numbers within a concatenated list. The particular issue
Sometimes in the IT world, the term “surprise” is not a good one. “I woke up this morning and got
Just a quick revisit on an old topic so I could link to this post in a Stack Overflow discussion.
To protect the integrity of people’s data, and isolate sessions on LiveSQL, we lock down the environment. Clearly if you
Jonathan Lewis just published a blog post about NVL and COALESCE and the optimizer costings for each. There is also
When it comes to giving the cost based optimiser the best possible chance to make the “right” decisions, many DBA’s
This question came to me over Twitter, so I thought I’d whip out a quick post on it Yes,
We often think of Advanced Compression being exclusively about compressing data “at rest”, ie, on some sort of storage device.