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:
OOW16
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

Exadata X-5 Bare Metal vs. OVM performance

By | Database Administration & Monitoring | No Comments

The Exadata X5 can be installed Bare Metal or Virtualized. The latter one, Oracle VM allows to create multiple clusters on one machine, is more complex for installation and for storage capacity planning. But it allows a small flexibility on options licencing. Those are the real challenges behind the choice. However, when we talk about virtualization, most of questions are about the overhead. Last week, we did some tests on same machine with different configuration,…

 
Read More
Franck Pachot

Large Pages and MEMORY_TARGET on Windows

By | Database Administration & Monitoring | No Comments

In a previous post about enabling large page on Windows Server, I explained that it’s possible to use large pages with Automatic Memory Management (AMM, where sizing if SGA and PGA is automatic with MEMORY_TARGET setting) but possible does not mean that it is recommended. We feel that it’s not a good idea, but are there reasons for it or it’s just our linux backgroud that brings this opinion?  

 
Read More
Franck Pachot

ODA X-6 log file sync with NVMe flash

By | Database Administration & Monitoring | 3 Comments

The new ODA X-6 has been announced last month with two smaller configurations and smaller prices: 2S and 2M. Small, but high performance configuration: all SSD, and I/O transfer optimized for Flash with PCIe bus and NVMe protocol. Let’s see how it keeps up with an high OLTP workload. Thanks to Arrow Oracle Authorized Solution Center to let us evaluate performance on their ODA.  

 
Read More