Archive for the 'Community' Category

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 for all members attending one of the big conferences. This time, there was a nice surprise included for myself – Oracle decided to promote my ACE status to Oracle ACE Director.

ACED_Logo_color

I feel honored, and say Thank You! Nevertheless, I will continue to think and talk critically about Oracle whenever it seems appropriate. In my opinion, Oracle is a very good technology company, but much with the term “service” in it, still can use a good share of improvement.

Thank you all for reading my blogs and attending to my talks. You are the guys who make this being fun for me!
Martin



My COLLABORATE16 look-at’s – an aftermath

From April 10th to April 14th 2016 many Oracle professionals congregated in Las Vegas. The three big U.S. user groups, the IOUG, the OAUG and the Quest User Group once again formed one of the best Oracle Conferences in the world: COLLABORATE16. I was honored to be there as a speaker, and glad to perform two lectures in front of packed rooms (downloads here). Thank you all who made it possible and who attended!

But this post is about what I took home from COLLABORATE16. I never take the time to write down everything. But wherever I go, I take notes what to look at when I am back. And as often, I’d like to share my very personal best-of list of souvenirs from Las Vegas. It’s ordered by time – first session first, and all of them are top notch state-of-the-tech speakers, no quality comments necessary. It’s always a privilege to meet you, thank you all for sharing your experience!

Linux/Unix tools for the DBA

by Tim Gorman

  • sar -w context switching
  • sar -W (virt mem swapping)
  • sar -B (virt mem paging)
  • sar %steal = time stolen by hypervisor
  • sar = sadc (collector) + sadf (formatter)
  • mpstat (per processor stats)
  • mpstat column icsw (involuntary context switches)
  • ipcs interprocess comm data structures or resources
    • shared mem
    • semaphores
    • message queues
  • Oracle sysresv = IPC resources for $ORACLE_SID
  • pmap = process mem mapping display
  • pmap -x for all oracle processes / max of shared plus sum of the privat comp = mem oracle uses
  • jstat = Java VM mem usage displays
  • jstat Stop The World STW means cleaning up old objects due to dependencies / inheritance chains (vs. young ones w/o stopping)
  • jstat -gc (FGC column -> STW events since process start)
  • dtrace – very powerful performance analysis tool
  • adb – obtain stack trace from core dump
  • Oracle alter system dump
  • Oracle sosreport
  • Oracle OSwatcher

Read more…



Looking forward to speaking at COLLABORATE16 IOUG Forum

Yes, I did it again, submitted and got two papers accepted – speaking at COLLABORATE16 in Las Vegas (#C16LV) is always a highlight of the year!

Collaborate16_Horizontal_Logo

This time, it will be:

And, what I’m very thrilled to do again – helping with the Sunday RAC Attack Workshop as a ninja. We own the night! :)

Please see details of the talks here, and follow my #C16LV posts on twitter!

Big Thanks to IOUG, and see you in Vegas!
Martin Klier



Featured by Oracle Magazine

The Oracle Magazine featured me in its January / February 2016 issue. I really feel honoured and would like to say thank you for the opportunity!

Martin Klier Oracle Magazine Jan Feb 2016

For details, please see the Performing Databases Blog post about the publication.



DOAG noon2noon RAC & Dataguard – Quick Report

There’s always something to learn – for example about Oracle RAC (Real Application Clusters) and Dataguard. And the old-school frontal teaching concept is boring, and more important, ineffective after a few hours of passive listening. So the German Oracle Users Group DOAG organized a “noon2noon” event: “Oracle RAC and Dataguard” this week in Würzburg (January 2 1st-22nd 2016). It was the second noon2noon, after introducing the concept last year with Oracle vs. MySQL. I enjoyed it much last time, so I easily agreed to volunteer as a RAC Attack “Ninja” and tech guy on site for the workshops in general this year.

