Follow Connor McDonald's Oracle blog on Feedspot

Continue with Google
Continue with Facebook

Connor McDonald's Oracle blog
This is all about idle musings on Oracle over the years are posted.
One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the source table(s) from which they are ..read more
Anyone that has used SQL Plus since its inception will be familiar with this frustration: There is my window, with all of that lovely ..read more
A couple of years back (wow…time flies!) I made a video and a post about the de-support of UTL_FILE_DIR in 18c. This was good thing ..read more
When the scheduler came into existence in Oracle 10g, there was a cool API call that could be used to temporarily turn the entire ..read more
Most administrators are now aware of the lockdown profile facility in the Oracle database (available since 12c). They allow a more ..read more
In the previous post, I described the importance of checking V$IM_SEGMENTS to ensure that the in-memory store is populated to have ..read more
First of all … Happy New Year! This is my first post for 2020. Last year, I fell just short of 100 blog posts for the year – so this ..read more
A quick tip just in time for Christmas I logged on to my database this morning, and things just didn’t look right. In fact, they looked ..read more
Just a quick tip that often catches me out. If you are like me, you have long since tired of clicking Next, Next, Next, … through the ..read more

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview