Announcing the first E2SN Virtual Conference with Jonathan Lewis, Cary Millsap, Kerry Osborne and me – 18-19 Nov!

October 14, 2010 By 5 Comments

Yes, it’s official. I’m organizing a virtual conference with some of THE top speakers in the world. The topic is Systematic Oracle SQL Optimization (in real world)

The dates are 18-19 November, the conference lasts for 4 hours on both days, so you’ll be able to still get some work done as well (and immediately apply the knowledge acquired!).

Well, none of the speakers need introduction, but just in case you’ve lived in space for last 20 years, here are the links to their blogs :)

I can tell you, (at least the first 3) people in the above list ROCK!!!

And all of them are OakTable members too :)

This conference will have 4 x 1.5 hour sessions, each delivered by a separate speaker. We aim to systematically cover the path of:

  1. Finding out where is the performance problem (and which SQLs cause it)
  2. Finding out what is the problem SQL execution plan doing and which part of it is slow
  3. How to write and fix your code so that the optimizer wouldn’t hate your SQL
  4. How to fix the SQL execution plan performance problem when you can’t touch the application code!

And as this is the first (pilot) virtual conference, then the price is awesome, especially if you get the early bird rate by signing up before 1. November!

So, check out the abstracts, details, agenda and sign up here!

http://tech.e2sn.com/virtual-conferences

P.S. I expect this event to be awesome!

Filed Under: Cool stuff, Oracle Tagged With: , , ,

New online seminars – Advanced Oracle Troubleshooting v2.0 Deep Dives

October 4, 2010 By 19 Comments

As I mentioned in a previous post, I won’t be doing much flying anymore and so am changing all my seminar offering to online seminars.

So, I’ve changed and re-arranged my seminar content into self-contained 4-hour deep dives and thanks to the online nature (no travel needed), people can choose which days they want to attend. If you’re interested in latch contention only, you can attend the Latch Contention deep dive for example etc. Or you can still attend all the deep dives. The cool thing is that these deep dive sessions take only half a day, too (and are priced accordingly). That way you don’t have to skip work for the whole day (or week) and still can get some of your daily work done too. Hopefully it makes your life a bit easier when getting approval to attend the sessions.

As the main feedback from my seminars has been that “there’s too much to learn” within the short 2-3 days I used to do my seminars in, I have arranged the material so that there will be more time to go deep into the subject area. Also, I have planned plenty of time for questions & answers (1 hour out of the 4 hours is planned Q&A sessions and attendees can also ask questions any time during the lecture & demos).

It looks like I will only offer my Advanced Oracle Troubleshooting v2.0 class online this year. I will probably schedule my Advanced SQL Tuning deep dives in January/February 2011 and the Advanced Troubleshooting class again in March/April and so on (until I go public with my other business, when I won’t have time for full length training anymore).

You can check the current schedule and pricing out here:

Here’s a brief outline of individual half-day Deep Dives I offer:

  1. AOT deep dive 1: Systematic approach for Advanced Oracle Troubleshooting
  2. AOT deep dive 2: Troubleshooting physical IO and buffer cache issues
  3. AOT deep dive 3: Troubleshooting commit, redo, undo and transaction issues
  4. AOT deep dive 4: Troubleshooting Oracle SGA/PGA/UGA and OS memory issues
  5. AOT deep dive 5: Troubleshooting shared pool and library cache issues
  6. AOT deep dive 6: Troubleshooting enqueue lock waits and deadlocks
  7. AOT deep dive 7: Troubleshooting latch contention
  8. AOT deep dive 8: Troubleshooting Mutex and “cursor: pin” contention
  9. AOT deep dive 9: Troubleshooting complex hangs and spins
  10. AOT deep dive 10: Troubleshooting crashes, bugs and ORA-600/ORA-7445 errors

So, sign up now, seats are limited ;-)

Filed Under: Oracle Tagged With: , , , ,

Future appearances, conferences and seminars

February 11, 2010 By 2 Comments

Just to let you know where I’ll be in the near future :)

Seminars

Advanced Oracle Troubleshooting 2.0

I have rearranged and adjusted the material so it flows smoother, has even more practical tools and scripts and describes some internals even deeper ;-)

