Infrastructure at your Service

All posts by Franck Pachot

Franck Pachot
Technology Leader
Senior Consultant

OCM 11gFranck Pachot has 20 years of experience in Oracle databases. Through his expertise as a DBA, Oracle expert, data architect, and performance specialist, he is able to cover all database areas: architecture, data modeling, database design, tuning, operation, and training. Franck Pachot knows how to enable an efficient collaboration between the developers and the operational team when it comes to troubleshooting issues or performance tuning.

RSSOracle ACE Franck is Oracle Certified Master (OCM 11g) and an Oracle ACE.

Next public appearance:
Paris Oracle Meetup
Paris, September 4th

In-Memory, Reading AWR
Swiss BI-DAY
Geneva, October 6th

In-Memory for BI
DOAG conference
Nuremberg, November 19th

Oracle locks
Birmingham, December 6-7-8th

SQL Plan Directives, Reading AWR, Oracle locks
Oracle Midlands
Birmingham, January 26th

Oracle locks, Reading AWR

Franck Pachot

Trying AppDynamix – monitoring application from user to database

By | Development & Performance | No Comments

I like to come upon new monitoring software that help to go quickly from user response time to root cause. And I love applications that can be installed easily and at which I can give a try without reading pages of manual. At DOAG 3rd floor I’ve visited the AppDynamics booth and immediately wanted to install the trial version and give it a try.  

Read More
Franck Pachot

Cloud Control 12c on your laptop

By | Database Administration & Monitoring | No Comments

Today every DBA should have a lab on his laptop. This is where I reproduce most of cases before opening a SR, or to investigate something, to demo, to learn new features, or to prepare an OCM exam. I’ve a few basic VirtualBox VM with single instance databases (11g and 12c, SE and EE, CDB and non-CDB, etc). I’ve the RacAttack environement with a 3 nodes RAC in 12c on OEL7. But in order to…

Read More
Franck Pachot

set “_rowsets_enabled”=false

By | Database Administration & Monitoring | No Comments

This 12c ‘wrong results’ issue is thoroughly described by Mike Dietrich ( and I’ve nothing to add. This blog post is there to be used as a reference for the comment in the following recommendation that we give to our 12c customers: alter system set “_rowsets_enabled”=false comment=’see’ scope=both; Our best practice is to document any parameter that is set as a workaround so that it can be revert back when not needed anymore.  

Read More
Franck Pachot

Dbvisit replicate allows DDL replication even when source and destination have different structure

By | Database Administration & Monitoring | No Comments

I’ve tested a little thing for a customer, and as usual I spool the result into a blog post in case it helps others. Not all replication software – at least in their current version – can manage both different target structure (which is often the main reason for logical replication) and keep up with new DDL on the source (which you can’t avoid – applications evolves). Let’s see how smart is Dbvisit replication with…

Read More