数据库性能调优中的问题和对策分析——以ORACLE数据库为例  

Problems and Countermeasures Analysis of Database Performance Tuning——Taking the ORACLE Database as an Example

作　　者：黄一飞[1] 李鹤[1] Huang Yifei;Li He(Dalian University of Finance and Economics,Dalian Liaoning 116600,China)

机构地区：[1]大连财经学院,辽宁大连116600

出　　处：《信息与电脑》2017年第2期171-173,共3页Information & Computer

摘　　要：21世纪是信息时代,计算机产业发展迅猛,数据库是其中应用最为广泛的技术之一。但是,在数据库的使用过程中,经常会出现数据库负载过高、系统运行效率降低和数据库响应迟缓等问题,影响了数据库的性能,无法满足用户的使用需求。笔者以ORACLE数据库为例,分析了数据库运行中经常出现的影响数据库性能的问题,并给出了相应的调优对策。The 21st century is the information age,computer industry is develop rapidly,the database is one of the most widely used technology.However,in the process of using the database,the problems that too high database load,reduced efficiency of the system operating and slow database response often occur,which affect the performance of the database and can not meet the needs of users.The author takes ORACLE database as an example,analyzes problems that affect database performance often occur in the operation of the database,and gives the corresponding tuning strategy.

关 键 词：数据库性能 调优 ORACLE 

分 类 号：TP311.138[自动化与计算机技术—计算机软件与理论]