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

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
Franck Pachot

Oracle Multitenant feature name

By | Database Administration & Monitoring | No Comments

We all know what is the multitenant option: a container database (CDB) with multiple user pluggable databases (PDB). This requires Enterprise Edition plus option. But you can use the same architecture without the option and even in Standard Edition: a CDB with only one user PDB. It is called “single-tenant” or “lone PDB”. How do you call this new 12c architecture?  

 
Read More
Franck Pachot

Script to suggest FK indexes

By | Database Administration & Monitoring | 2 Comments

In Oracle, when the referenced key is deleted (by delete on parent table, or update on the referenced columns) the child tables(s) are locked to prevent any concurrent insert that may reference the old key. This lock is a big issue on OLTP applications because it’s a TM Share lock, usually reserved for DDL only, and blocking any modification on the child table and blocking some modifications on tables that have a relationship with that…

 
Read More
Franck Pachot

Statspack Idle Events

By | Database Administration & Monitoring | No Comments

When you don’t have Enterprise Edition + Diagnostic Pack, you cannot use AWR but you can, and should, install Statspack. Statspack is still there, but unfortunately do not evolve a lot. The most important section, the ‘Top 5 Timed Events’ shows only foreground events, or is supposed to do so. When a user process waits on a background process, this section must count only the foreground wait and not the activity of the background process…

 
Read More