Audience

Database administrators, network administrators

Prerequisites

Completion of the E&A Oracle Introduction, Oracle8i Database Administration, and Oracle8i Backup and Recovery Curricula

Course Aim

To tune the sort operation and manage rollback segments

Learning Objectives

Describe how the Oracle sort process sorts data to memory and disk. Monitor and tune the sort process. Explain how to monitor segment activity and contention. Tune rollback segments using views. Describe the lock types and modes Oracle uses to protect data during concurrent access. Explain how to monitor lock activity. Explain how to reduce lock contention.

Topics Covered

Optimizing sorts - The sort process - Tuning sort operations - Hands-on: Using sort-related views Tuning rollback segments - Diagnosing contention - Improving performance - Hands-on: Tuning rollback segments using views Lock contention - Lock types and modes - Monitoring lock activity

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.
1-877-298-1322