About

Martin Klier

usn-it.de

Godspeed, Pieter van Puymbroeck

Last Sunday, I got a miserable call, one that everybody fears: On July, 16th 2021, the Oracle Community lost one of its loveliest members and a valued contributor. We all lost an amazing human being. I lost a dear and trusted friend: Pieter van Puymbroeck, you passed away in one of your favourite spots – […]

read more

When are Oracle RUs released?

When are Oracle Release Update and Release Update Revision released? What is the schedule for RU and RUR? It’s the same as for CPU. It’s important to know that the patch cycle that produces Release Updates (RU) and Release Update Revisions (RUR) actually is the quarterly Critical Patch Update (CPU) Program for database version 12.2 […]

read more

The Three Thirds of My Career (so far)

Recently looking into a renowned Professional Social Network, I was surprised: Somehow I managed to have three IT and Oracle jobs in sequence, and now mid-2020, all of them lasted the same amount of time. Six years and a half. 2002-2008, A.T.U Auto-Teile-Unger, where I learned to fly. 2008-2014, Klug / TGW Logistics, the lesson […]

read more

Very cool interview with Maria Colgan

Community work can be so much fun. When working for the German Oracle User Group, DOAG, one of my favourite jobs is interviewing interesting people for doag.tv. In fall 2019, we recorded a fun interview with Maria Colgan, Master Product Manager for the Oracle Database. I had the chance to prepare the story: Based on […]

read more

Oracle PGA Analysis Query

Sometimes, something in an Oracle Database starts eating PGA, and there is need to find out which process, and where the memory is left, and what or who is responsible for allocating / using / holding it. For a recent issue, I wrote the SQL below. It gives back one line for each Category (SQL, […]

read more

Make Linux Disk IDs Visible for UDEV (in VMware)

VMware is a factor Times and syntaxes change, so it’s time to refresh an old blog post a bit. Especially VMware has established its place in the Oracle world, and it can be tricky to map disk IDs directly into the VM. Many sources recommend to use the SCSI addresses, but I learned to never […]

read more

ORATOP in Oracle 19c

In 19c , the useful utility “oratop” is shipped with the Oracle Home installation. It was linked to the recent libaries, and its command line syntax changed. Error This leads to errors when calling one of the old “download” binaries like oratop12c-64.bin in a 19c environment: /home/oracle/bin/oratop12c-64.bin: error while loading shared libraries: libclntshcore.so.12.1: cannot open […]

read more

DOAG Regionalgruppe Nürnberg Anfahrt / Map

DOAG Regio und Meetup Die DOAG Regionalgruppe und Meetup Nürnberg hat ein großes Thema: Die Technologien von und rund um Oracle, und ist ganz leicht zu finden. Sie ist immer am gleichen Ort, und das Treffen findet immer am dritten Donnerstag eines jeden Monats statt (außer August und November). Die konkreten Termine und Themen werden […]

read more

Oracle ACE Director

Uh, there has been no blog entry for some time, had a busy time. So now I have a good reason to blog after returning from Collaborate18 in Las Vegas, where I had the chance to present two talks about SQL Tuning and Oracle Performance on VMware. The Oracle ACE Program usually hosts a dinner […]

read more