SQL*Net and the CONTAINERS clause
Complete separation of pluggable databases is naturally a good thing when it comes to protecting the rights and data of
The performance report you are NOT using
Just a quick post today to inspire you to look further than the standard options for performance monitoring. Quiz most
Why does SUM look broken for window functions?
TL;DR: SUM is NOT broken A quandary from a work colleague this morning about rolling totals via the SUM aggregation
Much ado about (paying) nothing
A couple of days ago, we announced some more free goodies to Oracle Cloud. As most readers will know, we
Big bits – really long bit strings
A while back we had an AskTom question about arbitrary length addition and subtraction, and so I whipped a small
New Podcast Episode! Every index is a bug
Every database has indexes…but should they? In this episode, lets consider a different proposition. What if the indexes you have
Better performance when querying the V$ views
I’m a big fan of giving developers the tools they need to tune their applications in Production if that is
UNLONG my dictionary – those pesky LONG columns
We’ve have all seen those TV crime shows where the psychiatrist does word association games, such as: Question: “Blue?” Answer:
(Offtopic) Month 1 is in the books…Thanks Sarah
Just a quick end of month blog post to give a shout out to Sarah Craynon Zumbrum who posted this
Column names you should NOT use
We all know from our data modelling days… (Sidenote: Remember those days? You know…when we used to think about good
