Advanced Troubleshooting Seminar is technically unique, which covers in details many aspects of the performance trouble-shooting and offers the methodological approach to deal with the real issues when the performance problems appear.
The seminar material contains tremendous amounts of scripts that can be used on any environment to troubleshoot the most complicated performance problems
Amazing seminar !!! Thank you Tanel !!!

Tanel,

I attended Understanding Oracle execution plans seminar at Denver, CO. The way you dissected the Oracle execution plan to explain in detail to the audiences is very unique. The content is technically rich and really useful for DBA’s at all levels. I really appreciate your generosity for sharing all the scripts.

Thanks
Venkata Giri

Tanel,
Great job, I like your systematic approach for troubleshooting, thanks a lot for your script too, but when do you come in Italy for your seminar?

Great presentation Tanel at RMOUG 2009! Keep up the good work!
Thanks, Muru

Tanel,

I had the privilege of attending both of your sessions at RMOUG. Well done.

Thank you for a great presentation on Advanced Oracle Troubleshooting; the tools you’ve shared are quite valuable.

The session on SQL/Execution plans (not explain plans) was great.

Cheers.

Thank you Tanel, amazing and great presentation that you share.

I agree with your comments about explain plan, but dbms_xplan.display_cursor() requires access to the V$SESSION, V$SQL_PLAN and some other V$ tables. Unfortunately, if I don’t want to grant “select any dictionary” to public, I still have to use an old and battle tested EXPLAIN PLAN FOR.

thanks dear , i learn lot by you…

Brilliant seminar in Melbourne. Absolutely love your approach to troubleshooting. Learnt lots of cool stuff but more importantly learnt a methodology. ‘As they say …Give a man a fish and he will eat for a day. Teach a man to fish and he will feed himself for years !!” Thanks for teaching me to fish Tanel.
Kevin.

Hi Tanel,

I enjoyed your seminar in NL very much. Are you going to post the AOT logs of that seminar as well?

BTW I found a small error in your TPT_public.zip (snapper v1.10). Maybe that is to test if people are actually using it on Oracle v10?

Regards,

Patrick

It wasn’t a big error but you defined a variable called _IF_ORA_10_OR_HIGHER but then you use _IF_ORA10_OR_HIGHER in the rest of the script. That’s all.

Take your time with the logs, I was just wondering if they were comming and now I know. :-)

Tanel!

Thanks for great presentation at Miracle’s Mayday 2009 seminar.
It is bitty, that I didn’t get opportunity to change some ideas after seminar..Mayby next time..

Happy trails!
Ari

Hi Tanel,

thanks for comming to Madrid and for the superb seminar. Also, thanks for the blog and the scripts!

Stano.

Hey Tanel,

I closely follow your blogs and I must say , your presentation has all together changed my views towards oracle internals.Are you planning to visit India any time ?

Cheers,
Santosh

Btw, I have a small query about v$osstat, would you mind if I post that here ?

Thanks,
Santosh

Hi Tanel

Thanks for the great seminar in Ballerup, Denmark. You’re certainly the master as your tag said but I was slightly disappointed that so much time was spent on basic stuff that there wasn’t much time for the juicy stuff. I’d like to suggest that you extend the seminar with at least one day and spend less time on stuff that the attendants are supposed to know already.

Now, don’t get me wrong – I’ll be looking to join more Tanel Poder classes in the future. :o)

I would also like to suggest that you put a new class together – containing your clever sqlplus tricks and hands-on training in how to create a perfsheet like your own.

Best regards
Ivan

I’ll send a reoccurring mail to my manager every day asking for go-ahead on both until he approves. :o)

Cheers
Ivan

Hey Tanel,

Here is my query regarding v$OSSTAT.
I am working on a design where an application server needs current CPU consumption on database server.Because of business constraints, I can not setup passwordless ssh between 2 boxes.So I thought of getting the data from v$OSSTAT view. Being cumulative data in v$osstat for busy_time, idle_time,user_time metrics , I am finding the difference between these metrics over a period of time like 5 seconds and then % user cpu consumption =
( user_time/( busy_time+idle_time+iowait_time+nice_time).

But sometimes I dont get the right data when compared with mpstat/TOP output.Do you think I am doing something wrong?

Thanks,
Santosh

I’d be very interested in the 5 day class as well. Thanks for putting all of this great information out there Tanel!

Hey Tanel,

Sorry was busy with shared pool fragmentation problem in one of the production boxes , it was very interesting kind of problem :

Its running on 10.2.0.2 on RHEL 3 ,hitting more often ora-04031 errors, when I checked the subpool configuration, came across weired thing :

SQL> select KGHLUIDX,INST_ID,INDX,ADDR,KGHLUNFU from x$kghlu;

KGHLUIDX INST_ID INDX ADDR KGHLUNFU
———- ———- ———- —————- ———-
4 1 0 0000002A973A6ED8 0
3 1 1 0000002A973A68A8 0
2 1 2 0000002A973A7F08 435
1 1 3 0000002A973A78D8 0

All the failures were in subpool 2.After walking through trace files , concluded that oracle never switches the subpools even if there free large enough memory chunks in other subpools to satisfy the request.As we are running with low memory on the box , decided to reduce the number of subpools from 4 to 2 , going to do that very soon.

Things which I didnt understand :

1) How the distribution of sql stmts happens in these subpool , is it kind of hashing algorithm?
2) If thats the case, then how can we find that in the database ?

Thanks,
Santosh

Hi Tanel,

Thanks a lot for considering my questions valid enough to work on them.

Eagerly waiting for your second post… :)

Thanks a ton,
Santosh

After attending the training course in Denver last week, I was on-call @ work for the rest of the week. During that time, I used my new troubleshooting skills twice.

Thanks Tanel!

Gary Olsen – Salt Lake City, UT

One was related related to a problem that was showing up in the alert log every morning at around 5am. Rather than taking the ‘old’ approach of trying to look around the DB (early) in the morning, I just set an event to have the SQL dumped the next time the error condition occurred. I passed that along to the development database engineer so they could investigate further. I followed the systematic approach. (Was didn’t have to get up @ 5am in the morning!)

Gary

I heard about you from a friend who had attended your seminar before. My friend said your seminar is very helpful for DBAs.
And I found the scripts you privoded here is also very helpful.
Thanks a lot.

Hi Tanel,

Just have a question, is there a way to identify a process that causes certain indexes to get corrupted, All I do know is that my client is running SAS jobs which calls stored proc’s, but not sure which process is causing the pains.

HI , Veera Boda , having 6 + years exp as Oracle Apps DBA ( Oracle E – Business Suite and oracle Database ) . I did not work much on performance issues. I would like learn more about this topic .

1.Can i know the training schedule ( I would like have online )

2. Can you advise books /web sites which gives more fundamentals and performance tuning information .