Tag Archives: 12c

Pattern Matching (MATCH_RECOGNIZE) in Oracle Database 12c

I’ve spent the last couple of evenings playing with the new SQL pattern matching feature in Oracle 12c. Pattern Matching (MATCH_RECOGNIZE) in Oracle Database 12c Release 1 (12.1) I’m doing some sessions on analytic functions in some upcoming conferences and I thought I should look at this stuff. I’m not really going to include much, […]

JSON Support in Oracle Database 12c (12.1.0.2)

I spent a bit of time at OpenWorld looking at the JSON support in Oracle Database 12c. I started to write some stuff about it on the plane home and I spent the last two mornings finishing it off. You can see the results here. JSON Support in Oracle Database 12c Release 1 (12.1.0.2) Indexing JSON […]

PL/SQL New Features in Oracle Database 12c

I recently put some more PL/SQL new features articles live. PL/SQL-to-SQL Interface Enhancements for PL/SQL-Only Data Types in Oracle Database 12c Release 1 (12.1) Edition-Based Redefinition Enhancements in Oracle Database 12c Release 1 (12.1) Multitenant : Database Triggers on Pluggable Databases (PDBs) in Oracle 12c Release 1 (12.1) I’ve also posted a top-level new features […]

Temporal Validity, ACLs, External Tables, SQL*Loader and more in Oracle 12c

Some more 12c articles have trickled out over the last few days. Temporal Validity in Oracle Database 12c Release 1 (12.1) Fine-Grained Access to Network Services Enhancements in Oracle Database 12c Release 1 External Table Enhancements in Oracle Database 12c Release 1 (12.1) SQL*Loader Enhancements in Oracle Database 12c Release 1 (12.1) I kind-of mentioned this […]

A few more 12c articles

A few more 12c articles went live over the last few days… Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1) Invisible Columns in Oracle Database 12c Release 1 (12.1) In-Database Archiving in Oracle Database 12c Release 1 (12.1) The DMU and In-Database Archiving are from the OCP syllabus. The Invisible Columns […]

To PDB or not to PDB : The final decision

After yesterday’s to PDB or not to PDB post, I decided the answer was “to PDB”. Here’s what I did… Installed the Oracle 12c (12.1.0.2) software. There is an installation article here, but all I had to do was a software-only installation because the OS already met all the prerequisites because of the existing 11.2.0.3 […]

To PDB or not to PDB

I’m about to start a Proof of Concept (POC) for a 12c upgrade of one of our databases. The production database in question is running on Oracle Linux inside a VMware virtual machine, so the starting point I’ve been given for the POC is a clone of the whole VM… Probably the biggest decision I’ve got to […]

EM Cloud Control 12c : The 24 Hour DBA

I think I’ve lived through all the ages of Enterprise Manager. I used the Java console version back in the days when admitting you used it got you excommunicated from the church of DBA. I lived through the difficult birth of the web-based Grid Control. I’ve been there since the start of Cloud Control. I’ll […]

Invoker Rights in Oracle Database 12c : Some more articles

I wrote about the Code Based Access Control (CBAC) stuff in Oracle Database 12c a while back. Code Based Access Control (CBAC) : Granting Roles to PL/SQL Program Units in Oracle Database 12 Release 1 (12.1) I’ve recently “completed the set” by looking at the INHERIT PRIVILEGES and BEQUEATH CURRENT_USER stuff for PL/SQL code and […]

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