Back To Oracle Training Courses

Oracle9i Performance Tuning Training CBT Suite

Price: $387.00

CBT Course Overview:

The Self Study Store Computer Based Training Introduction to Oracle9i Performance Tuning introduces students to the strategies and techniques used for tuning the Oracle9i server and the importance of good initial database design. This curriculum will cover how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views, migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting are also covered in this curriculum. This training course will help candidates prepare for the Oracle9i OCP DBA Certification, and is mapped to Exam 1Z1-033.

Total Training Duration:

30 hours

CBT Course Modules:

• Oracle9i Performance Tuning: Strategies and Techniques Training
• Oracle9i Performance Tuning: Managing Memory and Disk I/O Training
• Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention Training

Training Course Topics:

• Match the tuning goals with the appropriate job role.
• Learn common tuning problems that directly affect database performance.
• Learn appropriate tuning goals.
• Learn key information recorded by the alert log.
• Learn the parameters that control the location and format of the alert log file.
• Learn the different methods available for generating user process trace files.
• Learn the functions of the DBA views used to provide data storage statistics.
• Match the dynamic performance views with the statistics they provide.
• Match the V$ views used to collect system-wide statistics with their functions.
• Match the optimizer modes with their descriptions.
• Match the OPTIMIZER_MODE parameter values with their description.
• Learn the methods of creating stored outlines.
• Learn the three major areas of the Shared Pool.
• Learn the parameters used to tune the Shared Pool.
• Learn the goals for tuning the Library Cache.
• Learn the descriptions of redo entries.
• Match the statistics used to diagnose disk I/O contention with their descriptions.
• Match the uses of rollback segments with their definitions.
• Select the characteristics of rollback segment activity.
• Learn the characteristics of rollback segment growth.
• Learn the locking mechanism characteristics.
• Select the statements that characterize DML and DDL locks.
• Learn the DML lock characteristics.
• Sequence the process steps of the Oracle shared server configuration.
• Learn the characteristics of the Oracle shared server.
• Query a dispatcher process to determine the process status using the V$DISPATCHER view.
• Much more.