Tag Archives: database

Articles on Oracle Database 12c Multitenant Option

From a technology perspective, the Multitenant option is really cool, but it can be rather difficult to get to grips with some aspects of it. Everything is so intertwined and every feature in 12c somehow links back to the Multitentant option. As I’ve been working my way through the features the same pattern keeps repeating. [...]




Data Pump Enhancements in Oracle Database 12c

Another one to file under “Not sexy but flippin’ awesome!” If you are a DBA, you are going to spend a lot of time with Data Pump. All roads seem to lead back to it. There are some more headline worthy features, like transportable database, but the two that jumped out at me were actually [...]




Warning: Problems with 9.2 clients connecting to databases patched to 11.2.0.4…

I mentioned this a couple of days ago on Twitter, but I’ve only just go round to posting here… I recently had to back out some 11.2.0.4 patches because the patch seems to cause problems with Oracle 9.2 client connections where 11.2.0.3 worked fine. I’m not sure how widespread the problem is. All I can [...]




Cloud Control 12c Database Backup Jobs (Continued)

I’ve been rather critical of the way Cloud Control handles database backup jobs, as can be seen in these two previous posts. I love Cloud Control 12c, but the job management is really annoying! Oracle Cloud Control EMCLI : First Thoughts Yesterday I found out I schedule database backups in Cloud Control the “wrong way”… [...]




Quick Pluggable Database (PDB) Update…

I’ve been playing around with using SQL Developer and Cloud Control 12cR3 for managing pluggable databases (PDBs) this morning. I’ve added a couple of quick references to my PDB article. Multitenant : Create and Configure a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1) If you understand the DBCA and SQL*Plus approach, the [...]




Upgrading to Oracle Database 12c : First Steps…

I’ve taken my first tentative steps into upgrading to Oracle 12c. Upgrading to Oracle Database 12c This article is targeted at the type of information you are likely to need for the 12c OCP DBA exam. In reality, upgrades are too important to rely on a generic article like this. Every time I do a [...]




Windows Blue (8.1) and Oracle Database 12c

Inspired by this article, I decided to download Windows Blue 8.1 and install it on VirtualBox. Once Classic Shell was installed it looked almost usable. The Windows version of Oracle 12c is now available, so that seemed like the obvious thing to try next. That went really smoothly. I’m bored with Windows now, so I’m off back to Linux. [...]




Top-N Queries and the Multithreaded Model in Oracle 12c…

A couple of new 12c articles have rolled off the press. Both of them small, but interesting to me. Row Limiting Clause for Top-N Queries in Oracle Database 12c Release 1 (12.1) Multithreaded Model using THREADED_EXECUTION in Oracle Database 12c Release 1 (12.1) These resulted in amendments to a couple of old articles. Top-N Queries [...]




WITH Clause Enhancements in Oracle 12c…

After doing a number of 12c installations, I decided it was time to write something new. I figured I’d pick something easy to start off with, so here is the first thing off the press. WITH Clause Enhancements in Oracle Database 12c Release 1 (12.1) Over the last year I’ve heard a few speakers talk [...]




How can we make Oracle Database 12cR2 the best release ever?

Oracle will be releasing Oracle Database 12cR1 at some point this year. Many companies will avoid this release, opting to wait for 12cR2, their reasoning being it will be more stable and, as a terminal release, will have a longer support life-cycle. Since 12cR2 is what most businesses care about, what can we do to make [...]