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
Category: Uncategorized
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
Unique all the things … including your pluggables
A quick tip just in time for Christmas I logged on to my database this morning, and things just didn’t
Listener log data mining with SQL
If you take a look at the log files created by the listener, there is obviously a nice wealth of
