首页 | 本学科首页   官方微博 | 高级检索  
     检索      

Oracle数据库优化探究
引用本文:巢子杰.Oracle数据库优化探究[J].人天科学研究,2010(2):142-144.
作者姓名:巢子杰
作者单位:南京晓庄学院数学与信息技术学院,江苏南京211171
摘    要:Oracle是目前使用最为广泛的大型数据库管理系统,提高Oracle数据库系统的运行效率,是整个计算机信息系统高效运转的前提和保证。影响Oracle数据库应用系统性能的因素,既有软件方面的因素,也有数据运行的硬件环境、网络环境、数据库管理和维护方面的因素等。通过对其优化可以解决数据库系统运行过程中性能突降等问题,以保证系统运行的优良性能。以数据库性能优化的基本原则为基础,从5个方面总结了Oracle数据库的优化调整。

关 键 词:Oracle数据库  系统优化  SGA  行链接

Research on the Optimization of Oracle Database
Abstract:Oracle is currently the most widely used large-scale database management systems, oracle database systems to improve operat- ing efficiency, it is the computer information systems and efficient operation of the prerequisite and guarantee.there are many factors affect the performance of Oracle oatabase application system,both the software aspects,but also including data to run the hardware environ- ment, network environment, database management and maintenance of the factors, so the performance optimization is directly related to the whole system run more efficiently.In this paper,the basic principles of database performance optimization based on analysis of oracle's system structure and working mechanism, summarized in five aspects of the optimal adjustment of the oracle database.
Keywords:Oracle Database  System Optimization  SGA  Bank Link
本文献已被 维普 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号