Infrastructure at your Service

All posts by Franck Pachot

Franck Pachot
Technology Leader
Principal 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 ACEOracle ACE Franck is Oracle Certified Master (OCM 12c), Oracle ACE Director and proud member of Oraworld-team and Oak Table.

Next public appearance:
SOUG
Swiss Oracle User Group

Leman: Calculer les statistiques comme prévu par l'optimiseur
Baden: Single-Tenant 12.2
OOW17
San Francisco, Oct 1st

Multitenant: Trust It by Understanding Beyond What Is Documented
DOAG2017
Nürnberg, Nov, 21st

Multitenant internals
UKOUG TECH17
From Transportable Tablespace to Pluggable Databases
Join Methods: Nested Loop, Hash, Sort, Merge, Adaptive
C15LV
Las Vegas , Apr 25th

From Transportable Tablespaces to Pluggable Databases
12.2 Multitenant New Security Features to Clarify DevOps and DBA role separation


Franck Pachot

How to measure Oracle index fragmentation

By | Database management, Oracle | 7 Comments

At Oracle Open World 2014, or rather the Oaktable World, Chris Antognini has presented ‘Indexes: Structure, Splits and Free Space Management Internals’. It’s not something new, but it’s still something that is not always well understood: how index space is managed, block splits, fragmentation, coalesce and rebuilds. Kyle Hailey has made a video of it available here. For me, it is the occasion to share the script I use to see if an index is…

 
Read More
Franck Pachot

OOW14 Day 5 – not only Oracle OpenWorld

By | Database management, Oracle | No Comments

Oracle’s OpenWorld has ended. It was the fist time I attended this great event and it really is a “great” event: 60000 attendees from 145 countries 500 partners or customers in the exhibit hall 400 demos in the DEMOgrounds 2500 sessions This is Howard Street, a four lane avenue transformed as the Oracle Plazza for the event – in the middle of the 100000m2 of exibition halls and conference rooms: Oracle is definitly able to…

 
Read More
Franck Pachot

OOW14 Day 4 – Internals of the 12c Multitenant Architecture by Vit Spinka

By | Database management, Oracle | No Comments

This is the session I preferred at Oracle Open World. Well, I’m writing that before going to @ludodba one and I’m sure I’ll have then two preferred sessions… So Vit Spinka has presented the internals of the new multitenant architecture. It’s always good to play with some internals things. Not only for the geeky fun of it but also because it helps understand how it work and address issues later. I had investigated the metadata/object links…

 
Read More
Franck Pachot

OOW14 Day 3 – 12c Adaptive Bitmap Pruning

By | Database management, Oracle | No Comments

I’m currently following the session ‘Real-World Performance of Star and Snowflake Schemas’ with Michael Hallas, Andrew Holdsworth, John Clarke. It’s really a good presentation. the Real Performance team tries to spread messages about how to design for performance. But today I’ll not blog about what I’ve seen but about what I’ve not seen. Everybody talks about those nice 12c features that are useful in BI workloads, such as adaptive joins, adaptive parallel distribution, vector ‘in-memory’…

 
Read More
Franck Pachot

Solving customer issues at OOW14: Dbvisit Replicate can replicate tables without primary key

By | Database management, Oracle | No Comments

Usually, the logical replication of changes uses the primary key. Each row updated or deleted generate a statement to be applied on the target, which affects only one row because it accesses with the primary key. If there is no primary key, we need to have something unique and at worst it is the whole row. But sometimes old applications were designed before being implemented into relational database and have no unicity. It it a…

 
Read More
Franck Pachot

OOW14 Day 2 – Delphix #cloneattack

By | Database management, Oracle | One Comment

Do you know Delphix? The first time I heard of it was from Jonathan Lewis. And from Kyle Hailey of course. So it’s not only about agile and virtualization. It’s a real DBA stuff. So as I did yesterday with Dbvisit #repattack let’s install the demo. Here is the setup: one source virtual machine with an XE database one target virtual machine with XE installed but no database one virtual machine with Delphix And what can…

 
Read More
Franck Pachot

OOW14 Day 1 – Dbvisit #repattack

By | Database management, Oracle | No Comments

Oracle Open World is not only conferences but also practice and networking. Today at the OTN lounge have installed the following demos on my laptop: a Dbvisit replicate #repattack with a Delphix cloning environement #cloneattack I’ll detail the former below and the latter tomorrow, but if you are at San Francisco and missed it, please come tomorrow to the same kind of session at the Oak Table World! You don’t even need the OOW registration…

 
Read More
Franck Pachot

How to measure Exadata SmartScan efficiency

By | Database management, Oracle | No Comments

A thread on OTN Forum about Exadata came to the following question: “But how can I monitor if it is effectively used or not?”. This is a common question. There are 3 exclusive features coming with Exadata, and instance statistics can show their usage. Even better: two of them can even be checked on your current (non-Exadata) system. And that is good to foresee how Exadata can improve your workload. Let’s find how to measure the…

 
Read More
Franck Pachot

Thinking about downgrading from Oracle Enterprise to Standard Edition?

By | Database management, Oracle | No Comments

You are using an Oracle Enterprise Edition and thinking about downgrading to the Standard Edition? In this case, you must be sure that your applications are compatible. It’s not something easy to check. Here are a few ideas. Why? Why do you want to downgrade to the Standard Edition? For licensing costs, of course. Today, it is difficult to find a server with only a few cores. And Oracle Enterprise Edition is licenced per number…

 
Read More
Franck Pachot

Oracle: How to move OMF datafiles in 11g and 12c

By | Database management, Oracle | One Comment

With OMF datafiles, you don’t manage the datafile names. But how do you set the destination when you want to move them to another mount point? Let’s see how easy (and online) it works in 12c. And how to do it with minimal downtime in 11g. Testcase Let’s create a tablespace with two datafiles. It’s OMF and goes into /u01: SQL> alter system set db_create_file_dest=’/u01/app/oracle/oradata’ scope=memory; System altered. SQL> show parameter db_create_file_dest NAME TYPE VALUE…

 
Read More