Tag Archives: 12c

In-memory DB

A recent thread on the OTN database forum supplied some code that seemed to show that In-memory DB made no difference to performance when compared with the traditional row-store mechanism and asked why not.  (It looked as if the answer was that almos…

Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch

Background
Oracle Database 12c brings us many new features including: the long needed ability to run OPatch and query the patch software installed in the Oracle Home programatically through SQL using the new DBMS_QOPATCH package.
If you’re a DBA …

Robert G. Freeman on Oracle 2015-01-07 21:56:12

Note: Something happened to this original copy of this post. I’m not sure what it was, but somehow it was like a draft copy ended up being posted and it lost almost half it’s content. I have re-created the post. So, for those of you who saw the earlier…

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 w…

Performance Problems with Dynamic Statistics in Oracle 12c

I’ve been making some tests recently with the new Oracle 12.1.0.2 In-Memory option and have been faced with an unexpected  performance problem.  Here is a test case:
create table tst_1 as
with q as (select 1 from dual connect by level <= 100000)…

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.
Adapt…