|
Provided by: 123-CBT Computer Based Training Oracle8 Performance Tuning Strategies and Techniques |
 |
Course Overview
This course is the first in a three-part Oracle8 Performance Tuning series. This course will introduce participants to tools and techniques used to improve the performance of the Oracle8 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 Oracle Enterprise Manager (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, applications designers and developers, and technical support professionals. Prior to taking this course, participants should be familiar with administering an Oracle8 database and have experience using Oracle Enterprise Manager (OEM), or have taken the Oracle8 Database Administration series (courses 61311-61315).
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Oracle Performance Tuning Methodology
Duration: 1.5 - 2 Hour(s)- List the different roles associated with the tuning process.
- List examples of measurable tuning goals.
- Define the steps associated with the tuning process.
Unit 2: Oracle Alert and Trace Files
Duration: 1.5 - 2 Hour(s)- List the diagnostic information that is provided via trace files and events.
- Identify tuning information available in the alert log file.
- View the contents of the alert log file.
- Specify the location of the alert log file.
- Specify the location of the background and user process trace files.
- Identify the contents of the user process trace files.
- Enable instance level and session level tracing.
- Define wait events.
- Describe the dynamic performance views used to identify wait events and statistics associated with wait events.
- Describe the OEM event management system.
- Set events through OEM to be alerted about predefined situations.
- Resolve problems detected by an event.
Unit 3: Utilities and Dynamic Performance Views
Duration: 1 - 2 Hour(s)- List common dynamic views that provide system level and session level tuning statistics.
- Collect statistics using the dynamic troubleshooting and performance views.
- Define the scripts that gather performance statistics for tuning.
- Gather statistics by executing the UTBSTAT and UTLESTAT scripts.
- Diagnose statistics using the output report from the UTBSTAT and UTLESTAT scripts.
- Describe the OEM tools that provide monitoring and analysis of performance management areas.
- View tuning information using the OEM tuning tools.
Unit 4: Tuning Considerations for Different Applications
Duration: 1 Hour(s)- Describe the available data access methods to tune the logical design of the database.
- Identify the demands of online transaction processing systems (OLTP).
- Identify the demands of decision support systems (DSS).
- Describe the data access methods to enhance performance.
- Define appropriate use of B-tree, bitmap and reverse key indexes.
- Define appropriate use of index-organized tables.
- Define appropriate use of clusters.
- Define appropriate use of histograms.
Unit 5: Generic Operating System Tuning Issues and Oracle
Duration: 1 Hour(s)- List the primary steps for operating system tuning.
- Identify similarities between operating system and database tuning.
- Monitor and tune system memory.
- Identify how database tuning affects paging.
- Identify the Oracle statistics that help in tuning the operating system.
|
|
||||||||||
