Infrastructure at your Service

All posts by Franck Pachot

Franck Pachot
Technology Leader
Senior Consultant

OCM 12cFranck 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 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 12c), Oracle ACE Director and proud member of Oraworld-team.

Next public appearance:
San Francisco, Sept. 18

Single-Tenant Oracle Database 12c:
Multitenant Features for All Editions
Nuremberg, Nov 15-18th

Multitenant new security features clarify DevOps / DBA roles

Birmingham, Dec 5-7th

12c Multitenant: Not a Revolution, Just an Evolution
Statistics Gathering Best Practice & Statistics Advisor

Franck Pachot

Oracle 12cR2: Statistics Advisor

By | Database Administration & Monitoring | No Comments

Today at #ukoug_tech16 12:30 in hall 11A I’ll talk about Statistics Gathering Best Practice & 12cR2 Statistics Advisor Rather than taking the Optimizer Statistics Advisor rules one by one I’ll show the things to take care (some people may call it best practices) when gathering statistics and they mention the Statistics Advisor Rule. If you need a reference about all rules, you can get it from V$STATS_ADVISOR_RULES  

Read More
Franck Pachot

Encryption in Oracle Public Cloud

By | Database Administration & Monitoring | 2 Comments

Oracle Transparent Data Encryption is available without option on the Oracle Public Cloud: Standard Edition as well as Enterprise Edition (EE, EE-HP EE-EP, ECS). More than that, the DBaaS enforces TDE for any user tablespace even when not specifying in the CREATE TABLESPACE. It you are not familiar with TDE key management (wallets) then you have probably encountered ORA-28374: typed master key not found in wallet. Rather than another tutorial on TDE I’ll try to…

Read More