Oracle 9i DBA Certification Training Performance Tuning
 Our 9i DBA with 10G Upgrade training includes
- DBA Oracle Certified Associate (OCA)
- DBA Oracle Certified Professional (OCP)
- Oracle Associate for Developer (OCA)
- Complete course material in interactive format.
- Simulates Lab Exercises
- Review Questions to test ones skills
- Practice Exam Quizzers for preparation of the Certification Exams
- Includes the following courses:
Introduction to Oracle Certification 9i - SQL Training Curriculum (Exam 1Z0-007 & Exam 1Z0-001)
Database Administration: Oracle Certification Fundamentals I Curriculum (Exam 1Z0-031)
Database Administration: Oracle Certification Fundamentals II Curriculum (Exam 1Z0-032)
Oracle Certification 9i Training Performance Tuning (Exam 1Z0-033)
Upgrade Course to 10G
We now offer our training in two formats:
- CD-ROM based
- Online Version- same training as the CD-ROM. Online training access is for one year 24 x 7.
|
CD-ROM Complete Oracle Certification 9i Course
|
n61131d
|
$499.00
|
|
|
Online Complete Oracle Certification 9i Course
One Year Access
|
n61131do
|
$499.00
|
|
Live Boot Camp Training Classes 10G
Oracle 9i DBA DBA Tuning Course contains the following
Performance Tuning: Strategies, Techniques
In this course, you are introduced to the strategies and techniques used for tuning the Oracle9i server.
Learn To
- Match the tuning goals with the appropriate job role.
- Identify common tuning problems that directly affect database performance.
- Identify appropriate tuning goals.
- Train to Identify key information recorded by the alert log.
- Identify the parameters that control the location and format of the alert log file.
- Identify the different methods available for generating user process trace files.
- Identify 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.
- Identify the factors taken into consideration in selecting the physical structure for data.
- Match the index types with their benefits.
- Identify the key usage of index organized tables.
- Identify the features of the Database Resource Manager.
- Identify the guidelines used to administer resource consumer groups.
- Identify the processes implemented by resource plans and resource plan directives.
- Identify the measures that can be taken to tune memory performance.
- Identify the I/O tuning areas that can improve overall system performance.
- Identify the CPU tuning practices that can improve overall system performance training.
Managing Memory and Disk I/O
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize,
troubleshoot, and resolve common performance-related problems in administering an Oracle database.
Learn To
- Match the optimizer modes with their descriptions.
- Match the OPTIMIZER_MODE parameter values with their description.
- Identify the methods of creating stored outlines.
- Identify the three major areas of the Shared Pool training.
- Identify the parameters used to tune the Shared Pool.
- Identify the goals for tuning the Library Cache.
- Identify the descriptions of redo entries.
- Match the statistics used to diagnose disk I/O contention with their descriptions.
- Identify the two parameters that allow the DBA to limit the amount of memory used for each Java session.
- Identify the performance guidelines to reduce the activity on an overloaded disk.
- Identify the methods of striping.
- Identify the initialization parameter that indicates the size of read calls during full table scans.
Optimizing Sorts and Minimizing Contention
The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining,
reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.
Learn To
- Match the component of database storage with its definition.
- Avoid dynamic allocation of extents by using the ALTER TABLE command.
- Avoid the dynamic allocation disadvantages by creating a locally managed tablespace.
- Sequence the steps in the sort process.
- Set the SORT_AREA_SIZE parameter by using the ALTER SESSION command.
- Identify the tuning sort goals.
- Match the uses of rollback segments with their definitions.
- Select the characteristics of rollback segment activity.
- Identify the characteristics of rollback segment growth.
- Identify the locking mechanism characteristics.
- Select the statements that characterize DML and DDL locks.
- Identify the DML lock characteristics.
- Sequence the process steps of the Oracle shared server configuration.
- Identify the characteristics of the Oracle shared server.
- Query a dispatcher process to determine the process status using the V$DISPATCHER view.
|
