Tag: 12c

ASM 12c : How to Rename a Diskgroup

Fred Denis, Pythian Oracle Database Expert, explains how to rename a diskgroup.

Read More >

Advanced Compression Option Caveat in Oracle 12c

  Oracle 12c introduced a new capability to move a partition online, without any interruptions to DML happening at the same time. But, there’s a catch. So far we’ve been able to use basic table compression without having to worry…

Read More >

ORA-10173: Dynamic Sampling Time-Out Error

  Recently on a heavily used and freshly upgraded 12.1.0.2 ware-house type database, we started seeing lots of ORA-10173 dumped into the alert log. The information out there on this error is somewhat sparse, and it is often linked to…

Read More >

Patching Fun: GI and Database Patches

So, it has been some time since I have patched a database. Patching seemed necessary in a 12c database used for testing, as it was having some crashing issues. As the database and GI home were both un-patched, it seemed worthwhile to…

Read More >

Slimming Down Oracle RAC 12c’s Resource Footprint

Oracle Grid Infrastructure 12c uses a considerable amount of RAM and CPU resources; here are a few tips to shoehorn it into a 2GB virtual machine.

Read More >

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

Read More >

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: Waiting for in-memory segment population: Now let’s make a simple two table join:…

Read More >

12c: Fun with WITH!

Last night I couldn’t sleep and what else you’re going to do? I was thinking about Oracle stuff. In Oracle version 12, Oracle has enhanced the WITH clause – traditionally used for sub-query factoring – to allow the declaration of functions and…

Read More >

12c Multi-tenant Environment and DBRM for Container Database

In multi-tenant environment, Database Resource Manager (DBRM), at the Container Database (CDB) level enables us to manage the resources like CPU usage and number of parallel execution servers among the plugabble databases (PDBs). Then within each PDB, DBRM enables us…

Read More >

RMAN 12c : Say goodbye to your backup when dropping your PDB

Update: 09/March/2015 .- I wrote a second part and followed up on this on my personal blog RMAN 12cR1 : Say goodbye to your backup when dropping your PDB – Part II I was working on my presentations for IOUG Collaborate,…

Read More >
Page 1 of 212