18c versus 19c
I had someone say to me at an event recently: “We’re are going to upgrade to 18c, because 19c is
Category: Uncategorized
GROUP BY might be distinctly better than DISTINCT
One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the
SQLPlus goodies with linesize
Anyone that has used SQL Plus since its inception will be familiar with this frustration: There is my window, with
UTL_FILE_DIR and 18c revisited
A couple of years back (wow…time flies!) I made a video and a post about the de-support of UTL_FILE_DIR in
Has my scheduler been turned off?
When the scheduler came into existence in Oracle 10g, there was a cool API call that could be used to
Monitor your lockdown profiles
Most administrators are now aware of the lockdown profile facility in the Oracle database (available since 12c). They allow a
Getting the most out of in-memory – part 2
In the previous post, I described the importance of checking V$IM_SEGMENTS to ensure that the in-memory store is populated to
