Tanel Poder’s blog: Core IT for Geeks and Pros

March 6, 2008

Hotsos Symposium 2008 presentations and files

Filed under: Administration, Cool stuff, Internals, Oracle, Performance, Tools, Troubleshooting — Tanel Poder @ 4:48 am

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.

Bookmark and Share

17 Comments »

  1. [...] to use it when it becomes available on his web-site. Update: Tanel put the material on his web-site here. Since I went to Tanel’s presentation I missed the first half of Tapio Lahdenmäki’s [...]

    Pingback by Hotsos Symposium 2008 — Still On — March 6, 2008 @ 5:12 am

  2. Very impressive and practical. Showed your true value as systematic Oracle performance analysit. I’d really like to join your presentation sometime.

    Comment by Dion Cho — March 6, 2008 @ 9:42 am

  3. 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!

    Comment by Dave Herring — March 6, 2008 @ 10:58 am

  4. Tanel,
    Thanks for a Wonderful, Informative presentation!

    Shiva

    Comment by Shiva Raghunath — March 7, 2008 @ 7:44 am

  5. Don’t you plan to write a book entitled with : Advanced Oracle Troubleshooting, Systematic Approach …

    Comment by Rudi — March 7, 2008 @ 1:42 pm

  6. 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. :)

    Comment by Mike — March 8, 2008 @ 8:27 am

  7. [...] March 9, 2008 — Bas I checked out some Hotsos 2008 downloadable files here, in one PDF I found a URL to Tim Gorman’s Statspack delta views.  It’s a bit similar [...]

    Pingback by More statspack queries « Phat4Oracle — March 9, 2008 @ 4:00 pm

  8. Very practical and informative presentation in hotsos 2008, I really enjoyed your session.

    Thank you

    Bilal

    Comment by Bilal Mahmud — March 10, 2008 @ 9:06 am

  9. 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

    Comment by Mayur — March 14, 2008 @ 4:23 am

  10. 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

    Comment by tanelp — March 14, 2008 @ 7:13 pm

  11. 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

    Comment by Bilal — March 14, 2008 @ 11:59 pm

  12. [...] Poder has made available his highly-rated presentations and files from the Hotsos Symposium, which recently came to a [...]

    Pingback by Log Buffer #88: a Carnival of the Vanities for DBAs — March 15, 2008 @ 12:56 am

  13. 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.

    Comment by tanelp — March 15, 2008 @ 4:00 pm

  14. 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.

    Comment by Mike — March 27, 2008 @ 9:54 am

  15. Thanks Mike, I’ll check your updates out.

    Comment by tanelp — March 27, 2008 @ 9:11 pm

  16. 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

    Comment by Richa — April 2, 2008 @ 12:34 am

  17. Rich, I’ll do my next blog post on os_explain!

    Comment by tanelp — April 10, 2008 @ 1:22 am

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress