I have uploaded the presentations I did at Hotsos Symposium this week to here
Both of my presentations are in that file, along with my TPT scripts, Snapper, Sesspack and PerfSheet.
I delivered two presentations:
-
Advanced Oracle Troubleshooting: No magic is needed, systematic approach will do
-
Oracle Performance Trending and Charting using Sesspack and Excel
If you have any follow up questions or have trouble getting any of my scripts running, please write it to the comments section of this blog.
Very impressive and practical. Showed your true value as systematic Oracle performance analysit. I’d really like to join your presentation sometime.
Tanel, by sharing all the work you did with Perfsheet, you may end up saving me 10+ hrs per month! I spend much of my DBA work in presenting various levels of associates with graphs explaining activity, which up until now was based on canned SQL scripts and cut/paste into Excel for graphing. I can’t wait to start using Perfsheet and setting it up, with privs on stats data, for others as well.
Thank you!
Tanel,
Thanks for a Wonderful, Informative presentation!
Shiva
Don’t you plan to write a book entitled with : Advanced Oracle Troubleshooting, Systematic Approach …
Great presentation.
Thanks for posting files here – as I’m not able to access anything from SYM08 on the Hotsos website – permissions error.
I will try to assist with the excel VBA stuff. :)
Very practical and informative presentation in hotsos 2008, I really enjoyed your session.
Thank you
Bilal
Great presentation Tanel!
I’m interested in using the persheet for queries. I do have a question though. How do I defined new data source?
Thanks
Hi Mayur,
Just type a different TNS alias name into the data source box. Whatever you can tnsping from your PC, you can use in the data source box.
On right hand there’s a list called My Data Sources, you can add your frequently used db names there, so you can select those from list box later on, but i usually prefer just to type the TNS alias in
Hi Tanel,
I have setup the sesspack_0.05 and able to get snapshots, but when I run the sr sid,program 1 2 I get prompted for _tptmode? What do I obtain the _tptmode value?
Thanks,
Bilal
Hi Bilal,
Set the _tptmode to “normal”. I added this variable for generating slightly different output for html.
I recommend checking out the init.sql in my TPT scripts, I call this through login.sql normally, it sets up some more custom variables.
PerfSheet works great for me – as is.
I emailed you a PerfSheet update of Queries page including VBA. I will assist with more PerfSheet improvements!
Hotsos fixed my account for SYM08 download. But, thanks again for posting your files.
Enjoy.
Thanks Mike, I’ll check your updates out.
Tanel,
Excellent as usual.
You mention an os_explain script, but I don’t see any reference to it and cannot find anything about it. Would you please clue us in?
Thanks,
Rich
Rich, I’ll do my next blog post on os_explain!