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
Swiss BI-DAY
Geneva, October 6th
DOAG conference
Nuremberg, November 19th
UKOUG TECH15
Birmingham, December 6-7-8th
Oracle Midlands
Birmingham, January 26th


Franck Pachot

Oracle Cloud Services DBaaS and dbi services best practices

By | Database Administration & Monitoring | No Comments

When we give our trainings (dbi services workshops) we signal our best practices with this logo. It’s our know-how, acquired through experience, consulting, service desk, exchange at events, beta testing, etc. that we share with our customers. Let’s have a look at a few points that we recommend to change if you provision a database with DBaaS on the Cloud.  

 
Read More
Franck Pachot

Oracle CDC for Datawarehouse, Dbvisit replicate as an alternative

By | Database management | No Comments

You don’t want to reload the datawarehouse database every night. And you may want to have it refreshed more often, in real-time during the day. There is another reason to capture all changes from the operational database: you want the history of all updates and not only the current value. This is why you use change Data Capture (and Streams propagation is based on that), a feature available in Enterprise Edition with no need of…

 
Read More
Franck Pachot

Configure the Resource Manager with SQL Developer

By | Database Administration & Monitoring | No Comments

Yes, the topics for the OCM 12c upgrade are online and I’m already looking at the topics. I’m talking about the ‘Configure the Resource Manager’ one here. Configuring Resource Manager in commandline is not easy. At the OCM exam you can do things faster when you have a GUI. Of course, you need to know where to find the command line API in case no GUI is available. In 11g, even if no Cloud Control…

 
Read More
Franck Pachot

Materialized View explain_rewrite

By | Development & Performance | No Comments

When I passed the OCM 11g exam, I had to prepare the ‘Manage Materialized Views to improve rewrite’ topic. Now that I’m preparing the 12c upgrade I checked quickly what I’ve prepared… and it doesn’t work. This post is about query rewrite, a bug in 12c, how to understand why it doesn’t rewrite, and how rewrite is accepted when constraints are not enforced and when materialized view is stale.  

 
Read More
Franck Pachot

DataGuard broker properties – Part I: imported parameters

By | Database Administration & Monitoring | No Comments

When you are using the DataGuard Broker, you should always use the broker (with DGMGRL or OEM) to change the parameters that are managed, rather than changing them with ALTER SYSTEM. But do you know which parameters are concerned? I’ve divided the parameters in two parts. All are set by the broker, but only some of them are read when you add a new database to the configuration.  

 
Read More
Franck Pachot

RESULT_CACHE hint expiration options

By | Database management | No Comments

The result cache is very nice when base tables are static: get the result without any buffer get, without any join or sorts. But as soon as any DML occurs on one of the tables the result is based on, then result cache is invalidated. And cache misses are quite expensive. You can think of it as a materialized view in memory. But with materialized views, you can accept to see stale results in order…

 
Read More