Usn's IT Blog

The German Oracle User Group (DOAG Deutsche Oracle Anwendergruppe) announced Munich as a location of the Real World Performance Tour 2014 with

• Tom Kyte, Senior Technical Architect ORACLE Server Technology Division, ORACLE Vice President
• Graham Wood, Architect Server Technologies
• Andrew Holdsworth, Senior Director Real World Performance Server Technologies

Location: Munich (Details coming soon)
Date: February 19th 2014
Time: 9am – 5pm
Cost: EUR 130,- (Early Bird)

Link to the DOAG event page: http://www.doag.org/termine/termine.php?tid=460483

Looking forward to meeting you there!
Martin Klier

I’m no fan of preselecting kid’s ways of life. But I couldn’t resist bringing a T-Shirt from OpenWorld back to Germany. Now since it fits Maxi, I’m just loving it. :)

 
The other picture is my teammate Benedikt as Maxi’s cushion. :)

 
Please: Let your kid choose their own way. I had this choice, and I’m very happy with a job my parents didn’t even know.

Take care
Martin

On Friday, 08/03/2013, I’ll present an online lecture about Oracle Architecture for the DOAG (Deutsche Oracle Anwendergruppe, German Oracle User’s Group) and the DOAG SIG Database.

Link: http://www.doag.org/termine/termine.php?tid=454245

The lesson will contain (excerpt from TOC):

• Oracle Datenbank-Architektur
  • Verbindung, Namespace(s) und Abschottung
  • Instanz und Datenbank
  • Alles Blöcke, oder was?
  • Redo, Undo und was man damit macht
• Stets das Ziel: „Das Konzept dahinter“ verstehen
• Primär für Einsteiger = Vertiefung für Erfahrene

It’s free for members, so I hope to welcome you there.
Martin Klier

Here comes the presentation: Oracle Datenbank Architektur – nicht nur für Einsteiger
Thank you very much for attending!!

“Resolving Child Cursor Issues Resulting in Mutex Waits”: Here are my presentation and the white paper about child cursor related mutex waits. The white paper is also available as an article in the IOUG SELECT Journal 3rd Quarter 2012 (Vol. 19, Number 3).

Thanks a lot to all attendees – it was great fun to speak there and to get this overwhelming feedback – to hear “best talk so far” multiple times on a third day is really awesome.Thank you very much!

Yours
Martin

Hi there,

as usual, here are my personal notes from DOAG Konferenz 2012 (annual conference of the German Oracle User’s Group). I was there for two days, not three, on account of workload. But it was really good there, and again the event was a great mixture of technology and people/networking.

Ok, here’s the list. Look at:

• V$SQL_CS_SELECTIVITY, V$SQL_CS_STATISTICS and V$SQL_CS_HISTOGRAM to see a summary how often we are using child cursors
• the BIND_AWARE hint and its opposite (starting with 11.1.0.7)
• Adaptive Cursor Sharing works with up to 8 bind variables
• There will be Cardinality Feedback for Join Cardinalities in Oracle Database 12c (Christian Antognini)
• SQL reoptimization in 12c (V$SQL.IS_REOPTIMIZABLE), a new term for Cardinality Feedback
• dbms_xplan format=’all_dyn_plan’ to display 12c dynamic plans (Keyword: Inflection point)
• Cloning pluggable databases within a container DB is only possible with “open read only” of the source, so what about live cloning?

Yeah, a short list this year, but I did a lot of technical testing stuff there and thus, forgot to write down the one or other thing.

Another compliment to the DOAG staff: Inviting Sascha Lobo for a keynote was a great idea, and also to make the boring usual, ever-skipped Q&A session really fun this year. Carry on!

Regards
Martin

It was a great OakTableWorld this year. Thanks to the organization team around Kyle Hailey! There have been many speakers worth listening to, just to mention the best in my opinion: Cary Millsap, Jonathan Lewis, Tanel Põder, Alex Gorbachev, Connor McDonald and John Hurley.

OakTableWorld: Jonathan Lewis in action

I had the chance to have a TED Talk of 10 minutes, to explain why you never should change server hardware without a DBA and an oscilloscope on site. :) Here are my three slides on that.

Thanks a lot for everything
Martin

Oracle’s CEO Larry Ellison announced Oracle Database 12c, with a focus on its Pluggable Database feature.Oracle Database 12c will become available in 2013.

Mr. Ellison pointed out, that in consolidation cases, saving the overhead for processes and memory structures gives the product an advantage over competitors.

There have been more announcements: Oracle Cloud, Oracle Private Cloud (behind our own firewalls) and Exadata X3. The newest generation of Exadata will cost the same as X2 did, but will have 26TB of semiconductor memory: 4TB of DRAM and 22TB of Flash. Exadata X3 will be available as 1/8 rack for the first time, costing below $200.000, plus licensing costs.

Some other folks told me, that Exadata appliances will allow double mirroring for the first time (not forcing to triple mirror any more).

Have fun and do not make purchase decisions based on this blog entry. :)
Martin Klier

As promised in the session, here comes my presentation from Oracle Open World 2012, Moscone West, Room 2016 at 10:30 PST. For the case studies and detailed information, please see the white paper or my article in the newest IOUG SELECT Journal (Vol. 19 / No. 3 / Third Quarter 2012).

Thanks a lot to the more than 200 attendees and thank you very much for the good and constructive discussion afterwards! The latter is always the best part!

I hope you all are enjoying a beautiful conference and have a safe way home!
Martin

On behalf of Klug GmbH integrierte Systeme and the IOUG, I will speak in the US for a second time this year: “Resolving child cursor issues resulting in mutex waits” at Oracle OpenWorld 2012 in San Francisco, Moscone Center.

It’s Session UGF10573 (User Group Forums)
Date and Time: Sunday, 9/30/12, 10:30 – 11:30
Venue / Room: Moscone West – 2016

Track:

DATABASE

Description:

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.

Read more…

Hi folks, thanks for attending my lesson!

Here comes the paper and presentation. If there are further questions, feel free to contact me – email and stuff is in the documents.

2012_893_Whitepaper (pdf)

2012_893_Presentation (pdf)

Regards
Martin