Oracle数据库的性能优化方法研究 |
| |
作者姓名: | 罗瑞明 |
| |
作者单位: | 深圳技师学院,深圳,518000 |
| |
摘 要: | 由于硬件、操作系统、应用程序以及参数等方面的原因,数据库的性能在运行一段时间后都会下降。对数据库系统性能进行优化,是保证其正常运行的重要手段。文章从SQL语句、CPU调整、磁盘I/O、内存分配和系统网络几个方面出发,对Oracle数据库进行了深入分析,并提出性能优化策略,从而为保障Oracle数据库系统高效地运行,提供具有实际应用价值的参考。
|
关 键 词: | Oracle数据库 性能 影响因素 优化方法 |
Oracle Database Performance Optimization Method Research |
| |
Authors: | Luo Rui-ming |
| |
Affiliation: | Luo Rui-ming (ShenZhen Technician College ShenZhen 518000) |
| |
Abstract: | 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. |
| |
Keywords: | Oracle database performance influencing factors optimization method |
本文献已被 CNKI 维普 万方数据 等数据库收录! |
|