| Oracle9i 性能调整 |
Exam 1Z0-033：
Oracle9i: Database Performance Tuning |
 |
| |
| 预备知识 |
Introduction to Oracle9i: SQL
Oracle9i Database Administration Fundamentals I
Oracle9i Database Administration Fundamentals II |
| |
| 考试简介 |
| 本课程是在Oracle9i Release 2 的基础上讲授的。本课程将向学员介绍从一开始就确保良好数据库设计的重要性，以及用于优化Oracle9i
数据库的方法。重点在于数据库和实例优化，而不是针对具体的操作系统性能问题。学员将通过实际优化一个Oracle
数据库来获得实践经验。 |
|
|
| 利用一些可供使用的Oracle 工具 – 如Oracle Enterprise Manager (配备Diagnostics
Packs 和Tuning Packs) –在实际管理一个Oracle 数据库的过程中认、排除、和解决一些常见的与性能相关的问题。课程包括一次互动讲座，将为学员提供实际世界的经验，包括问题诊断和性能提高等。 |
| |
| 考试目标 |
Configure Resource Manager to control resource usage
Configure an Oracle Database with an emphasis on good
performance.
Detect and resolve latch and lock contention problems
within the Oracle database environment
Diagnose and resolve performance issues associated with
Shared Server
Use Oracle tools to diagnose performance problems
Utilize Enterprise Manager to perform Tuning tasks
Perform day-to-day monitoring on an operational database
using STATSPACK
Identify and resolve I/O, data storage, and database configuration
problems
Configure memory and disk resources to optimize sort operations
Reconfigure file structures for performance and other
considerations
List the important steps for outlining a tuning methodology
|
| |
| 考试概要 |
Overview of Oracle9i Performance Tuning
Diagnostic and Tuning Tools
|
|
|
|
Login |
|
