Using Perfsheet and TPT scripts for solving real life performance problems

Karl Arao has written a nice blog entry where he used also some of my tools for visualizing and understanding performance of a RAC cluster suddenly gone slow. He presents a systematic approach he used for gathering evidence and also hopefully you notice that having the ability to easily visualize performance data (with PerfSheet for example) can be very helpful and time saving when troubleshooting non-trivial problems.

Check his blog entry out here:

This entry was posted in Cool stuff, Oracle and tagged , . Bookmark the permalink.

12 Responses to Using Perfsheet and TPT scripts for solving real life performance problems

  1. Dion Cho says:

    Wow, it’s very interesting and practical.

  2. Karl Arao says:

    Hi Tanel,

    Thanks for referring my post on your blog :)

  3. Senthil Murugan says:

    Hi Tanel,

    Your site is really fantastic and do you are doing a great job by contributing to oracle community.

    Can you please tell us how to tune a db file scattered wait event in general.i was reading Doc ID: 34558.1 reg db_file_scattered read.
    we have a query which is poorly performing in a production instance, but the same is working fine in development instance.we had partitioned few mail tables in both prod and developement instance , after this we are having this issue.v$session_wait is showing the even “db file scattered read” and datafile and block information.I am not sure how to go ahead further to resolve this issue.Please give us some tips on how to resolve this issue :)

    — regards,

  4. Haris says:

    Hi Tanel

    Your site is full of Oracle information and it’s fantastic.
    I’d like to get your advice on perfsheet. I still can’t get it work for me. My DB server in on unix os and located remotely. How can i get the perfsheet to work?

    Please help.

    Thank you

  5. Tanel Poder says:


    What error message do you see?
    What excel version do you use?

  6. Haris says:

    Hi Tanel

    Thanks for reply.

    Excel version= Excel 2007
    No error messages occur. When i click “Show me!” button, it became editable, I can edit/view the coding in Microsoft VB.

    Information that i keyed in.
    Data Source= PRISMD
    Which Instance=PRISMD
    Others default.

    Connect Details
    Data Source PRISMD
    Username dbamaint
    Password xxxxxxxxx

    Report Details
    Which Instance PRISMD
    Which Query ASH Online last 60 mins
    Which View
    not used currently

    Time Details
    From Date sysdate – 1
    To Date sysdate
    From Snapshot
    To Snapshot

    Additional Filters 1=1
    Reuse Last Sheet TRUE

    Thanks In Advance(TIA)


  7. Tanel Poder says:

    You are in “design mode” in excel, which allows to change the buttons etc. You need to exit design mode, there should Developer->Controls->Design mode button to toggle this.

  8. Haris says:

    Hi Tanel

    Thanks for your advice.

    Now when i click “Show me!” button it seems to work but receive this error message.

    “Error-2147217843 [Microsoft][ODBC driver for Oracle][Oracle]ORA-01017: invalid username/password; logon denied”

    “Run-time error ‘9’:

    Subscript out of range”

    Please advice.



  9. Tanel Poder says:

    See the error message. It says: “ORA-01017: invalid username/password; logon denied”

    So, your username/password for this database is wrong.

  10. Haris says:

    Hi Tanel

    Correct, actually the password for the username has been changed by someone without my knowledge. Now it works perfectly. Now i need to understand the output.

    Thank you for your help.


  11. Tanel Poder says:

    Good to hear that!

    By the way, the main aim of PerfSheet is making visualizing any SQL resultset easy. So, you are free to add your queries there which make most sense for your tasks.

  12. Haris says:

    Thanks Tanel :)

Leave a Reply

Your email address will not be published. Required fields are marked *