Training and Seminars on Oracle, Exadata and Performance

Tanel Poder’s Advanced Oracle Seminars and Training in 2014

28 Apr - 2 May 2014 (online, Part 1)
19 - 23 May 2014 (online, Part 2)
0800 - 1200 PST
(10 half days)
Advanced Oracle Troubleshooting v2.1Tanel Poder$3600 USDRegister here!
or email

How to attend our online training courses:

  1. Sign up for the class [ via | | call (972) 607-3751 ]
  2. 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 and demos to reproduce problems in your sandbox database. You can use any Oracle version you like (but no more 9i, please ;-)
  3. Print out the PDFs with slides (if you like them on paper) – you will receive the slides in the week before the seminar starts
  4. Download my scripts (I do update the .zip file from time to time)
  5. Test if GotoWebinar is working on your computer!
  6. On the seminar days, attend the seminar via the GotoMeeting link (I will send out the GotoMeeting link in the week before the seminar starts)

You can check the schedule of other Enkitec classes here:

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 email (details in the bottom of this page) if you need any help or 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 roughly following (Pacific Time):

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

If some questions take longer to answer (with a demo), I may postpone these until the end of the day – the “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’ 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 )
  • Each attendee should purchase a seat – paying for one seat and having several attendees share the GotoWebinar session is not allowed.
  • The training has been optimized for online delivery. Sufficient time is alotted for questions and answers.
  • 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.
  • 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 here to know more about how to interact with the presenter in GoToWebinar.
  • You don’t need to book an airline ticket and hotel accommodation the way you usually do just to get 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.

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

For technical questions about the contents and delivery of the class, drop a mail directly to me:

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

20 Responses to Training and Seminars on Oracle, Exadata and Performance

  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. Ted Yoshihara says:

    Being a member of NoCOUG and a production support DBA, I was very excited when I learned of this seminar and quickly signed up not caring if my employer would pay for it. But not being made of money, I approached my manager about it, and after some apprehension on his part, he agreed to pay. But he did say that “from my perspective, as a person trying to provide DBA Services, this is not a useful class”. He did offer to meet and explain this so I plan to do that. But my question is, if this seminar is not for a DBA, who is it for?


    Ted Yoshihara

  3. 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

  4. 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 !

  5. 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!



  6. 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!

  7. 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

  8. 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!

  9. 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.

  10. Khalid Azmi says:

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

  11. 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).

  12. 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!!


  13. 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 :-)

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

  15. 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.

  16. 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

  17. 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.

  18. earl shaffer says:

    I will get paid training again from my emp the day after pigs fly fast enough to cause the dopler effect
    so …

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>