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.

POUG
Cracow (PL), Sept. 1st

12cR2 Statistics Advisor: Do you gather statistics in the way the optimizer expects them?
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


Franck Pachot

VirtualBox 5.2 exports the VM to the Oracle Cloud

By | Database Administration & Monitoring | No Comments

The new release of Oracle VM VirtualBox (aka VirtualBox) is there with a new functionality to export a VM to the Oracle Cloud Compute (aka Oracle Cloud Infrastructure). That can be interesting to prepare a VM on my laptop and move it to the Cloud to get it accessible from everywhere. Here’s my first try. In my opinion, it’s idea but probably need further evolution.  

 
Read More
Franck Pachot

Oracle Database Multilingual Engine (MLE)

By | Oracle | No Comments

My ODC appreciation blog post was about Javascript in the database running in the beta of the Oracle Database Multilingual Engine (MLE). Here I’ll detail my first test which is a comparison, in performance, between a package written in Javascript, running in the MLE, and one written and running in PL/SQL.  

 
Read More
Franck Pachot

ODA X7

By | Oracle | 12 Comments

ODA X6-2 So, the ODA X6 End of Life seems to be planned for October, and be careful, as far as I know, this concerns also the storage expansion. The main feedback from the X6-2 series were: not enough cores when consolidating multiple databases in M, L and HA not enough storage on HA when compared with X5-2 Standard Edition on HA would be great for cheaper RAC The position of the ‘Large’ version of…

 
Read More
Franck Pachot

When deterministic function is not

By | Oracle | No Comments

When you declare a function-based index, the function is deterministic, which means that calling it with same arguments will always return the same result. This is required because the indexed values, which are the result of the function, are stored in the index. But what happens if you declare a function deterministic when it is not?  

 
Read More
Franck Pachot

Am I a DBA 3.0 or just an SQL*DBA?

By | Oracle | 2 Comments

There are currently a lot of new buzz words and re-namings which suggest that our DBA role is changing, most of them escorted with a #cloud hashtag. Oracle Technology Network is now called Oracle Developer Community. Larry Ellison announced the database that does not need to be operated by humans. And people talking about the death of DBA, about the future of DBA, about DBA 3.0,… Those are all generalizations and universal statements, and I…

 
Read More
Franck Pachot

Wrong result with multitenant, dba_contraints and current_schema

By | Oracle | No Comments

Multitenant architecture is not such a big change and this is why I recommend it when you start a project in 12c or if you upgrade to 12.2 – of course after thoroughly testing your application. However, there is a point where you may encounter problems on dictionary queries, because it is really a big change internally. The dictionary separation has several side effects. You should test carefully the queries you do on the dictionary…

 
Read More