【摘要】 Oracle数据库作为安徽电信应用最广的数据库产品,随着数据库系统的不间断运行,大量数据的沉淀和更新,导致Oracle数据库系统的性能下降。要保证数据库平稳、高效的运行,就需要及时有效地进行数据库系统性能优化工作。分析了Oracle提供的自动工作负载信息库(AWR)的快照信息,分析安徽电信Oracle数据库的性能瓶颈,并给出具体的优化建议,以保证电信Oracle数据库平稳高效率地工作。更多还原

【Abstract】 Oracle Database is the most widely used database product by Anhui Telecommunications.With the continuous of the database system,the accumulation and update of a large amount of data,it resulte in the performance degradation of the oracle database system.To ensure a smooth and efficient operation of the database,it is necessary to perform database system performance optimization in a timely and effective manner.It analyzed the snapshot information in this study of the automatic workload information base(AWR) provided by Oracle to find out the performance bottleneck of the telecom oracle database,and gave specific optimization suggestions to ensure the smooth and efficient work of the telecom oracle database.更多还原