Die Performing Databases GmbH unterstützt als Sponsor den Trip der DOAG #NextGen Community zur polnischen Konferenz POUG High Five nach Krakau.
Wir wünschen allen Teilnehmern eine erlebnisreiche Fahrt, tolle fachliche Vorträge und eine schöne Zeit beim Networking!
Ein paar freie Plätze sind noch vorhanden – also schnell sein und gleich hier anmelden!
Thank you all folks who attended my Dublin presentations at OUG Ireland! It’s great fun to be back to the island again, and I enjoyed talking very much.
Thursday March 23rd 2017:
„42 (alternative?) Facts for Oracle Clusterware, ASM and RAC“.
Download pdf here.
Friday March 24th 2017:
„No Magic, no Jungle, no Swamp: The Oracle Alert Log“
Download pdf here.
Thanks everyone who attended the talks, you are a great crowd!
– Martin
By effect of Februar 2nd, 2017 Oracle changed the lifetime support policies regarding Database 11.2.0.4 and 12.1.0.2:
Ends: Dec-2020
Extended Support fees are waived from Jan-2015 to 31-Dec-2018
See Oracle Software Technical Support Policies – look for „Exceptions“ in Section 3 – Lifetime Support Policy.
Patching for 11.2.0.1 ended on 13/Sep/2011
Patching for 11.2.0.2 ended on 31/Oct/2013
Patching for 11.2.0.3 ended on 27/Aug/2015 – See Note:742060.1
Ends: Jul 2021
Extended Support fees are waived for the period of August 2018 – July 2019.
See Oracle Software Technical Support Policies – look for „Exceptions“ in Section 3 – Lifetime Support Policy.
Patching for 12.1.0.1 ended on 31-Aug-2016
Customers now can operate 11.2.0.4 until end of 2018 without extra support cost, as long as they have a valid „Software, Update License and Support“ contract.
As of today, 12.1.0.2 is only under regular-cost support for 6 months more. If 12.2.0.1 is really released for on-premises March 15th, that should do.
MOS Oracle Database (RDBMS) Releases Support Status Summary (Doc ID 161818.1)
Oracle recently announced the availability of Oracle Database 12c release 2 (12.2) for on-premises servers.
Linux x86-64, Solaris SPARC and Solaris x86-64: 15-Mar-2017
Other supported platforms (Windows x86-64, IBM AIX on POWER, IBM Linux on System z, HP UX Itanium): Q2CY2017
Source:
MOS DOc ID 742060.1
Auf den Frankfurter IT Tagen 2016 liefen zwei Vorträge von Performing Databases aus dem Themenkreis Oracle, für die wir hier die Präsentationen kostenlos zum Download zur Verfügung stellen.
Vielen Dank an die zahlreichen Zuhörer und die tollen Gespräche im Anschluss!
„The Bad One Into Your Crop – SQL Tuning Analysis for DBAs (Die Schlechten ins Kröpfchen – SQL Analyse für DBAs)“ (Slides)
„42 Fakten zu Oracle RAC, Grid Infrastructure und ASM“ (Slides)
Thanks everyone who attended my Oracle Technology session „The Bad Ones Into Your Crop – SQL Tuning Analysis for DBAs“ at DOAG Konferenz 2016 #DOAG2016. (German: „Die Schlechten ins Kröpfchen – SQL Analyse für DBAs“) – Martin Klier
Slides: The Bad One Into Your Crop – SQL Tuning Analysis for DBAs
Picking out, validating and improving slow or resource-eating SQL statements is part of any responsible DBA’s work who takes his/her job serious. Identification alone can be tough, but it will be even harder to improve something you have no chance to understand the purpose of. This way, you will never be in the position to improve elapsed time by factors of 1 million or 100.000 – that’s a privilege of the designers and coders. But there is a generic way for us database whisperers to approach bad-behaving SQL, and improve it by factor 2, 5 or 10. Sometimes this is all we will get, so let me show you how: We are avoiding expensive tools, voodoo features, concatenated heuristics and one-engine-fixes-the-other. An unspectacular, real-world, common-sense approach, reaching the goals with grassroots technology.
Objective 1: Understand the basic components of parsing SQL in Oracle Databases
Objective 2: Pick the culprit, understand its execution plan
Objective 3: Weed them out, avoid collateral damage.
We are proud to announce an important new service level for our customers. From today, we will be faster on-site for your reliability! Yes, in IT most work can be done remotely, but in real emergency cases, customers really appreciate a database expert on-site within the shortest possible time.
Just call our emergency hotline: +49 9633 631
To improve these capabilities, Performing Databases is proud to present our newest extension to our car pool: A BMW M3. With an unthrottled top speed of more than 250km/h (155mph), we will be there. Whenever and wherever you need us!
Make: BMW
Model: M3
Generation: E92
Power: 308kW (420PS / 414HP)
Top Speed: >250km/h (>155 mph)
Engine type: V8
Transmission: Manual, 6-speed
Built: 2014
Mileage: 15.000 km (9320 mi)
Thanks everybody who reacted to our April Fool 2016! 🙂
Ein Blue Friday bei der esentri AG ist ein Tag angefüllt mit Arbeit, die Spaß macht! Das durften unsere Oracle-Experten Benedikt Nahlovsky und Martin Klier am vergangenen Freitag, 18.März 2016, in Ettlingen am eigenen Leib erfahren. Rund alle sechs Wochen steht dort einen ganzen Freitag lang nicht Rocken im Projekt im Vordergrund – sondern die Diskussion darüber, ob das Team mit den richtigen Mitteln auf das rechte Ziel zusteuert. Performing Databases lieferte hier passende Impulse zur Performance – nicht nur im Datenbankumfeld: Martins Vortrag „Performance is rarely an accident“ stellte Mittel und Wege vor, um Anwendern ein gutes Nutzungserlebnis zu bieten. Das Ziel ist, dadurch vom Markt als exzellenter Partner wahrgenommen zu werden. Zitat: „Gute Performance beginnt im Kopf!“
Im weiteren Verlauf der Veranstaltung im Barcamp-Stil gab es unter anderem einen Crashkurs in Oracle Datenbank Architektur mit dem Ziel, einen Überblick über potentielle Bottlenecks im Laufzeitverhalten von Datenbankaufrufen zu gewinnen. Das relationale Datenbanksystem bietet vorrangig Sicherheit für Daten und Strukturen, es hilft Applikationen, langfristig ihren Datenbestand sauber und konsistent zu halten. Um diese „nebenbei gelieferte Kernfunktion“ leistungsfähig zu machen und zu erhalten, existiert ein breites Spektrum an Maßnahmen auf Anwendungs- als auch Administrationsseite. Die Grundlage dafür ist das Verständnis beider Welten, und genau an der Stelle setzt die Philosophie von „Performing Databases“ an.
Die Mitarbeiter und Manager von esentri waren tolle Barcamper, die mit vielen Fragen, kreativen Szenarien und hervorragenden Beträgen für farbige und bleibende Eindrücke bei uns gesorgt haben. Vielen Dank an Euch alle, die esentri ausmachen! Vor allem für viele tolle Stunden bei Euch – das Team von Performing Databases hat sich sehr gefreut, als Gäste dabei sein zu dürfen. VIP-Behandlung ist nichts gegen Eure Gastfreundschaft!
esentri (www.esentri.com) vernetzt mit Begeisterung für führende Technologien Systeme, Prozesse und Menschen. Mit langjähriger Expertise und derzeit rund 50 Mitarbeitern liegt der Fokus auf der Integration von Systemen sowie der agilen Entwicklung von individuellen Anwendungen für Web und Mobile.
Dabei sind Oracle Middleware und Open Source Technologien die Basis für die Modernisierung von Geschäftsprozessen und der Digitalisierung von Geschäftsmodellen. Das Beratungsunternehmen ist, wie auch Performing Databases, ein Oracle Gold Partner und hat seinen Sitz in Ettlingen bei Karlsruhe sowie in der Schweiz.
From April 10th to April 14th 2016 one of the best and biggest Oracle community events of the year takes place, and we are proud to be there: Performing Databases at COLLABORATE16 in Las Vegas, with lectures and community work.
Martin Klier, Senior DBA Consultant
4:30 PM–5:30 PM Apr 11, 2016 (Session #4262)
Picking out, validating and improving slow or resource-eating SQL statements is part of any responsible DBA’s work who takes his/her job serious. Identification alone can be tough, but it will be even harder to improve something you have no chance to understand the purpose of. This way, you will never be in the position to improve elapsed time by factors of 1 million or 100.000 – that’s a privilege of the designers and coders. But there is a generic way for us database whisperers to approach bad-behaving SQL, and improve it by factor 2, 5 or 10. Sometimes this is all we will get, so let me show you how:
We are avoiding expensive tools, voodoo features, concatenated heuristics and one-engine-fixes-the-other. An unspectacular, real-world, common-sense approach, reaching the goals with grassroots technology.
Martin Klier, Senior DBA Consultant
3:30 PM–4:30 PM Apr 12, 2016 (Session #4927)
The new In-Memory-Option of the Oracle Database is widely talked about. But how do the In-Memory components of the database really work? Is In-Memory really so transparent as we are told? And why/why not?
This lecture has its focus on „the idea behind“ and is intended to be understandable for less experienced or part-time DBAs.
Learn, why using In-Memory Column Store is more or less beneficial for various access paths or usage profiles. Gain a basic expertise do decide if or if not to use this technology.
Martin Klier, RAC Attack Ninja 🙂
All Sunday, April 10, 2016 (Event Details and Prerequisites)
One of the best ways to learn new technology is with hands-on experience. During this workshop you will have an opportunity to set up Oracle 12c Real Application Cluster environment on your laptop, go through advanced RAC related setup scenarios or work together with other technical geeks on solving RAC related challenges. Experienced RAC Attack volunteers (ninjas) will help you address any related issues and guide you through the setup.
The Oracle Magazine featured our co-founder, Senior DBA Consultant and Oracle ACE Martin Klier in its „peer-to-peer“ column of the January/February 2016 issue.
Introducing Martin along with two other renowned technicians – Alex Zaballa and Gustavo Gonzalez – the feature was titled „Firsts and Favorites – Three peers who started early, stayed loyal, and stuck to tech basics“. Martin pointed out, how Oracle Core Technologies forms his daily life, and that Oracle Real Application Clusters (Oracle RAC) was his first love in the Oracle world. It’s easy to understand why – RAC is a highly scalable, sophisticated and reliable business continuity and high availability solution. Implemented into the database core, it provides a scale-out capacity that’s still unique in the market, even after so many years of modern RAC architecture.
See more about Martin Klier on our Team Page or on his personal blog.