Real World Performance Tour

Today I was in Breda, the Netherlands for the Real World Performance Tour, organized bij the Oracle Benelux Users Group. It is a day-long session by Andrew Holdsworth (Senior Director of Oracle’s Real World Performance team), Tom Kyte (who doesn’t know Ask Tom?) and Graham Wood (the guy behind AWR and ASH).

Still, I was wondering what kind of session this was going to be. I was hoping the punchline wouldn’t be “and that’s why you need Exadata” all of the time .. like Oracle ..uhm.. occasionally tends to do .. uhm.. yeah. Scratch that.. replace “occasionally” with “fairly often”.

Fortunately Oracle’s Real World Performance Tour is not a session like that at all. Quite the opposite. Andrew, Tom and Graham show you real world performance issues .. on an Exadata machine. Now please don’t say “Performance issues? On an Exadata machine?!” out loud, because someone at Oracle’s marketing department might hear that and you don’t want that. No, the purpose of this day is to show that with bad design decisions you are still able to bring even the fastest machines to their knees. And also that it doesn’t have to be this way.

Real World Performance Tour in Breda, the Netherlands

Real World Performance Tour in Breda, the Netherlands

Even if you’re not running databases on Exadata, the demo’s that are shown might be awfully familliar. For example: the SQL performance demo was amazingly similar to an issue I’m currently working on, including the thinking in solutions instead of trying to find out what we’re actually asking of the database. You also might see familiar bottom-up style solution finding. Hardware first, then (undocumented?) instance parameters and memory. SQL? Design? Meh. Maybe later. Or never, because we’re not supposed to change the code.

Also shown are middleware-database issues. Like what happens when you connect with 9000 threads to the database with a quite active application. On a database with quite a lower number than 9000 CPU cores. Or what issues you’ll see when the application suffers of cursor leaks, session leaks or literal SQLs instead of bind variables.

So expect to learn, but also expect to laugh (in recognition). And take the development team with you. Or the performance project team I’m currently working with. It’s a really worthwhile session even for DBA’s that regularely work on performance issues, like me.

Andrew, Graham and Tom discussing a particularely bad AWR report.

Andrew, Graham and Tom discussing a particularely bad AWR report.

The Real World Performance Tour was only for one day in the Benelux (Netherlands/Belgium/Luxemburg), but the tour continues:

For other dates, I’d recommend to check out Tom Kyte’s blog regularely.

About Marcel-Jan Krijgsman

Marcel-Jan is de PR-functionaris van de Werkgroep Maan en Planeten. Hij verzorgt ook het nieuws op de Facebook pagina en deze blog.
This entry was posted in Oracle performance tuning and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s