摘要
由于硬件、操作系统、应用程序以及参数等方面的原因,数据库的性能在运行一段时间后都会下降。对数据库系统性能进行优化,是保证其正常运行的重要手段。文章从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.
