Profile

e-Catalog

Contact

Search

Cart

Oracle9i Tuning Systems and Applications

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	3 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 systems and applications in Oracle9i

Topics Covered

Tuning SQL Tuning SQL in an Oracle9i database Using TKPROF in an Oracle9i database SQL and the Oracle9i optimizer Application tuning Oracle9i application tuning Tuning storage structures in an Oracle9i database Tuning indexes and views in an Oracle9i database Tuning system requirements Configuring Oracle9i database shared servers Operating system tuning for Oracle9i databases