Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Anyone wishing to learn about Oracle9i database performance tuning

Prerequisites

An understanding of database concepts and technologies

Course Aim

This learning path demonstrates how to identify and resolve common Oracle9i(TM) database performance-related issues. It explains how to analyze and resolve performance problems in tuning memory structures, database structures, and systems and applications. The learning path maps to Exam #1Z0-033: Oracle9i Database: Performance Tuning and comprises instructional objects, simulations, mentored exercises, and a task-based simulation workshop.

Learning Objectives

To describe how to tune Oracle9i memory structures

Topics Covered

Analyzing and tuning the shared pool Analyzing the shared pool in Oracle9i Tuning the shared pool in Oracle9i Tuning shared pool performance in Oracle9i Analyzing and tuning the buffer cache Analyzing the buffer cache in Oracle9i Tuning the buffer cache in an Oracle9i database Tuning buffer cache performance in Oracle9i Tuning the redo log buffer and latches Tuning the redo log buffer and Java pool in Oracle9i Minimizing latch contention in an Oracle9i database Diagnosing latch contention in Oracle9i databases Memory allocation Allocating memory in an Oracle9i database

About Eno.com | Help | Terms of Use | Site Search | Contact Us | Site Map
Copyright © 1996-2002 E&A Inc. All rights reserved.