|
Provided by: Serebra Learning Corporation Oracle8 Performance Tuning: Strategies and TechniquesPerfomance Tuning |
 |
Training
Provided by Serebra Learning Corporation
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.
|
|
||||||||||
Oracle8 Performance Tuning: Strategies and Techniques
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
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).
Objective
- 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.
Topics Include
Unit 1: Oracle Performance Tuning Methodology
- 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
- 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
- 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
- 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
- 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.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
CDROM
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
