Tanel Poder’s Oracle & Linux Performance and Troubleshooting Training

Tanel Poder’s Advanced Oracle & Linux Training in 2018

Many people have asked about my Advanced Oracle Troubleshooting training and videos, so I decided to update my material over the holidays and will run one more class! The dates for my training in 2018 are in the table below.

Note that if you are looking for Hadoop & Big Data related stuff, we are regularly delivering our Hadoop class and other webinars at Gluent too!

Online training dates for 2018:

Date (2018)TimeTitlePresenter(s)PricePurchase
Stay tuned!No more dates announced (yet).

Paypal accepts payments using major credit cards (no signup needed) and you will get a receipt for your records. If you need an invoice, please email us at seminars@poderc.com!

How to attend our online training courses:

  1. Purchase a seat for the class (use the table above or send an email to seminars@poderc.com with your company details)
  2. If you’d like to play the previous AOT class videos (AOT 2.5 from 2015) upfront, then send an email to seminars@poderc.com and I can send you 9 earlier deep dive recordings (1 session had recording problems so it will have to wait until the live class). The previous recordings are available only for registered attendees of the 2018 class.
  3. Ideally have a development / sandbox database available for reproducing the problem scenarios, troubleshooting and testing out the Oracle troubleshooting and optimization techniques. There are no workshop-style practice sessions, but there are lots of hands-on troubleshooting demos and you can re-run my scripts & demos to reproduce problems in your sandbox database. You can use any Oracle version you like (but no more 9i, please ;-)
  4. Print out the PDFs with slides (if you like them on paper) – you will receive the slides in the week before seminar start
  5. Download my scripts (I do update the .zip file from time to time)
  6. Download the GotoWebinar software (to avoid the web-only version). Test if GotoWebinar is working on your computer.
  7. On the seminar days, attend the seminar via the GotoWebinar link (I will send out the link in the week before seminar start)

In the week before the training/seminar date, you’ll receive training materials/handouts and instructions that will include information necessary for you to log on to the class’ GoToWebinar session.

Feel free to send us an email  if you have any inquiry about the course content, schedule or attendance instructions – we want you to feel comfortable and well-prepared to learn when you attend our classes!

The schedule of every half-day is following (Pacific Time):

  • 08:00 – 09:30 – Session 1
  • 09:30 – 10:00 – Q&A + Break
  • 10:00 – 11:30 – Session 2
  • 11:30 – 12:00 – Q&A + extra demos

If some questions take longer to answer (with a demo), I may postpone these until the end of the day – to “extra demos” session.

In attending our classes, you agree to have read and understood these points:

  • All online training will be conducted online in a virtual class, delivered through Citrix’ gotowebinar.com service
  • The attendee is expected to have his/her own means of accessing the online virtual class ( i.e. computer, a testing database, internet connectivity: System Requirements for attending online seminars )
  • The training has been optimized for online delivery. Sufficient time is allotted for questions and answers.
  • Each attendee must purchase a seat – paying for one seat and having several people share the GotoWebinar session is not allowed.
  • Training handouts will be distributed in PDF format and in attending this training, you agree that you will not redistribute these handouts to anyone else.
  • You can cancel your attendance and get a full (100%) refund up to a week before the seminar starts, assuming that you haven’t requested & received previous training sessions videos. Note: Once any training material (PDFs or video recordings of previous sessions) are sent out to you, there is no refund.
  • Training recordings will be distributed as downloadable MP4 videos. Each attendee will get a version of digitally watermarked videos with his/her name on it. These videos are yours to keep, but you must agree to not redistribute these videos to anyone else.
  • Neither PoderC LLC nor any of its trainers (Tanel Poder) are liable for any damage caused, directly or indirectly, by following (or not following) the advice in the training material or advice given during the training sessions and any follow-ups. While we advise to only use known-to-be safe techniques and will warn you about any potentially-unsafe techniques, the ultimate responsibility of assessing risk and avoiding any damage to your IT systems always lies in you, the attendee.
  • Attendees can ask questions any time during the training (through the chat interface during the lecture and via a normal voice discussion during breaks and Q&A session). Read this to know more about how to use GoToWebinar.
  • You don’t need to book an airline ticket and hotel accommodation the way you usually do to get access to world-class training :)

Learning is best achieved with examples and demos and we’ve got lots of it! We can’t emphasize enough how seeing an expert do his work can greatly contribute to your learning.

Installation & Setup

I have created a separate page for explaining the Installation and Setup recommendations for getting the most out of this AOT class.


If you need to pay via a Purchase Order/Invoice or have questions about registration and payment, email: seminars@poderc.com

For technical questions about the contents and delivery of the class, drop a mail directly to me: tanel@tanelpoder.com

Go back to beginning of this page to register and “See you soon!” :-)

31 Responses to Tanel Poder’s Oracle & Linux Performance and Troubleshooting Training

  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 *