Archive for the 'Community' Category

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.

2014_06_30-DOAG_2014_Konferenz-Banner_Klettern-468x180

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

Hello,

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
    TGW_Logo_URL

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.

visits-usn-it

CU soon
Martin Klier



Slides for COLLABORATE 2014 IOUG forum talk #C14LV

Hi folks,

here’s my slides for “YOUR machine and MY databases – a performing relationship?!” at Collaborate 2014 Las Vegas. Any feedback is greatly appreciated!

collaborate14-logo

2014_141_Klier_odp_v1

2014_141_Klier_v1_doc

Some pictures to come soon!

You may want to follow the #C14LV hashtag to see what’s going on. :)

 



SQL Server Analysis Look At’s

End of March, I had a chance to dig a bit deeper into MS SQL Server analysis. The german chapter of PASS (http://www.sqlpass.org) organized one of their “Essentials”, a condensed training day with a specific topic. This one was named “SQL Server Analysis” and was held by Andreas Wolter (MCSM) in Nuremberg. Here comes my “look-at’s” – the usual public scratchpad of what I want to review as follow-up of an event.

  • There are two SQL Server related IO benchmark tools (like ORION that I’m familiar with, by Oracle): SQLIOSIM and SQLIO.
  • Event Tracing for Windos (ETW) is supported for MSSQL since Version 2008, use Windows Performance Recorder for that.
  • Try “perfmon /report”
  • Windows Server 2008R2 and above supports “mountpoints” in addition to drive letters. Nice, finally aligning POSIX?
  • Profiler can load PERFMON data and correlate them (old style / deprecated)
  • SQL Server reports: Disk Usage Report shows, for example, resizing operations. So check your file sizing policy this way.
  • Extended Events (XEvents) take 2µs, Profiler events take 4ms (=> Profiler is factor 2000 slower; source: SQL Server & BI blog)
  • SQL Server index growth is different from Oracle: They have no 90/10 split on the growth end of the leaf list, SQL Server adds empty leaf nodes
  •  Extended Events editor to be found under “Administration” in SQL Server Managament Studio (SSMS)
  • Setting up a Performance Data Warehouse brings historical performance data. Do the following:
    1. Create a Data Collection Set
    2. Create a Performance DWH
    3. Create a data Collector
  • Look at tools:
    1. Event Notifications
    2. SQL Diag (Log/Trace collector)
    3. RML Utilities

So for sure this is not everything – the more you dig into a RDBMS, the more surprises and fields of knowledge-to-learn you will find. Let’s go ahead, next time.

Good luck
Martin Klier

Edit: Version supporting ETW



DOAG Würzburg: “Resolving child cursor issues resulting in mutex waits”

I feel honored that DOAG asked me once more for being a speaker at an event – this time it’s DOAG Regionalgruppe Würzburg. I will give my (updated) C12LV and Oracle Open World 2012 talk “Resolving child cursor issues resulting in mutex waits” there, supported by my new business Performing Databases GmbH.

My abstract:
In special situations, the Oracle Database generates too many child cursors for particular SQL-IDs. This results in high CPU load on the DB server, coming from heavy mutex access. This is visible as mutex wait events. The lecture will show how this situation arises, how the DBA can try to quick-fix it and how long-term solutions can be found. Additionally, we will have a closer look on the Oracle internal situation: Why does the DB use mutexes here, and how?

When?
Thursday (Donnerstag) 27.03.2014
5 p.m. (17 Uhr)

Where?
Würzburger Versicherungs AG
Bahnhofstraße 11
97070 Würzburg
(Map)

The presentation will be available after the talk at www.performing-databases.com and on the DOAG online-resource page.



Speaking at COLLABORATE 14: “YOUR machine and MY database – a performing relationship!?”

I’m excited to announce that IOUG accepted my talk

“YOUR machine and MY database – a performing relationship!?”

for COLLABORATE 14 in Las Vegas.

collaborate14-logo

I’d love to see you there – for tech talk, gossip and meeting old and new friends!

Abstract:

Databases affect machines, machines affect databases. Optimizing one is pointless without knowing the other. System administrators and database administrators will not necessarily have the same opinion – often because they know little about the opposite’s needs. This lecture was made to promote understanding – showing how the database can stress the server, and how the server can limit the database. And why two admins sometimes don’t speak the same language, not even with a developer as an interpreter.

  • Recall the different needs of different technical layers underneath a database system.
  • Understand the technical collaboration of hardware, operating system and database.
  • Plot ways how to avoid collisions, competition and concurrency.
  • Promote collaboration!

Date, time and location:

Thu, Apr 10, 2014
01:00 p.m. – 02:00 p.m.

Level 3, Lido 3003

The Venetian and Sands Expo Center
201 Sands Ave
Las Vegas, NV 89169
USA

Presentation and papers

2014_141_Klier_odp_v1
2014_141_Klier_v1_doc



Oracle Datenbank Architektur – nicht nur für Einsteiger (DOAG Konferenz 2013)

Talk at DOAG 2013

Thanks everybody for attending my talk “Oracle Datenbank Architektur – nicht nur für Einsteiger” at DOAG Conference 2013. It was a great feeling to have a packed room there. As promised, here comes my presentation and whitepaper (both in German).

OracleArchitektur-DOAG
OracleArchitekturNichtNurFürEinsteiger_Klier

Feedback is always appreciated!



DOAG Presentation: Oracle Standard Edition RAC

Wednesday last week, I had a presentation for my regional Oracle Users Group (DOAG Regio Nürnberg). The month before I was asked to display the difference between Enterprise Edition and Standard Edition RACs.

Here comes the presentation (German), for questions and suggestions just let me know.

Stay highly available
Martin Klier



Martin Klier now on twitter

After ignoring the little bird telling things for quite a while, I decided to join the tweeters. Twitter might bring more color into my daily reading. :)

If you feel like, just follow me – @MartinKlierDBA



DOAG Konferenz 2013: “Oracle Architektur – nicht nur für Einsteiger”

 

doag-2013-speaker-banner

 

 

After speaking about mutex waits last year, this time DOAG accepted my lecture “Oracle Architektur – nicht nur für Einsteiger” about Oracle Database basic architecture for this year’s DOAG Konferenz 2013 in Nürnberg. It will be the first lesson in a brand-new stream of the conference: The so-called “Einsteigerpaket” (beginners package) allows seeing a full stream of introductory talks by only purchasing a one-day ticket for the last day (thursday).

“Oracle Architektur – nicht nur für Einsteiger” will cover basic but important concepts of the Oracle RDBMS: How it makes ACID happen, what are Redo Logs, Undo Records, Before Images, how is locking done, and where not, and why all of those old day’s features allowed Oracle to introduce sophisticated stuff like RAC, Dataguard and Flashback without breaking bones.

Nuts and bolts is the topic, but on a level every IT technican should understand. Hope to see you there: 21.11.2013, 0900h, Room 19

Direct link to the session: http://www.doag.org/konferenz/vortrag_details.php?kid=441438&tag=21-NOV-2013&id=464288

EDIT:
Here the link to the papers and a photo from the session.




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.