Infrastructure at your Service

All posts by Jérôme Witt

Jérôme Witt
Senior Consultant

Jérome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup & recovery, and tuning technologies. His expertise also includes the open source field (Linux/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). Jérôme Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, Jérôme Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. Jérôme Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking & Financial Services, Energy, Automotive etc.
Jérôme Witt

DOAG 2018 – Fazit: it’s not only about Oracle anymore

By | Database Administration & Monitoring | No Comments

Amazing conference, amazing people and awesome party like every year  and of course great networking like every year This year, I was quite impressed about the number of different technologies. Speeches were not only centered around the big red O. As already summarized, by my colleague Alain yesterday: DOAG 2018 – Not only database – Docker and Kubernetes rule the world Open Source RDBMS, containers and microservices are arising much more quickly than cloud computing…

Read More
Jérôme Witt

Install Oracle instant client and perl DBD::Oracle @ Mac OS X Yosemite

By | Database Administration & Monitoring | No Comments

Recently, I tried to install and connect to Oracle databases directly from my new Mac Book using perl  (Yes, perl is still one of the most friendly programming language for DBAs). What first seemed to be easy was in reality quite difficult and long. Alone, the huge quantity of  hits on the WorldWideWeb was impressive. However none of the hits were providing the entire solution. Follows, all the steps to prepare and install the Oracle…

Read More
Jérôme Witt

Oracle Database 12c: The secret of moving datafiles online

By | Database management | No Comments

Some time ago, my colleague Michael Schwalm wrote about a new Oracle Database 12c feature for moving database files online. In this post, we will not describe the syntax of the command, but focus on Oracle internals. To do that, I have written a tiny test protocol composed of two parts: Session 1: starts a batch (schema BATCH) processing which runs for hours Session 2: that’s us, we are connected as SYS (of course we…

Read More
Jérôme Witt

Data Pump in Oracle Database 12c: die wichtigsten Neuigkeiten

By | Database management | No Comments

Letztes Jahr hat Oracle CEO Larry Ellison während der Oracle OpenWorld in San Francisco ein neues Datenbank Release angekündigt, das nun endlich zur Verfügung steht. In diesem Blogbeitrag möchte ich einige der wichtigsten Data Pump-Neuigkeiten vorstellen. Eine komplette Übersicht der Features finden Sie in Oracles Dokument „Oracle Database Utilities“. Fangen wir an mit dem riesen Hype von Oracle 12c! Oracle 12c Pluggable Databases (PDB): wie soll ich mit diesem Feature umgehen? In Oracle Database 12c…

Read More
Jérôme Witt

Frankfurter Datenbanktage: Bei dbi services hat Ostern schon begonnen…

By | Database management | No Comments

Ganz klar: Unser dbi services Goldhase war das inoffizielle Maskottchen der Frankfurter Datenbanktage! Der Nachfrage nach zu urteilen war es sowohl ein Augen- als auch ein Gaumenschmaus … wir haben auch schon eines “geschlachtet” und brüderlich geteilt. Wir waren in 3 Sessions aktiv und hatten die Freude, viele interessierte Teilnehmer an unserem Stand zu begrüssen! Stéphane Haby hat in seiner Session ein neues SQL Server Monitoring-Tool für Microsoft DBAs vorgestellt: “SQL Server Management Datawarehouse”. Die…

Read More
Jérôme Witt

Wie kann ich Indexes und Daten mittels Data Pump trennen?

By | Database management | No Comments

Diese Frage habe ich in den letzten Jahren öfters gehört. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export/Import Tools. Angeblich war es früher mit dem Import-Parameter-Tool „INDEXFILE“ viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch leichter! Dies möchte ich anhand eines ganz normalen Datapump-Export–Files verdeutlichen. In folgendem Beispiel handelt es sich um einen einfachen Schema-Export, der wie folgt erzeugt wurde: oracle@vmoel58:/u00/app/oracle/admin/DB112/etc/ [DB112] cat expdp_SalesApp.par SCHEMAS=sh DIRECTORY=data_pump_dir DUMPFILE=expdp_SH_2013-02-17.dmp LOGFILE=expdp_SH_2013-02-17.log PARALLEL=4 oracle@vmoel58:/u00/app/oracle/admin/DB112/etc/…

Read More
Jérôme Witt

OOW Day 4: Dive in, Rock out – Oracle Party & Tomy Kyte’s 12 things on Oracle 12c

By | Technology Survey | No Comments

Well, this last day really was funny! We met some old friends (they will recognize themselves) and also Oracle guru Jonathan Lewis. We must confess Larry Ellison really has good friends. His America’s cup boat is really amazing (see picture below) as was last night’s party. Today, we were really tired and the speakers too. Most of today’s content was a review of what Pierre and I reported during the week. It fits exactly Tom…

Read More
Jérôme Witt

OOW Day 3: Oracle database 12c features review

By | Technology Survey | No Comments

Today, we had the opportunity to follow several sessions concerning the upcoming Oracle Database 12c release. Like Apple, Oracle keeps the secret over Oracle Database 12c, but tends to deviate from the Silicon Valley secret culture. However, we can relay all that we heard to you Over the past 10 years, Oracle has worked on plenty of state of the art topics like compression, in-memory operations, scalability, and this is still true for Oracle Database…

Read More
Jérôme Witt

OOW Day 2: Oracle Linux developements & news

By | Technology Survey | No Comments

This second day at the Oracle Open World is hotter than the previous one! Today, we focused on Oracle Linux. Oracle Linux roadmap, the Unbreakable Enterprise Kernel (UEK) release 3 is coming in summer 2013. Oracle’s strategy consists of developing the new enterprise-class kernel on state of the art hardware, which guarantees to customer to get the most of their hardware (Like Suse for SLES 11). The Oracle Linux development team is working on many…

Read More
Jérôme Witt

OOW Day 1: Oracle 12c – Data Guard new features

By | Technology Survey | One Comment

What a sunny day at the Oracle OpenWorld in San Francisco, temperatures over 30 degrees Celsius … don’t be jealous ;=) What should I start speaking about? Oracle Entreprise Manager Cloud Control 12c? Oracle VM or Oracle Database 12c? Well, let me summarize some of the Oracle Database 12c Data Guard new features from Joseph Meeks’s session “Oracle Data Guard Zero-Data-Loss Protection at Any Distance”. Oracle Data Guard is a high available, data protection, disaster…

Read More