Mentoring 1Z0-033 Oracle9i Database: Performance Tuning

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
SkillSoft Mentors are available 24 hours a day, 7 days a week to help students with their studies for exam 1Z0-033 Oracle9i Database: Performance Tuning. You can reach them by entering a Mentored Chat Room or by using the E-mail My Mentor service.

Target Audience
Individuals who are studying the associated SkillSoft content in preparation for, or to become familiar with, the skills and competencies being measured by the actual certification exam.

Prerequisites
Familiarity with the exam objectives listed below and skills and competencies being measured in the associated certification exam.

Expected Duration (hours)
0.0

Lesson Objectives

Mentoring 1Z0-033 Oracle9i Database: Performance Tuning

Oracle Performance Tuning Methodology

Diagnostic and Tuning Tools

Sizing the Shared Pool

Sizing the Buffer Cache

Sizing other SGA Structures

Database Configuration and I/O Issues

Optimize Sort Operations

Diagnosing Contention For Latches

Tuning Rollback (or UNDO) Segments

Monitoring and Detecting Lock Contention

Tuning Oracle Shared Server

Application Tuning

Using Oracle Blocks Efficiently

SQL Statement Tuning

O/S Considerations

Course Number:
mnt1z0033