利用statspack对“军卫一号”进行数据库性能诊断一例

A Case of Oracle Performance Diagnosing by Using Statspack

Statspack是oracle带的一个强大并且免费的性能分析工具,通过利用Statspack对我院数据库进行为期一周的统计分析,确定了Oracle数据库的瓶颈所在,制定了相应的调优方案,从而显著改善了数据库性能。

Statspack is a powerful and free diagnostic tool to oracle performance. After running Statspack for a period of one week, we find our performance problems and then make a set of tuning scheme by analyzing Statspack reports. Finally, our oracle performance was greately improved.