The response was close to overwhelming – we calculated 25 participants, but ended up with 39, and a PACKED room. Somebody called it a chicken cage, but the atmosphere was great. Thanks to the air condition. :)

DOAG noon2noon RACattack

Everybody is highly motivated, despite the packed room at noon2noon :)

But what’s that noon2noon thing?

Read more…



What is a “RAC Battle”?

RAC Battle [ræk ˈbæt̬l̩]

What is a “RAC Battle”? It is a format of presenting technology – two experts, battling against each other on pros and cons of Oracle Real Application Cluster. Björn Rost (Oracle ACE Director) and Martin Klier (Oracle ACE)

Björn Rost -  What is a "RAC Battle"?  Martin Klier - What is a "RAC Battle"?

will fight

Wednesday November 18th, 2015
11 am
Nürnberg CCN (DOAG Konferenz 2015)
Room St. Petersburg

Who will be pro? Who will be con? We don’t know, we will decide by lot in front of the audience.

Be there, to see a technology event at its best in rounds, with no strings attached. Are you afraid of violence? Stay calm, Johannes Ahrends (Oracle ACE) will be the referee to avoid bloodshed.

Johannes Ahrends - What is a "RAC Battle"?

Here’s the official RAC Battle link from DOAG.



Oracle 12c in practice – customer report in Cologne #12cjetzt

From Beta to Production – Oracle 12c at TGW
In October, I’ll speak at the Oracle #12jetzt (#12cnow) symposium in Köln (Cologne) about the introduction of 12c as standard palttform at our ISV customer TGW Software Services.

12c jetzt Symposium Header

I had the privilege to continuously working on the 12c product evaluation and introduction from availability of 12c beta2 until today. My company, Performing Databases, played the key role for creating and developing the guidelines of operation, configuration and licensing. My example will be the “new” development environment, to show the first steps of the project. The highlight of the talk will be the report about our migration from 9i to 12c at S.Spitz GmbH, the biggest food vendor in Austria.

When?
October 15th
approx. 11am

Where?
Hyatt Regency Köln
Kennedy-Ufer 2A
50679 Köln
Germany

Please see the agenda here.

Link to the presentation here.



DOAG Database Conference 2015 begins #DOAGDB15

It’s time! June 16th, the DOAG Database Conference takes place in Düsseldorf, Van Der Valk Airport Hotel. Twenty-two specialized talks about Oracle Database, Replication, Tools and Security promise a great techie-day. See the schedule of lectures here.

2015-DB-Banner-468x180

I’m looking forward to seeing you there, having great corner talks about Oracle, life and lemons, tweeting with hashtag #DOAGDB15 and enjoying this great environment the hotel provides.

I’m also glad and honoured to be on the list of speakers: “Oracle Core for Beginners: In-Memory Column Store” at 11am.

Take care and see you tomorrow!
Martin



DOAG BI Conference: Oracle Core (for Beginners): In-Memory Column Store

Oracle-inmemory-architecture

On Thursday, April 23rd I’m speaking at DOAG BI 2015, the leading Oracle Business Intelligence Conference in Germany. (#DOAGBI15)

My contribution is: “Oracle Core für Einsteiger: In-Memory Columns Store”. The lecture will show, how the Oracle Database In-Memory option works “under the hood”, and how it is used to the best effect.

Please find the presentation here for download.

Oracle-Inmemory-OLTP-and-OLAP

Looking forward to seeing you there, or discussing the presentation in the comments.

Thanks
Martin



Chemnitzer Linux Tage 2015

Last weekend, I had the chance to attend the Linux Days Chemnitz. It’s an annual meeting of the German Linux family with roundabout 2,500 attendees and a FANTASTIC atmosphere. It was two days of hearing tech talks, enjoying rich nerd content and talkin’ shop.

IMG_20150321_151204

Great atmosphere in the Great Hall

freie-kultur

Great entrance gift: “Free Culture” by Lawrence Lessig. Thank you very much!

Read more…




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.