Tag Archives: database

Statistics Collection Enhancements on Oracle Database 12c

*+-I’ve been having a play around with the enhancements to the statistics collection in 12c. I’ve put together this top-level post with links to all my other articles on this subject. Statistics Collection Enhancements in Oracle Database 12c Release 1 (12.1) Here are the new articles it links to. Session-Private Statistics for Global Temporary Tables in […]

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

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

Roll up! Roll up! Nothing new to see here! (Database Web Services)

*+-Over the years I’ve written loads of stuff about consuming and publishing web services directly from the database. I’ve been doing quite a bit of this at work recently and I realised how difficult it is to find all the pieces, since they are spread across multiple articles, spanning multiple database versions. In an attempt to […]

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

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

Oracle Database 12c Release 1 (12.1.0.2) Patch Released

*+-I just read this post by Dirk Nachbar, saying that 12.1.0.2 is now available from edelivery.oracle.com. I’ve downloaded it, so the rest of the world is now allowed to start their downloads. I assume it will be available from MOS also at some point. Cheers Tim… PS. It will allegedly be made available on OTN […]

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