| Oracle数据库的性能调整与优化方法探析 |
| |
| 引用本文： | 王雷,曾蕴波,王璐. Oracle数据库的性能调整与优化方法探析[J]. 航天器工程, 2008, 17(6): 129-133 |
| |
| 作者姓名： | 王雷 曾蕴波 王璐 |
| |
| 作者单位： | 北京空间飞行器总体设计部,北京,100094;北京空间飞行器总体设计部,北京,100094;北京空间飞行器总体设计部,北京,100094 |
| |
| 基金项目： | 中国空间技术研究院自主研发项目 |
| |
| 摘 要： | Oracle数据库系统性能与多方面因素有关，除操作系统、服务器、网络性能外，应用程序、数据存储结构等也会影响其性能。文章对Oracle数据库的优化调整技术进行了探讨，从数据库运行环境优化、数据库参数优化和应用优化三个层面介绍了Oracle数据库优化的方法，并通过实验验证表明：优化后数据库的性能较原数据库性能提高20％左右。
|
| 关 键 词： | Oracle 数据库 性能调整 优化 |
Analysis of Oracle Database Performance Refining and Optimizing Strategies |
| |
| WANG Lei,ZENG Yunbo,WANG LU. Analysis of Oracle Database Performance Refining and Optimizing Strategies[J]. Spacecraft Engineering, 2008, 17(6): 129-133 |
| |
| Authors: | WANG Lei ZENG Yunbo WANG LU |
| |
| Affiliation: | (Beijing Institute of Spacecraft System Engineering, Beijing 100094, China) |
| |
| Abstract: | The system performance of Oracle databace relates not only to operation system, server and network performance but also to application program and data storage structure. This paper explores the optimization and adjustment techniques of Oracle database and makes an intensive study of the optimization methods at three different levels environment, database parameter and application. The experimental results show that Oracle database performance is enhanced about 20% compared with the original database. |
| |
| Keywords: | Oracle performance refining optimizing strategies |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
