| Oracle8i 性能调整 |
Exam 1Z0-024：
Oracle8i Performance Tuning |
 |
| |
| 预备知识 |
w Thorough knowledge of Oracle architecture
w Knowledge of Oracle Enterprise Manager Performance Manager
w ” Oracle8i Enterprise DBA Part 1A: Architecture and
Administration”
w ” Enterprise DBA Part 1B: Backup and Recovery ”
|
| |
| 考试简介 |
| 本课程将向学员介绍一系列可用于改进 |
|
|
| Oracle8i Server 性能的精调步骤。重点在于数据库而不是具体的操作系统的性能问题。学员将通过亲自动手优化一个Oracle
数据库来学习和掌握实践经验。通过使用多种不同的工具，学员还将学习如何确认、分析、和解决在管理Oracle 数据库的过程中经常发生的与性能相关的问题。本课程包括一个互动性讲座，学员将有机会循序渐进地学习和了解实际应用中性能优化问题和情况，如问题诊断和性能提等。 |
| |
| 考试目标 |
Detect and resolve latch and lock contention problems
within the Oracle database environment
Diagnose and resolve performance issues associated with
the multithreaded server
List the options to enhance performance tuning requirements
for different types of applications
Use Oracle tools to diagnose performance problems
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
|
| |
| 考试概要 |
Introduction to Performance Tuning
Sources of Tuning Information
SQL Statement Tuning and Application Design
Tuning the Shared Pool
Tuning the Database Buffer Cache
Tuning the Redo Log Buffer
Tuning Physical I/O
Tuning Contention
Resource Management
Oracle Expert
|
|
|
|
Login |
|
