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
Category: Uncategorized
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
Getting the most out of in-memory
First of all … Happy New Year! This is my first post for 2020. Last year, I fell just short
