Oracle Team

Oracle Grid Infrastructure 12c: prerequisites for installation

Grid infrastructure 12c has recently been released. In this posting, I will show that the installation prerequisites are quite similar between Grid Infrastructure 11g and 12c. We will see parts of them during a review for the deployment of(…)

Oracle 12c: Partitioning enhancements Part II – Other improvements

Oracle Database 12c offers several enhancements for partitioning. In a previous blog posting, I talked about reference partitioning enhancements. This post will present other enhancements in relation to general partitioning. Asynchronous index maintenance With Oracle database, a global index(…)

Oracle Database 12c : démarrage automatique des Pluggable Databases

Dans ce blog post, nous allons nous intéresser à la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l’arrêt et le démarrage automatiques des PDBs en utilisant le Server Control (srvctl) du(…)

Oracle Database 12c: SecureFiles enhancements

Oracle Database 12c features with some enhancements for LOB objects and particularly for the SecureFiles. This is not a revolution, but we can see that the range of possibilities with LOB objects increases with the different releases of Oracle…(…)

Oracle Database 12c: Partitioning enhancements Part I – Reference partitioning

Oracle Database 12c offers several enhancements for partitioning. This blog posting will present some enhancements in relation to reference partitioning. The differences between the Oracle 11g R2 and Oracle 12c releases will be shown using practical examples. TRUNCATE and(…)

Oracle Database 12c: Information Lifecycle Management

More and more resources are used in companies to manage data. Most companies buy more and more storage systems because of poor resource utilization. Starting with Oracle 11g, Oracle has introduced Information Lifecycle Management (ILM) which can use different kinds(…)

Oracle Database 12c: Moving a datafile is now possible online

Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and(…)

Oracle Database 12c: Flashback Data Archive (FDA) – new features

Oracle Database 12c was published in June and among the new features of this release are multiple improvements of the Flashback Data Archive (FDA), an option also known as Oracle Total Recall. In this post, I will present the(…)

Oracle Database 12c: Oracle OEM express

Together with Oracle Database 12c, Oracle has introduced a new administration console named Oracle Enterprise Manager Express (Oracle OEM Express). This “light” version of Enterprise Manager Database Console – which is not supported in Oracle 12c anymore – is a(…)

Discovering Oracle database 12c targets (CDB, PDB) in Cloud Control 12c

In my consultant’s activity at dbi services, I had the opportunity to test the new databasion version Oracle 12c. As an Enterprise Manager Cloud Control 12c fan, when the 12.1.0.3.0 Oracle database plugin was made available, I decided to(…)