Archive for the 'Community' Category

Speaker at DOAG 2015 Datenbank – “Oracle Core für Einsteiger: InMemory Column Store”

The DOAG 2015 Database conference is on the horizon: June 16, 2015 in Düsseldorf, Germany.

I’m proud to announce my participation as a speaker, as I was honoured with in the years before. This year, my part will be a new “Beginners” talk in German: “Oracle Core für Einsteiger: InMemory Column Store




Der Vortrag richtet sich an Einsteiger oder IT-Fachkräfte die nicht in Vollzeit als DBA arbeiten, jedoch Interesse an Datenbanktechnologie haben, bzw. für Entscheidungen hinsichtlich eingesetzter Technologien, Features und Lizenzen Anhaltspunkte suchen.

Der InMemory Column Store ist eine relativ neue Struktur der Oracle Datenbank 12c, und wird vom Hersteller massiv beworben. Der Vortrag möchte zeigen, wie diese sogenannte “In-memory Datenbank” konzipiert ist, funktioniert, und in welchen Szenarien sie sinnvoll eingesetzt werden kann.

I’m looking forward to seeing you there, for tech talk, hanging out and more tech talk. ;)
Martin Klier


DOAG Noon2Noon Event Nürnberg / MySQL vs. Oracle – Review

It was time to try something new in our DOAG Database Community. And please, please just not another frontal conference: twenty guys look forward, one looks back, like eight-oars-and-coxswain. I don’t know if DOAG invented it, but it was a success: The Noon2Noon Event.

How does it work? It’s like 24 hours of BarCamp, starting with a lunch, having a topic-of-the-day, lasting overnight, with winter barbecue, compatible for elders (thus, with Hotel and beds, no after-midnight hacking :) ). Ah, forgot to mention: One single talk being completely away from the topic, but somehow related to our work.

This first time, topic was “MySQL versus Oracle Database”. Johannes Ahrends and Oli Sennhauser as “headliners” ignited discussions about features, technologies and strategies known from Oracle, and how they are (or aren’t) in MySQL. And vice versa, but less. Participants came from all over Germany, plus Denmark and Switzerland. End users, consultants, technocrats, “boys” who go ahead and fail, and “girls” who test and succeed…

I greatly enjoyed the open format – listening, talking, drawing, discussing, swaggering, ignoring, pushing, pulling – the full repertoire. :)

From the technological aspect, it was great to learn something about MySQL – how consistent reads, clustering, and lots of other stuff works, that we never ever thought that it could be done different from the way the Oracle Database works. And that MyISAM isn’t the norm, but just another PITA. :) Go for InnoDB. What is MariaDB? And what the fork is Percona Server?


Oli swiss-talks about MySQL.

Read more…

Martin Klier in Interview: Oracle Standard Edition

A while ago, interviewed me about Oracle’s Standard Edition and database system migrations. The material was published just recently, so I’d like to share it. Enjoy, and if there are questions, just let me know!


I have to add a corrigenda: SE RAC is not – at least not at the moment – limited to a number of nodes. It’s currently limited to CPU sockets, to be exact, 4 of them. So a four-node SE RAC is possible, if I did not completely misunderstand the licencing policies.

Disclaimer: Licensing and pricing here are my OPINIONS, and not a reliable source to make decisions or confront Oracle with. :) If you need some tailored licensing information, feel free to email for advice.


DOAG 2014 Presentation and Whitepaper online: Database I/O


my #DOAG2014 presentation and whitepaper are online now!

“Oracle Core für Einsteiger: Datenbank I/O”





Thank you all for attending!

Martin Klier

It’s #DOAG2014 time!

Hello World!

It’s time for all Oracle folks to congregate in Nuremberg for DOAG Konferenz 2014!


I’d love to meet and greet you there – maybe you are also interested in my talk for Database Rookies: “Oracle Core für Einsteiger: Database I/O”:

Hope to have a great week with you!
Martin Klier


Visited Germany’s first Spatial Database, Size 26 kiloStones

Last week, I had the chance to visit Bavaria’s (and so also Germany’s) oldest Spatial Database. It’s buried deep below Munich, and contains all the geo information about Bavaria in scale 1:5000 and some in 1:2500. It was introduced in 1808 and was in use until 1950. That’s also the current state of the data.

