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) and an Oracle ACE.

Next public appearance:
SITB
Geneva (CH), April 26-27th

Oracle Cloud Services at SITB, with dbi services and Oracle Switzerland
SOUG
Düsseldorf (D), May 10-11th

Multitenant internals, Optimizer statistic gathering
SOUG
Geneva (CH), May 19th

SOUG Training Day
Dbvisit
Lausanne(CH), June 2nd

dbi services replication event


12cR2 Multitenant


Franck Pachot

Testing Oracle on exoscale.ch

By | Database Administration & Monitoring | One Comment

My last post came from a discussion at SITB with exoscale. They are doing Cloud hosting with datacenters in Switzerland. In Switzerland a lot of companies cannot host their data outside of the country, which is a no-go for the big Cloud providers. After the discussion they gave me a coupon for a trial IaaS instance. And if you follow my blog you should know that when I have a trial access, there are good…

 
Read More
Franck Pachot

Can you become a PaaS provider for an Oracle Database service?

By | Database Administration & Monitoring | No Comments

This post is not about technical limitations: Oracle Database is supported in most hypervisors (certified or not) so anybody can provide a DBaaS through a virtual machine as long as it run a supported OS, has enough CPU, memory, and storage, and open the required ports to access to the database (ssh and listener). But you cannot do what you want when you install a software, and you must agree with its licence terms. Who…

 
Read More
Franck Pachot

A short glance at Attunity replicate

By | Database Administration & Monitoring | No Comments

If you follow my blog, you should know that I really like Dbvisit replicate because it’s simple, robust, has good features and excellent support. But that’s not a reason to ignore other alternatives (and this is the reason of http://www.dbi-services.com/news-en/replication-event-2/). When you have heterogeneous sources (not only Oracle) there is Oracle Golden Gate with very powerful possibilities, but maybe not an easy learning curve because of lack of simple GUI and setup wizard. You may…

 
Read More
Franck Pachot

Transparently externalize BLOB to BFILE

By | Database Administration & Monitoring | No Comments

Storing documents within the database is the easiest, especially because you get them consistent with the metadata stored in the database. If you store them externally, then you need to manage their backup, their synchronization to standby site, the consistency in case of flashback or PITR, etc. However, documents grow (in number and in size thanks to better resolution of scan) and you don’t want a database where half of the size are documents in…

 
Read More
Franck Pachot

Single-Tenant vs. non-CDB: no reason to refuse it

By | Database Administration & Monitoring | No Comments

When non-CDB has been declared deprecated, I was a bit upset because multitenant with a lone PDB just looks like an overhead of 3 containers instead of one. But with experience I changed my mind. First because the multitenant architecture brings some features that are available even without the option. And second, because this overhead is not a big problem.Let’s put numbers on that last point.  

 
Read More
Franck Pachot

Créer une base Oracle sur le Cloud en quelques clicks

By | Database Administration & Monitoring | No Comments

Il n’a jamais été aussi facile de créer une base Oracle. Et ceci grâce au Database as a Service (DBaaS). C’est l’occasion de tester le cloud: Oracle Cloud Service offre une version d’essai de un mois. Si vous êtes proches de Genève, passez nous voir lors du SITB les 26-27 avril: http://www.dbi-services.com/fr/events-fr/swiss-it-business-sitb-du-26-au-27-avril-2016/ Mais j’ai aussi fait une video pour montrer comment créer sa base sur le Cloud de A à Z.  

 
Read More
Franck Pachot

Cloning a PDB to the Oracle Cloud Service

By | Database Administration & Monitoring | No Comments

When you create a DBaaS on the Oracle Cloud Service you have only one way to access to your database: ssh with the public rsa key you provide. Then you can open some ports to access the VM. However, from the VM you can’t access your own network. You need it to move data between from on-premises or private cloud to the public cloud. Or to setup a Data Guard between them. Let’s see how…

 
Read More