Tag Archives: 12c

Flashback Data Archive Enhancements in Oracle Database 12c

Having played around with Flashback Data Archive in 11g, I figured I would get through the 12c enhancements pretty quickly. I didn’t account for the fact I’m a donkey and can’t see the wood for the trees. Luckily, I know some people who aren’t stupid and they gave me a nudge in the right direction, […]

Adaptive Query Optimization in Oracle Database 12c

Over the holiday period I finally decided to tackle the Adaptive Query Optimization stuff in Oracle 12c, which resulted in these articles. Adaptive Query Optimization in Oracle Database 12c Release 1 (12.1) : A links page to the other articles. Adaptive Plans in Oracle Database 12c Release 1 (12.1) Dynamic Statistics in Oracle Database 12c Release […]

Fedora 21 : Oracle 11g and 12c Installations

Fedora 21 has arrived and it’s now delivered in three focussed flavours (Workstation, Server and Cloud). This of course resulted in the usual articles from me. Fedora 21 (F21) Installation Oracle Database 11g Release 2 (11.2) Installation On Fedora 21 (F21) Oracle Database 12c Release 1 (12.1) Installation On Fedora 21 (F21) As always, read […]

Oracle Database 12c : EXPAND_SQL_TEXT, APPROX_COUNT_DISTINCT, Session Sequences and Temporary Undo

While I was away on the OTN APAC tour, I wasn’t really able to sink my teeth into anything, so inspired by Connor McDonald‘s session in Perth, I decided to write up a few bits and pieces in my free moments in the hotels and planes (when I had enough elbow room to type). Here […]

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