The latest version of my TPT scripts are downloadable from the link below (TPT means Tanel Poder’s Troubleshooting (or tuning) scripts ;)
http://www.tanelpoder.com/files/TPT_public.zip
In the zip file there are over 300 Oracle sql scripts which I use for my everyday work. Also the demo scripts I show at Advanced Oracle Troubleshooting seminar are in there as well (in aot subdirectory).
To my seminar attendees in New York this week: I had a typo in the TPT script download link, the link above is the correct one!




Excellent stuff. Thanks for sharing it.
I downloaded this after attending the first day of your seminar itself. I started using sqlplus from command prompt only after downloading your scripts and how easy it is to recall the previous sql. I did not get your email-id but I gave my card, can you please send me your email-id.
Thanks
Sridhar
Tanel, thanks for spreading the love.
yes. Thanks a lot!!!
It’s much help for a Chinese junior Oracle DBA…….
^_!
failed to download it, http 404 error. pls notify me once you fix it or email me a copy . Many thanks.