ORACLE数库性能优化与调整概述(讲).docVIP

数据库性能优化与调整概述 Ref：Oracle8i Designing and Tuning for Performance 业务逻辑层（业务规则的严密性和简洁性） 系统设计层（总体和详细设计结构合理性、关系严密性和流程简洁性） 代码设计层（表示层、业务逻辑层、数据库层代码逻辑严密性、代码可读性） 数据库实现与调整层（根据服务器的软硬件资源合理设置数据库环境、分布数据的存储、配置服务进程、索引、缓存和内存等） Understanding Oracle Performance Tuning What Is Performance Tuning? Who Tunes? Setting Performance Targets Setting User Expectations Evaluating Performance What Is Performance Tuning? Trade-offs Between Response Time and Throughput Critical Resources Adjustments to Relieve Problems Trade-offs Between Response Time and Throughput Goals depend on the application(Throughput:OLTP;Response tim