These dates are close, last chance to register ;-) Note that after these I won’t be doing an Advanced Oracle Troubleshooting class in US for a while…

Conferences

Hotsos Symposium, Dallas, TX, 8-11 March

I will deliver 2 presentations at the Hotsos Symposium 2010

  • Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely
  • Understanding LGWR, log file sync Waits and Commit Performance

Also, I will be the Training Day speaker after the conference (I feel quite honored about this btw ;)

  • Scripts and Tools for Oracle Troubleshooting and Advanced Performance Analysis

Note that I will show some very cool (and of course, useful) stuff at the Training Day! Some things are gonna be so cool that I almost want to sit in the audience myself! One of the things is called MOATS – the Mother Of All Tuning Scripts for example ;-)

Miracle OpenWorld 2010, Denmark, 14-16 April

I will deliver two sessions at MOW

  • Understanding LGWR, Log file sync Waits and Commit Performance
  • Oracle Wait Interface is Useless (sometimes) – together with  James Morle

It will be fun! :)

IOUG Collaborate, Las Vegas, NV, 19-22 April

Does “What happens in Vegas…” also apply to all the new stuff learnt at a conference? ;-)

EMEA Harmony 2010, Tallinn, Estonia, 20-21 May

This event will be a blast – awesome speakers (Steven Feuerstein, Tom Kyte, C.J. Date among others) and for the first time the Estonian,Latvian,Finnish and Russian OUG organize such event together (I’m from Estonia originally who don’t know that)

I will deliver a keynote there and one more session:

  • Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely (keynote)
  • Understanding LGWR, log file sync Waits and Commit Performance

Michigan OakTable Symposium, Ann Arbor, MI, 16-17 September

This will be an awesome event, lots of OakTable people there, including me!

  • Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely
  • Understanding LGWR, log file sync Waits and Commit Performance

I think we’ll even have a chance to see some football there…

Filed Under: Cool stuff, Oracle Tagged With:

My public appearances and final AOT seminar calendar for 2009

August 13, 2009 By 2 Comments

Advanced Oracle Troubleshooting for DBAs and Performance Engineers

These are the public seminars I will do in 2009. I won’t add any more for this year as my calendar is almost full.

When I published this list last time I told there would be an addition for San Francisco Bay Area people. The event is added below (11-12 Nov).

9-11. September – Hotsos @ Dallas, TX – Postponed to later. I’ll keep you updated.

14-16. September – Hotsos @ Washington, DC – https://portal.hotsos.com/education/SEM/

5-6. October – Miracle @ London, UK – http://www.miraclebenelux.nl/tanel/

8-9. October – Miracle @ Helsinki, Finland – http://www.miracleoy.fi/

2-3. November – Miracle @ Utrecht, Netherlands – http://www.miraclebenelux.nl/tanel/

5-6. November – Miracle @ Brussels, Belgium – http://www.miraclebenelux.nl/tanel/

11-12. November – San Francisco Bay Area, CA – http://www.nocoug.org (more details to follow)

3-4. December – Miracle @ Birmingham, UK (right after UKOUG conference) – http://www.miraclebenelux.nl/tanel/

Conferences 2009

13. Nov NoCOUG Conference – topic TBD

2.Dec UKOUG Tech and EBS Conference

  • Latch and Mutex Contention Troubleshooting in Oracle - 1 hour session
  • Practical Oracle Capacity Planning – 2 hour masterclass
  • Note that I will be doing my 2-day Advanced Oracle Troubleshooting seminar right after UKOUG on 3-4 Dec in Birmingham. This should be a convenient opportunity to fry your brains even more during the same trip.

6. Dec CMG Conference

  • How To Do Capacity Planning in Oracle – half day workshop, with Dr Neil Gunther

I will also be around San Francisco when Oracle OpenWorld takes place, I’m not speaking at OOW, but will speak at another special event that same week – so stay tuned ;-)

Filed Under: Cool stuff, Oracle Tagged With: , ,

Links section

June 14, 2009 By 1 Comment

I have added a links section into my blog where I put links to useful external documents and tools what I often refer to during my seminars and consulting.

I will make additions to that page over time…

