I am always looking for more information about Oracle's statspack and have come across some very good links (some I have read, some I have not)....
Advanced Tuning with Statspack | This article lists and describes the top 10 most common wait events and some possible resolutions. One thing to keep in mind when reading this article is that these are the "most common wait events" and you should look at look at the exhibited behaviors of the system as well as these events. |
How To Integrate Statspack with EM 10G | This is a good Metalink article on how to integrate your statspack data into the EM in 10g. If you don't have a Metalink account, you need one. |
Gathering a StatsPack snapshot | This note is intended to provide information about the steps required to take a StatsPack snapshot of current database performance levels and how to capture different granularities of performance information at both the instance and session levels. This note also discusses how to automate the process of capturing a StatsPack snapshot. These snapshots can be used as a starting or ending point for generating a performance summary. |
FAQ- Statspack Complete Reference | This FAQ is mostly for Oracle releases prior to 10g. It contains lots useful links to more Metalink related articles. |
No comments:
Post a Comment