• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle DBA Training Courses

DBA Performance & Tuning

View course dates

Course Duration: 5 days

Course Code: OPT

Course Description:

This course is designed for database administrators who are required to monitor and tune an Oracle8i or Oracle 9i database. By the end of this course, the delegate will have had practical experience in analyzing database performance, tuning memory allocation, I/O activity rollback segments and SQL statements. This course covers the main performance and tuning topics for the Oracle9i Database: Performance Tuning examination (1Z0-033) and the Oracle8i Performance and Tuning examination (IZO-024).

Prerequisites:

A working knowledge of SQL*Plus and Oracle Database Administration is required. This can be obtained by attendance on the Pre-Requisite courses. Pre-Requisites Courses: SQL*Plus (OSP) and DBA Part I - Architecture & Administration (ODA). Note: Before taking any exam, ensure you have the recommended experience.

Prerequisite courses:

SQL*Plus

DBA Part I - Architecture & Administration

Relevant Certifications:

Oracle9i Database Administrator

This course includes the following modules:

Topics Covered

• Tuning Methodology and Considerations
• Analyzing the Database
• Oracle Alert and Trace Files
• Diagnostic and Tuning Utilities
• Dynamic Performance Views
• Optimizing Memory Usage
• Tuning the Operating System
• Optimising I/O Activity and CPU Usage
• Optimising Sort Operations
• Tuning SQL Statements
• Tuning Rollback Segments
• Identifying Tuning Contentions
• Monitoring and Detecting Lock Contentions
• Monitoring and Detecting Latch Contentions
• Creating Monitoring Scripts
• Oracle OEM Packs

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course