|
Provided by: 123-CBT Computer Based Training Oracle8i Performance Tuning Architecture Strategy |
 |
Course Overview
This course is the first in a three-part Oracle8i Performance Tuning series. This interactive course will introduce participants to tools and techniques used to improve the performance of the Oracle8i server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally, students will overview the operating system tuning issues.
Learn To:
- Identify the roles of individuals involved in the tuning process.
- Identify different tuning goals.
- Define the steps associated with the tuning process.
- Identify the location and usefulness of the alert log file.
- Identify the location and usefulness of the background and user process trace files.
- Identify different types of events and manage the event system using OEM.
- Collect statistics using the dynamic troubleshooting and performance views.
- Diagnose statistics using the UTBSTAT/UTLESTAT output report.
- Identify appropriate OEM tuning tools.
- Use the available data access methods to tune the logical design of the database.
- List the primary steps for operating system tuning.
- Identify similarities between operating system and database tuning.
Content Emphasis
Skills-Based
Audience
Database Administrators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and experience using Oracle Enterprise Manager (OEM). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 4, 1Z0-024.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Tuning the Oracle8i Server: Overview
Duration: 1.5 - 2 Hour(s)- Match the tuning goals with the appropriate job role.
- Identify appropriate tuning goals.
- Sequence the steps associated with tuning an Oracle8i database.
Unit 2: Alert Log, Trace Files, and Events
Duration: 1.5 - 2 Hour(s)- Identify key information recorded by the alert log.
- Identify the parameters that control the location and format of the alert log file.
- Identify the purpose of generating background trace files.
- Identify the parameters that control the location and format of background trace files.
- Identify the different methods available for generating user process trace files.
- Identify the parameters that control the location and format of user process trace files.
- Identify the V$ views used to obtain wait event information.
- Identify key statistics found in event views.
Unit 3: Utilities and Dynamic Performance Views
Duration: 1 - 2 Hour(s)- 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.
- Match the session-related views with the statistics they provide.
- Identify the functions performed by the utlbstat.sql and utlestat.sql scripts.
- Match sections of the report.txt output with potential problems and areas of focus for tuning.
- Locate Oracle supplied scripts used to provide additional statistics.
- Order the key steps in the Oracle Expert Tuning Methodology.
Unit 4: Considerations for Tuning Applications
Duration: 1 Hour(s)- Identify the key usage of b-tree indexes.
- Identify the key usage of bitmap indexes.
- Identify the key usage of reve
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
