Using Perfsheet and TPT scripts for solving real life performance problems
June 9th, 2009
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:
http://karlarao.wordpress.com/2009/06/07/diagnosing-and-resolving-gc-block-lost/
Trackbacks
Comments
Wow, it’s very interesting and practical.
Hi Tanel,
Thanks for referring my post on your blog :)
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,
senthil
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
Haris.
Haris,
What error message do you see?
What excel version do you use?
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
Username/Password=dbamaint/xxxxxxxx
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
Advanced
Additional Filters 1=1
Reuse Last Sheet TRUE
Thanks In Advance(TIA)
-Haris
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.
http://www.office-kit.com/excel_invoice_manager/customizing_invoice_workbook.htm#design_mode
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.
TIA
-Haris
See the error message. It says: “ORA-01017: invalid username/password; logon denied”
So, your username/password for this database is wrong.
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.
Regards
-Haris
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.
Thanks Tanel :)