I had the privilege last month of hearing Rich Niemiec of TUSC speak about performance tuning at the Dallas Oracle Users Group. One tip he gave us was just too good not to pass on, so here it is: STATSPACK is still alive and well in Oracle 10g.
A lot of the excitement about performance tuning in Oracle 10g is about the new Automated Workload Repository (AWR) feature, and the proactive monitoring it provides through Automatic Database Diagnostic Monitor (ADDM). It is widely reported as the replacement for STATSPACK -- and it is. It does more, and it is the future of Oracle tuning, according to Mr. Niemiec.
But, he said, don't ignore STATSPACK. Not only is it still present in Oracle 10g for legacy reasons, but it was updated to include many of the new measurements captured in the AWR. While you need additional licenses for Diagnostics Pack and Tuning Pack to fully use AWR, STATSPACK is included in the price of Oracle.
Here are a few of the things that Mr. Niemiec mentioned as being new in STATSPACK in Oracle 10g:
The procedure for running STATSPACK hasn't changed significantly, though there are a few new options, such as setting the extent sizes of the tables built during the spcreate script.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7364032/viewspace-17471/，如需转载，请注明出处，否则将追究法律责任。