Oracle数据库性能调整优化  

The adjustment and optimization of the oracle database performance

作　　者：仇道霞[1] 陆伟[1] 侯晓辉[1] 

机构地区：[1]山东省烟草公司信息中心,山东济南250101

出　　处：《山东轻工业学院学报（自然科学版）》2010年第3期52-54,共3页Journal of Shandong Polytechnic University

摘　　要：数据库应用越来越广泛,数据量越来越大,数据处理越来越复杂,对数据库的性能要求也越来越高。本文介绍了数据库性能优化目标,分析了影响数据库性能的因素,对SQL查询语句的优化、Oracle内在分配以及磁盘I/O等数据库优化技术进行了详细的介绍。Nowadays,database is widely used,and because the data volume is much bigger and data process is much more complex than before,the requirement of the database performance is getting higher.This paper first introduces the targets of performance optimization of database,and analyzes factors of performance optimizing of database system.It elaborates on some optimization technologies such as optimization of SQL query statement,memory allocation and tuning of Oracle,and disc I/O,etc.

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

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