Each of the 26,000 official maps is painted in oil and mirror-invertedly on polished lime sand brick. Each “page” is 1m x 1m (3.2ft x 3.2ft) in size, 4-6cm (2-3in) thick and the weight of each stone “disk” is approximately 70kg (154lbs). That makes it 26 Kilostones in size, with a dump size of 1,820,000 kg or 3,968,000 lbs.

Read more…

New German Linux Forum (

In the last weeks, some folks were busy to build a new German Linux Forum “”, since the predecessor was systematically ruined by the commercial owners.

Especially Jean (wdp) and Hendrik (Nilpferd) invested much time and money into building the new environment. So the new forum is completely free of ads and commercials, and the content is QA’ed by a team of experienced Linux admins as moderators.

Please hang out there, and help us to (re)build a cool community.

Martin Klier (Usn)

Performance is rarely an accident (Deutsch)

Some time ago, I saw a great presentation of Cary Millsap: „Thinking clearly about performance”. It was obviously relevant for our internal developers, so he unhesistantly granted me permission to reproduce some of his ideas for us. Cary, thank you very much!

Here you can see, what I made out of the topic, mostly for visualization purposes.



Martin Klier: Performance is Rarely an Accident (pdf)

As I said, the intention was to show development teams, how beneficial it would be to think about performance at all, and that you’d need code instrumentation (=runtime meta information about application behavior) to get better.

I hope you enjoy the slide deck.
Martin Klier

Edit: Exchanged the basic version for Second Edition in Wiesau and Munich

Oracle Core für Einsteiger: Datenbank I/O at DOAG 2014

Proud to announce, that DOAG accepted my tech talk “Oracle Core für Einsteiger: Datenbank I/O” for DOAG Conference 2014 in Nuremberg. It’s my next contribution to DOAGs thread aiming at beginners and part-time database people.


The talk will be in German, here comes its abstract:

Oracle Core für Einsteiger: Datenbank I/O
Wir kennen verschiedene I/O-Typen, die die Datenbank benutzt um ihre Aufgaben zu erfüllen. Der Vortrag zeigt anschaulich wie sie sich unterscheiden, und erklärt, welche Vorteile die einzelnen Methoden bieten. Behandelt werden Zugriffe auf Tablespaces, Online/Archived Redo Logs und verschiedene Dateitypen, die mit der Instanz in Verbindung stehen. Eingeschlossen ist eine kurze Wiederholung der jeweiligen Funktion im RDBMS; ebenfalls enthalten ist ein “Crashkurs” zum Automatic Storage Management “ASM”.

Das Ziel des Vortrags ist, Einsteigern das Verständnis von Massenspeicheroperationen näher zu bringen und Hintergrundwissen für ein kompetentes Storage-Sizing zu vermitteln.

I’m also very happy to announce, that my business partner Benedikt Nahlovsky‘s presentation “Kostenlos aber effektiv: Performanceanalyse mit Statspack und SQL*” also was accepted. It’s all about doing professional performance analysis with STATSPACK and SQL* tools.

So Performing Databases is present with two sessions, we really appreciate it!

Looking forward to seeing you all at CCN East, Nuremberg Trade Fair, 18th-20th November 2014!

Stay safe
Martin Klier

Status Blog


long time no see? Many things have changed here, so my time for blogging was limited.

  • Together with Benedikt Nahlovsky, I founded “Performing Databases“, a company to offer top-class database know-how combined with flexibility and agility. Doing all the formal requirements, and pushing business into life absorbed much of my free brain space.
    performing databases logo gif
  • In June, my daughter and second child, Rebecca, was born. Private life will never be the same again, but she’s a new bright star in my favorite constellation. Like it!
  • My latest employer, Klug GmbH integrierte Systeme became bankrupt and was purchased by TGW Logistics Group. That made lots of uncertainty and I had to change many of my priorities. Now a new era has begun, and we all are busy integrating a mid-size family shop into a big family shop (1700+300=2000 employees). In the end, we hope to become “TGW Software Services GmbH

But now I’m mounted again, and hope to fulfill my old promise of one blog per month again (if quality assurance allows it).

Wow, just out of curiosity I checked my webstat’s output: 2500 “visits” per day on average, that’s overwhelming! A good reason to say “Thanks for reading here!” today.


CU soon
Martin Klier

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.