Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: 18c
From Database 18.3 to 18.5 (on Windows)
Contrary to wild rumours on the internet, it was not a fear of the number 13 that led to a numbering jump from version 12c to version 18c. The jump was part of our new, more flexible release mechanism so that we can get…
Happy Thanksgiving!
Just a quick blog post from Wellington New Zealand where we have just wrapped up the 2018 APAC Groundbreakers tour. It was a great way to finish the event with a small but enthusiastic crowd here in New Zealand. Obviously our American counterparts in…
18c and the ignoring of hints
One of the new features in 18c is the ability to ignore any optimizer hints in a session or across the entire database. A motivation for this feature is obviously our own Autonomous Data Warehouse, where we want to optimize queries without the…
18c XE–running locally
There’s already a few blog posts out there, showing people (easily) getting their 18c XE instance downloaded, installed and running, so I won’t rehash that here. For the majority of people, I’d imagine they’ll have their XE instance running on a small box and…
18c XE is live!
Just a quick post because this is perhaps what I think is one of the biggest game changers for the Oracle Database. 18c Express Edition (18x XE) is now available for general use. For those people with experience with 11g XE, this might not…
18c database creation on Windows
Hopefully you’ve followed my very simple and easy guide to downloading the 18c database software for Windows. But of course, software on its own is not much use – we need a database! So let’s get cracking and create one. Using the Start menu…
18c Database installation on Windows
If you’re a Windows enterprise, or you want to run your 18c database on your Windows laptop/desktop for research and education, then there has been some good news this week. The software is now available to you on the OTN network page. Here’s a…
Hyper-partitioned index avoidance thingamajig
As you can tell, I have no idea on a name for what I am about to describe. So let me start from the beginning, and set the scene for an idea I have to utilize a cool new 18c feature. Often in a…
18.3 As easy as 1…2…3
Well, finally it’s here! 18c for on-premise installation so the world can all get stuck into the cool new features of the latest release on their own laptops At least that is what I’ll be doing! Naturally as soon as I heard the…
UTL_FILE_DIR and 18c
I wrote a blog post called The Death of UTL_FILE which attracted a comment from a reader: “There is NO chance to stay at UTL_FILE as it is DESUPPORTED starting with database Version 18c” This is not the case, but since I wanted to…
18.2 patch… painless for me
18.2 was released a few days ago, so I thought I’d throw it against my 18c instance and see how things played out. This was just a single instance database, running with a single pluggable. Step 1 for me was to download the latest…
18c merge partition online
One of the cool things in 18c is the ability to merge partitions without causing a service interruption. Here’s a video demonstration of that in action: This is just an accompanying blog post to let you grab the scripts for the demo so that…
