Usn's IT Blog

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

This is my example schema, basis for the DB tuning lectures. Please use your “save as” function or copy the URI to use wget.

expdp_klm1.dmp.bz2
expdp_klm2.dmp.bz2

Regards
Martin Klier

This year, I will talk again about basics of DB technology for 9th grade of AGW (Augustinus Gymnasium Weiden, a secondary school) again. The same event has been a success in the last years, and it’s simply nice there.

Nice? Please allow me a word about this school. They have an engaged teacher, Klaus Märker, who does a lot more of IT teaching than he would have to. His voluntary IT classes are simply looking great and promising. It’s a big opportunity for the kids, to learn some IT specials during their school time. I hope, you know and value what he does for you.

It was self-evident for me to support his approach on showing the young ones more than ministry officials creating an official curriculum can imagine. Database technology is some kind of “poor cousin” in IT schooling. I see that every day. I am not under the imagination that the girls and boys there will become database pros from one lecture, may it be good or bad. But they have a chance to see more than their history-, latin- or maths books. And be honest, at least, if you don’t use a database by yourself, your name is already inside a pretty good one.

Ok, enough of this monologue, here comes the paper.

Hopefully, it will be fun again,
Martin

Once again, I will talk about an IT topic at Vocational School (Berufsschule) Wiesau. This year, it’s Basics of Database Technology (Grundlagen der Datenbanktechnik) for 11th and 12th-graders, who will become certified IT specialists for software development soon. Their certification is called “Fachinformatiker der Fachrichtung Anwendungsentwicklung” in German.

The paper for the talk is available now: DB-Grundlagen.pdf

EDIT:
See the kind report about the day as well.

Best regards
Martin Klier

On Thuesday, March 24th, 2009 at 9 a.m. I will speak at Berufsschule Wiesau about general matters of IT performance.

Papers and the presentation are available online now:

Handout “IT-performance”

Slides

Regards
Martin Klier

EDIT: That’s a nice article about the event on the school’s webpage. Thanks!

Tomorrow, there will be a version 2.0 of a lecture from last year, again for 9th-formers of Augustinus Weiden.

The handout and the presentation are online now, we will see what Friday brings.
Usn

Hi,

http://www.openstreetmap.org is a very cool project. Just discovered it for me, and spent the weekend with tracking and editing my hometown by car. Have a look here to see.

I am using SportsTracker for my Nokia E90 and JOSM for the editing at home.

Also checked for TrekBuddy on the phone to use a real moving map on the cellular. Maybe you want to use a little help for generating the map files for TrekBuddy?

Still much to learn, stay tuned for reports.

Regards
Usn

EDIT: Today (18th of June) at the LUG meeting in Mitterteich will be a short talk about OSM including some practices.

Hi,

there will be a talk about IT High Availability for rising IT professionals at Vocational IT School Wiesau on Monday, 10th of March 2008.

The topic:
“Hope is not a startegy” – IT high availability in theory and practical experience

See paper and slides here.

Regards
Martin

EDIT: There has been a nice press publication about this lecture.

Tomorrow at 10 a.m. I’ll give a lecture about the “Basics of database technology” in German language for 9th-formers of Augustinus Grammar School in Weiden.

See the handout and the presentation here.

Regards
Usn