数据库的性能优化直接影响到整个数据库应用系统的有效高效运行。讨论了ORACLE数据库性能优化的策略和方法,ORACLE 10G数据库在性能优化调整方面的新特性:自动数据库诊断监控器ADDM、应用的端到端追踪、自动优化统计信息收集以及自动共享内存管理等,并就如何利用这些新特性来优化调整ORACLE 10G数据库进行了研究。合理利用这些新特性可使10G数据库的优化调整更具有实效性。

Research on Oracle 10G Database Performance OptimizationGUO Min,GUO Jing(Network Information Center,Wuhan University of Technology,Wuhan 430070,China)Database performance optimization influences the effective operation of the entire database application directly.This paper discussed the policy and method of oracle database performance optimization,and updated features for performance optimization in Oracle 10G,such as the Automatic Database Diagnostic Monitor(ADDM),application end to end tracing,automatic optimizer statistics collection and automatic shared memory management.How to use these new features to tune Oracle 10G database was studied.These rationally utilized new features may bring much actual effect in 10G database performance optimization and tuning process.Oracle 10G;performance optimization;ADDM