Oracle数据库的性能优化方法研究  

Oracle Database Performance Optimization Method Research

作　　者：罗瑞明[1] 

机构地区：[1]深圳技师学院,深圳518000

出　　处：《信息安全与技术》2012年第5期65-67,共3页

摘　　要：由于硬件、操作系统、应用程序以及参数等方面的原因,数据库的性能在运行一段时间后都会下降。对数据库系统性能进行优化,是保证其正常运行的重要手段。文章从SQL语句、CPU调整、磁盘I/O、内存分配和系统网络几个方面出发,对Oracle数据库进行了深入分析,并提出性能优化策略,从而为保障Oracle数据库系统高效地运行,提供具有实际应用价值的参考。Due to the hardware, operating system, application program and parameters and other reasons, the performance of the database after running for a period of time will decrease. The database system performance optimization is a important means to guarantee their normal operation. This article from the SQL statement, CPU adjustment, disk I / O, memory allocation and network system from several aspects, for the Oracle database to carry on the thorough analysis, and put forward the optimization strategies to ensure efficient operation of Oracle database system and provide useful reference.

关 键 词：ORACLE数据库 性能 影响因素 优化方法 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]