|Performance Tuning Enhancements in Oracle Database 10g - Oracle 10g includes many performance tuning enhancements which take some of the mystery out of being a DBA.|
email@example.com said...Great article.
It would be so much better if you offered a printable version
I already do. When you are on the article, a "Printer Friendly" link appears in the left hand toolbar.
K P ratnaker said...Good article,
This article is very useful for us. We will use this article in our database.
Very Good Article Tim.
Peres said...Very good article, i like this site very much.
sorry for being mr. point out the obvious, but:
-- Display time waited for each wait class.
GROUP BY a.wait_class;
Thanks for the heads-up. I've corrected it now. Don't ever be feel ebarressed about helping, even if it is something simple like this. It's much appreciated.
Yoel said...just wanna point out an error in the article. i hope this helps.
trcsess output=client.trc client_id=my_id db10g_ora_198.trc db10g_ora_206.trc
the parameter should be 'clientid' not 'client_id'
Thank you for the article.
Philippe said...Hi Tim,
Is all this available on standard one without the payable options?
I think everything in the "Automatic Performance Diagnostic and Tuning Features" section is part of the Diagnostics and Tuning pack which is an Enterprise Edition option.
The rest is available in Standard Edition... I think.
abhishek said...Nice article.
Lisa Tansey said...Your articles are all great! Super helpful! Better than most other doc out there. Where do I send my check? :)
Chris said...Hi Tim,
thank you for year great articles, very impressive work! I have a question: I cannot find the view V$SYSTEM_WAIT_HISTORY in the oracle manuals, is this a typing error ?
Sorry, it was a typo. It should have been V$SESSION_WAIT_HISTORY. I've corrected the typo now. Thanks for the heads-up.