| Oracle数据库系统优化调整 |
| |
| 作者姓名： | 刘超 张明安 |
| |
| 作者单位： | 中国人民解放军,91655 |
| |
| 摘 要： | 在过去的几十年中,Oracle数据库已经逐渐成为世界上最为广泛的大型数据库管理系统。而数据库DBA的重要工作就是要确保利用Oracle的强大特性来提高企业的生产力。其中最有效的方法就是通过Oracle调优,它有大量的调整参数和技术来改进Oracle数据库的性能。文章从数据库内存参数调整、索引技术、数据库分区以及SQL语句的优化等四个方面来研究Oracle数据库的性能调整。
|
| 关 键 词： | 内存参数 数据库索引 分区技术 优化SQL语句 |
Research on Optimization of Oracle Database |
| |
| Affiliation: | Liu Chao Zhang Ming ＇an (The Chinese PLA 91655 Troops Beijing 100036) |
| |
| Abstract: | In the past few decades, Oracle database has become the world＇s large database management system. The important work of DBA is to ensure that the use of the powerful features of Oracle and improve their productivity. One of the most ef ective ways is through the Oracle tuning. Certainly, the performance of Oracle database can be improved through a large number of parameters and technology. The article explains the things from Database memory parameter adjustment,index technology,database partition, and SQL statement optimization etc onthe performance optimization of Oracle database. |
| |
| Keywords: | memory parameter database index partition sql optimization |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
