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:
Oracle Midlands
Birmingham, January 26th

Oracle locks, Reading AWR
SOUG
Baden (CH), March 2nd

SQL Plan Directives
SOUG
Düsseldorf (D), May 10-11th

Multitenant internals, Optimizer statistic gathering


Franck Pachot

awrrpt and spreport in multitenant

By | Database Administration & Monitoring | No Comments

Yesterday I was giving my ‘Interpreting AWR Reports’ Prezi at Oracle Midlands. There is a point where I explain that I always check the ‘Captured SQL account for …% of Total DB Time (s)’ in order to know whether I’ll get all details in the report or not. There are two main reasons why the most important statements are not captured: report covering a time window too short, or lot of non shareable SQL statements…

 
Read More
Franck Pachot

log file sync / user commits

By | Database Administration & Monitoring | 3 Comments

When presenting ‘Interpreting AWR Reports – Straight to the Goal’ at UKOUG TECH15 I had a very good question about the Statspack report I read which had log file sync much smaller than user commits. I realized that this needs a longer explanation, and that my slide is very misleading because I divided log file sync wait time per user commits, which probably make no sense here.  

 
Read More
Franck Pachot

PDB snapshot copy for continuous integration testing

By | Database Administration & Monitoring | No Comments

How do you manage your continuous integration tests on the database? You need to restart at the same state for probably a hundred of tests. Recreating the schema and test data takes too long. Oracle is not optimized for DDL. Restoring the database takes too long. Even if you data is small, there is those SYSTEM, SYSAUX tablespaces. Flashback database can help, but it still takes time because it requires to restart the instance. Let’s…

 
Read More