All articles

Oracle 12cR2 PL/SQL new feature: TNSPING from the database

By Franck Pachot . Database links are resolved with the server TNS_ADMIN configuration (sqlnet.ora and tnsnames.ora). You can use tnsping to check the resolution, but it supposes that you are on the server and have set the same environment(…)

Oracle 12cR2 : Partitioning improvements – auto-list partitioning

The second release of Oracle Database 12c (12cR2) comes with new improvements regarding partitioning. In this blog post I’ll show one of them : auto-list partitioning. Auto-list partitioning is an extension of list partitioning. It enable the automatic(…)

EDB Postgres Advanced Server 9.6 BETA released

Yesterday EnterpriseDB released the beta of the next version of Postgres Advanced Server. You can sign up for the beta program here and download the software here.

Oracle Public Cloud: create a database from command line

By Franck Pachot . You love the Oracle Public Cloud with its simple Web interface? Great. But what if you want to automate a database creation from command line? Easy with the CURL and REST API.

Documentum story – Migrate repository cryptography from crypto key to the crypto keystore

In this blog post I will explain the migration of the crypto key (aek.key) to the crypto keystore (lockbox) for an upgraded repository. In fact, during customer activities, I has been involved in the migration of a repository hosted on(…)

SQL Server AlwaysOn availability groups and statistic issues on secondaries

I would like to share with you an interesting issue you may face while using SQL Server AlwaysOn availability groups and secondary read-only replicas. For those who use secondary read-only replicas as reporting servers, keep reading this blog post because(…)

Dbvisit replicate when you flashback the target

By Franck Pachot . I had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is(…)

12c online move datafile in same filesystem.

By Franck Pachot . On Linux, when you move a datafile, with "mv" within the filesystem it's just a rename. There is no copy. In 12c you can move a datafile online where oracle takes care of the move at(…)

Momentum16 – Day 2 – C6, Load Testing and REST API

So today is the second day of the Momentum 16 in Barcelona and as expected, this day contained many more technical presentations and discussions than the first day. I attended several interesting presentations and hackathon/hands on sessions as well so(…)

Momentum16 – Day 2 – What’s new in Documentum 7.3 ?

As described in my last post related to Momentum 16, I was excited to see the session “What’s new in Documentum 7.3”. Do not worry, I could slept last night. But are my expectations fulfilled?   So yesterday I wrote(…)