湖南电力营销系统数据库性能优化研究

通过对国网湖南省电力公司营销系统0racle数据库运行性能进行长期跟踪和深入分析，结合国内外数据库性能优化研究的最新成果，探索出适合湖南电力营销系统运行实际的数据库优化方法。该方法包含索引优化、磁盘I／O优化以及SQL语句优化3个方面，涵盖了营销系统当前存在的主要性能瓶颈。采用此方法对营销系统数据库进行优化后，CPU使用率、磁盘I／O吞吐量以及SQL语句平均执行时间等数据库关键性能指标均提升30％以上。

Research on Database Performance Optimization for Hunan Power Marketing System

By long-time trace and deep analysis of runtime performance of the Oracle database used in Hunan electric power corporation, and taking the new domestic and overseas research achievements in the field of database perfornlance optimization, this paper explores a database optimization method applicable to the power marketing system. The method carries out optimizations in three aspects of indexes, disk I/O, and SQL statements, which covers the existing main performance bottleneck of the marketing system. The testing results show that the performance of database has a less than 30% improvement in terms of CPU utilization rate, the throughput of DISK I/O, and the average execution time of SQL statements.