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?
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 !
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!
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.
@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).
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 :-)
i rarely use the old TNS connect syntax with sqlplus anymore. I'm used to sqlplus user/pass@server:port/service syntax now!12:48:22 PM September 07, 2010from Seesmic Web
Trackbacks
Comments
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 :-)