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


Franck Pachot

JAN17 Proactive Bundle Patch + Adaptive Statistics control

By | Database Administration & Monitoring | 2 Comments

If you have to create a new database now (I’m writing this in March 2017) for a migration of OLTP database with minimal risks of regression, I would recommend: The latest patchset of Oracle Database 12cR1 The latest Proactive Bundle Patch The two patches to get full control over Adaptive statistics This post gives more detail about it and which patches to apply. It would be nice to have those patches merged into each bundle…

 
Read More
Franck Pachot

Google Cloud Platform instances and Oracle Database

By | Cloud, Database Administration & Monitoring | No Comments

When it comes to choose a cloud instance to run Oracle Database, you want to be able to run your workload on the minimum CPU cores. This is why in a previous post I measured how many logical reads per seconds can be achieved with a SLOB workload, on AWS which is often the first considered, and will probably do it on Azure in the future. I did the same on the Oracle Cloud which…

 
Read More
Franck Pachot

12cR2: TNS_ADMIN in env.ora

By | Database Administration & Monitoring | No Comments

The network files (sqlnet.ora, tnsnames.ora, lsnrctl.ora) are read by default from ORACLE_HOME/network/admin but you may have several Oracle installations, and want only one place for those files. Then you can use TNS_ADMIN environment variable. But are you sure that it is always set when starting the database? the listener? the client? They must be consistent (see https://blog.dbi-services.com/oracle-12cr2-plsql-new-feature-tnsping-from-the-database/). Then what we do for the cases where TNS_ADMIN is not set: define symbolic links from the ORACLE_HOME…

 
Read More
Franck Pachot

Oracle 12cR2, RAC, Cloud, ACFS, PDB thin clones and asmadmin

By | Cloud, Database Administration & Monitoring | No Comments

In the Oracle Public Cloud, fast provisioning gets all its meaning when creating a RAC database service: in one hour you can get an operational highly available multitenant database. You can even create it in Data Guard for Disaster Recovery. Now, Oracle is pushing ACFS to store the datafiles rather than direct ASM. Especially in multitenant because a great feature is thin cloning: CREATE PLUGGABLE DATABASE AS SNAPSHOT COPY. However, I encountered an error when…

 
Read More