Tanel Poder’s Advanced Oracle Seminars and Training in 2013
| Date | Time | Title | Presenter(s) | Price | Registration |
|---|---|---|---|---|---|
| 2 - 3 May (Irving, TX) | 0900 - 1700 CST (2 full days) | Advanced Oracle Exadata Performance: Troubleshooting and Optimization | Tanel Poder | $2500 USD | Register and pay at: enkitec.com/education/ |
| 13 - 16 May (online) | 0800 - 1200 PST (4 half days) | Advanced Oracle Exadata Performance: Troubleshooting and Optimization | Tanel Poder | $2500 USD | Register and pay via: 1. Credit Card/Paypal 2. Purchase Order/Invoice enkitec.com/education/ |
| 10 - 11 June (online) | 0800 - 1200 PST (2 half days) | Getting the Most Out of Oracle's Active Session History | Tanel Poder | $800 USD | Register and pay via: 1. Credit Card/Paypal 2. Purchase Order/Invoice enkitec.com/education/ |
| 21 - 25 Oct (online, Part 1) 18 - 22 Nov (online, Part 2) | 0800 - 1200 PST (10 half days) | Advanced Oracle Troubleshooting v2.1 | Tanel Poder | $3600 USD | Register and pay via: 1. Credit Card/Paypal 2. Purchase Order/Invoice enkitec.com/education/ |
How to attend our online training courses:
- Sign up for the class
- Ideally have a development / sandbox database available for reproducing the problem scenarios, troubleshooting and testing out the advanced Oracle troubleshooting 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 (but no more 9i, please ;-)
- Print out the PDFs with slides (if you like them on paper) – you will receive the slides one week before the seminar starts
- Download my scripts (I do update the .zip file from time to time)
- A week before the seminar day (I’ll email the time in advance) I’ll host a “test event” where you can just log on to GotoMeeting and make sure that the audio/video is ok.
- On the seminar days, attend the seminar via the GotoMeeting link (I will send out the GotoMeeting link a week in advance too)
Seminar Table of Contents and details
All of the classes below have been greatly updated – and the Exadata performance class is completely new – and probably unique.
- Advanced Oracle Troubleshooting v2.1
- Changes since v2.0:
- Major updates to the fundamentals and systematic troubleshooting approach sections, notably a section on getting the most out of the powerful Oracle ASH (or v$session-sampling based techniques if you don’t have diagnostics pack licenses)
- Most topics have a list of “usual suspects”, commonly hit bugs and problems in them for quick checks, but we will still spend majority of the time learning the systematic approach for troubleshooting problems even if they’ve been never seen before
- I’ve removed some less practical internals information to not run overtime and will make it available online
- View the TOC here
- Changes since v2.0:
- Advanced Oracle SQL Tuning v2.0
- Changes since v1.0:
- The general course structure remains the same, but I have done major updates to the contents of the 4 major focus areas of this class
- Understanding SQL Plan Execution: more focus on spotting CBO’s estimated row-count (cardinality) error-based problem diagnosis techniques
- Controlling Execution Plans: I have removed some old and too detailed info and will be spending some more time on explaining query transformations – and common situations where best results would be gotten by manually rewriting the query text
- Optimizing Data Access: Better scripts for automatically detecting index use inefficiency and indexing opportunities
- Helping the CBO to Optimize Better: New (and more useful) examples of reading a CBO trace
- View the TOC here
- Changes since v1.0:
- Advanced Oracle Exadata Performance: Troubleshooting and Optimization
- This is a completely new seminar, focused entirely on Exadata Performance topics – suitable for developers and DBAs
- It is put together based on my Exadata performance work all the way from Exadata V1, research and book-writing
- It is not an “introduction to Exadata” class, you should already know what Exadata is and its basic concepts
- Following the style of my other classes, this unique seminar also consists of original material, new scripts and tools written by me and offers a systematic approach to drilling deep into Exadata performance issues
- The seminar demos and examples will be ran on real Exadatas (a V2 and X2-2 in Enkitec’s data center)
- View the TOC here
You can check the schedule of other Enkitec classes here:
One 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:
- With the exception of the Advanced Exadata Performance classes, all other 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 )
- 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: education@enkitec.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!” :-)
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.
Tanel,
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?
Regards,
Ted Yoshihara
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
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 !
Hi,
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!
Thanks,
Simon
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!
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
Tanel,
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!
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.
Tanel,
You should consider doing online virtual classes for people who cannot travel so easily :-)
@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).
Hi Tanel,
It was nice meeting with you with the free seminar conducted at SMU. Learned a lot from it.
Well recommended!!
Regards,
Onin
@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 :-)
Thank you so much for sharing this precious information with us.
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.
Tanel,
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
hi Tanel,
do you have any published book or are planning to do so?
Thanks and Regards,
Sam
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.