To see the list, you can click on the “Seminar Links” in top right section of the blog page or just click here:

http://blog.tanelpoder.com/seminar/seminar-links/

Filed Under: Oracle Tagged With: , , , ,

Advanced Oracle Troubleshooting Seminar list for 2009

June 4, 2009 By Leave a Comment

This is the final list of seminars planned for 2009.

Except these I won’t be doing any more public AOT seminars this year as my calendar is almost full up to January 2010.

So if you like my writing, Oracle internals & OS touchpoint, and want to troubleshoot better, check out events in this list :)

15-17. June – Trutek @ Denver, CO – http://www.trutek.com/index.php?id=165

9-11. September – Hotsos @ Dallas, TX – https://portal.hotsos.com/education/SEM/

14-16. September – Hotsos @ Washington, DC – https://portal.hotsos.com/education/SEM/

5-6. October – Miracle @ London, UK – http://www.miraclebenelux.nl/tanel/

8-9. October – Miracle @ Helsinki, Finland – http://www.miracleoy.fi/

2-3. November – Miracle @ Utrecht, Netherlands – http://www.miraclebenelux.nl/tanel/

5-6. November – Miracle @ Brussels, Belgium – http://www.miraclebenelux.nl/tanel/

10-11. November – Northern California (SFO Bay Area, more details in mid-June)

3-4. December – Miracle @ Birmingham, UK (right after UKOUG conference) – http://www.miraclebenelux.nl/tanel/

Filed Under: Oracle Tagged With: , ,

Seminar in Edinburgh next week – discount to UKOUG members (and a little comment about Snapper)

April 23, 2009 By 4 Comments

Just wanted to let you know that there are still places left for my troubleshooting seminar in Edinburgh next week and there’s a 20% discount for UKOUG members.

The event takes place 27-28 April – Check the PiSec seminar page if you’re interested!

Btw I will have whole 10 free days after the Edinburgh event so expect some interesting and useful blog entries then (instead of the marketing stuff what you’ve had to tolerate for last few times ;)

I have moved Snapper v2.01 (out of beta now) to http://www.tanelpoder.com/files/scripts/snapper.sql , it’s layout & output columns are configurable now btw (search for “config” in the script).
If anyone still misses the old version of snapper (v1.07), you can download it from here

Filed Under: Oracle Tagged With: ,

Seminar feedback and pictures from Singapore

April 20, 2009 By 1 Comment

I’ve been busy with a series of seminars, so haven’t managed to blog much…

Karl Arao has posted some feedback from my Singapore seminar and also the pictures we took with attendees. By the way, he has other good Oracle stuff in his blog so check it out here.

Filed Under: Oracle Tagged With:

Done with my seminar in Netherlands – here’s some feedback and couple beta new versions of my scripts

April 5, 2009 By 5 Comments

The Miracle Masterclass I delivered last week in Netherlands was awesome, I had lots of attendees and lots of good questions and feedback. As usual, I ran out of time in the end though. I will make this up with some articles about the stuff I didn’t have time to explain :)

I used Snapper v2.0 beta during my demos there and also an improved version of LatchProfX which can give some additional context information about reasons why latches were taken. As they are beta, not final versions, I have uploaded them into a temporary location:

Update: These scripts are out of beta now so here are their permanent locations:

Also, the Sesspack (session level statspack) v0.05 files are in my TPT script set, under tools/sesspack_v0.05 directory in the zip file:

Toine van Beckhoven attended the seminar as well and wrote a review of it, if you’re still hesitating if you should attend as well, read his review first :)

Filed Under: Cool stuff, Oracle Tagged With: , ,

New US seminar dates

March 2, 2009 By Leave a Comment

Here are two more US dates of my Advanced Oracle Troubleshooting seminars, organized by Trutek.

These seminars are 3 days each, so there will be more time to thoroughly explain things and do even more demos!!! :)

10-12. June – Trutek @ Salt Lake City, UT – http://www.trutek.com/index.php?id=165
15-17. June – Trutek @ Denver, CO – http://www.trutek.com/index.php?id=165

Filed Under: Cool stuff, Oracle Tagged With: , , , ,
« Older Posts
Newer Posts »