Tag Archives: database

Automatic Diagnostics Repository (ADR) in Oracle Database 12c

*+-There’s a neat little change to the Automatic Diagnostics Repository (ADR) in Oracle 12c. You can now track DDL operations and some of the messages that would have formerly gone to the alert log and trace files are now written to the debug log. This should thin out some of the crap from the alert log […]

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 […]