Tanel Poder’s Database Performance and Troubleshooting Seminars

Tanel Poder’s Performance & Troubleshooting seminars

I am really busy with all the Gluent action right now, so am not planning to run any generic database performance classes, although will still occasionally geek out and run some hacking sessions hopefully. I’m interested in the new world technologies now, Hadoop, Spark, cloud processing engines and am still regularly working on/thinking about performance, efficiency and scalability of these platforms – so stay tuned for more in this space!

I delivered my first Hadoop presentation (Hadoop Internals for Oracle DBAs) already in the summer of 2013 (Enkitec E4 conference), but Hadoop has evolved *a lot* since. So we have put together a 1-day Hadoop for Database Professionals class and are delivering it online (and sometimes at customer site) now:

This is of course only the beginning, the enterprise world is changing ;-)


25 Responses to Tanel Poder’s Database Performance and Troubleshooting Seminars

  1. I just attended Tanel’s 2-day seminar in Singapore and I can say it is definitely one of the best troubleshooting and performance tuning seminars I have ever attended. Tanel has a unique “out of the box” approach to Oracle tuning in his extensive use of Unix-level utilities. His scripts are also amazing). I would definitely recommend his seminar to anyone else.

  2. Tanel Poder says:

    Hi Ted,

    This class is *exactly* for field DBAs providing troubleshooting and support services (or just trying to understand Oracle better). This class is also very practical, I show many demos based on real life problem cases and systematic approach + tools for troubleshooting them.

    My seminar outline describes the internal components of Oracle what I’m going to explain and troubleshoot, it’s perhaps not best for describing what *skills* are you going to learn from the seminar, so here is the list (I will upload the list to this seminar page later too):

    You will learn following skills and knowledge at the seminar:

    – Systematic approach to troubleshooting and tuning

    – Oracle, OS interaction and using OS-level tools for Oracle troubleshooting

    – Using the full power of Oracle’s built in instrumentation for troubleshooting

    – Troubleshooting crashes, ORA-600’s and complex hangs

    – Troubleshooting latch and mutex contention

    – Troubleshooting enqueue lock contention and deadlocks

    – Troubleshooting Oracle private, shared and OS memory problems

    – Troubleshooting Oracle cursor management and library cache problems

    – Troubleshooting SQL execution by understanding execution plan internals and data flow

    – Troubleshooting buffer cache, logical and physical I/O problems

    – Troubleshooting undo errors, excessive redo and transaction related problems

  3. Tanel Poder says:

    So, this is a TROUBLESHOOTING class. If you have trouble with your databases such as hangs or performance issues, this class will help to find out what are the problems exactly and what’s causing them.

    Of course the production support DBAs often do lots of other work like setting up standby databases, refreshing prod to dev etc etc. My class is not about these things, its entirely about systematic troubleshooting !

  4. Simon Palmer says:


    Went to the London seminar on Monday/Tuesday. Excellent. Can only say I wished it was 3 days!

    Got a chance to apply my knowledge immediately the very next day at work. As I walked in there was a problem with a hung production database being investigated by other DBAs. The other DBAs couldn’t sqlplus in as normal, I tried the -prelim option and did a dump hanganalyze. The leaf process was the RVWR (recovery writer). The tracefile showed the pattern of waiting sessions as demonstrated on the course. The resulting problem – lack of recove dest space – is actually reported in the alert log and quite easy to spot (or should be!!), but I wanted to adopt the new approach as learnt…! ;-) As it turns out, someone had left a guarenteed restore point in the recovery file dest and once that was removed, the hang stopped… :-D

    Since then been using some of your TPT scripts. Hacked a bit as they’re written for Windows, so the host commands swapped for unix ones…

    Great set of scripts though and once again a great seminar. Very enjoyable and interesting!



  5. Tanel Poder says:

    Hi Simon!

    Awesome! I’m especially glad to hear feedback about the use of this knowledge for troubleshooting real life problems!

    I’m glad that it was helpful! Thanks!

  6. Thierry Brouwers says:

    Hi Tanel,

    Just a quick note to let you and your blog readers know that your seminar in Brussels the last couple of days was great !

    I can honestly say I’ve learned a lot. Not just new factual things, but you’ve showed new ways to approach problems where the beaten path falls short.

    The techniques you’ve showed are truly impressive, and I’m sure they’ll prove their worth next time Oracle throws something nasty my way :-)

    (well, after I’ve been able to process all of the information from your seminar, that is) :-)

    The way you structure these techniques into a repeatable systematic troubleshooting approach simply rocks !!

    I can truthfully recommend this seminar to any DBA willing to think out of the box.

    Thanks again,

    Thierry Brouwers
    DB Minded

  7. Joe Ramsey says:


    Just wanted to check since it’s close to the end of December if you have an firm seminar dates yet? Looking forward to getting in as soon as possible!

  8. Pavan Kumar N says:

    Hi Tanel,

    Really Impressed with your blog and your technical article High Lights. I am out of words to express / speech less. Really, god had done unfair for us, that you are born and living in U.K. You are Real master of ORACLE. I can only request one thing in front of you, Is it possible to Plan “Advance Trouble Shooting Seminar” in INDIA, this year. I will be really happy for that.

    Thanking you in Advance.

  9. Khalid Azmi says:

    You should consider doing online virtual classes for people who cannot travel so easily :-)

  10. Tanel Poder says:

    @Khalid Azmi
    Good point Khalid! Quite a few more people have asked for this, so I will plan something (however I don’t have time right now so it’s gonna be 2nd half of 2010 I’m afraid).

  11. Onin Casimiro says:

    Hi Tanel,

    It was nice meeting with you with the free seminar conducted at SMU. Learned a lot from it.

    Well recommended!!


  12. Ananth says:

    @Tanel Poder
    Tanel :

    Virtual classes with pre-recorded sessions and few hours of follow-up question/answer session would be great way to maximize your time and provide value ( in a low cost)… Why don’t you think about it ?.

    This way, you will help/teach many people even while you sleep :-)

  13. Thank you so much for sharing this precious information with us.

  14. UK says:

    Hello Tanel,

    This is the first time I am reading your blog and I should say, its great, very informative and that too simple language. Please let me know if you plan to have any training sessions in Sunnyvale/Santa Clara area in state of CA, I would like to take the opportunity to attend.

    Can you please give some insights on few questions as below

    1.> What in your view; should a DBA managing around 20+ production database monitor as a health check in a database ( specially from performance prespective) . I know there is no silver bullet , but I am sure expert like you would point to top 10 things a DBA can monitor to ensure that his or her Database is in good state from overall health wise. ( AWR or OEM like other 3rd party tools is not affordable ) .
    2.> Now that we have features like ASSM and Locally managed Tablespace,what is the best way to monitor (segments) space monitoring prespective , what should a DBA focus on and how.
    3.> I have articles on experts expressing there views on “hit ratios” what are your views ? I still like to get hit ratio as they are good indications of state. Why is do experts hate hit ration , why Oracle still has it documentation or in there performance advisories such as AWR ? What in your way are good performance indicating ratios ?

    Please advice.

  15. vikram sharma says:


    Do we have any dates for online trg (Advanced Oracle Troubleshooting v2.0 Part 1 & part 2) after 2nd dec. I am planning to take both , but need to get budget approved from my company for that. It would be great if we can have some dates for the same

  16. Sam Jazz says:

    hi Tanel,

    do you have any published book or are planning to do so?

    Thanks and Regards,

    • Tanel Poder says:

      No I don’t have any Oracle Troubleshooting books published (I’ve co-authored the Expert Oracle Exadata book though). And I likely won’t ever write one. If you want to learn internals of modern Oracle databases, then Jonathan Lewis’es Oracle Core internals book is the best choice – I was tech reviewer of his book and it goes very deep and is very thorough.

Leave a Reply

Your email address will not be published. Required fields are marked *