All articles

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: The secret of moving datafiles online

Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals. To do(…)

Oracle Cloud Application Foundation for next-generation applications

On 11 July 2013, Oracle launched the so-called Cloud Application Foundation. An online launch event was organized on 31 July 2013 to introduce this new term in the Oracle Stack. This event had two parts: Keynote and Customer &(…)

Oracle Database 12c: PDBs not fully transportable yet

One of the benefits of the new Oracle multi-tenant database option is to create a kind of cloned environment through simple statements. This post will focus on the creation of pluggable database through a database link. The reason of(…)

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…(…)

SQL Server 2012 SP1: Fifth Cumulative Update (CU5) available

On 16 July, Microsoft published the fifth Cumulative Update (CU5) for Microsoft SQL Server 2012 Service Pack One. As usual, if this Cumulative Update solves an issue you are facing, install it quickly – otherwise, do not install it. Which(…)

Oracle Database 12c new features: segregation of duties with new administrative roles

Starting with Oracle Database 12C Release 1 a set of new administrative privileges that are more task oriented are available.Before Oracle 12c it was needed to have the SYSDBA privilege to make a backup, to monitor the Data(…)

Documentum Administrator does not display the correct “Index Agent” status

At one of my customers, I experienced a problem with the Documentum Administrator (DA), which did not display the correct Index Agent status. In this blog post, I will explain how I found the source of this problem and of(…)

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(…)