Oracle8i Performance Tuning: Tuning Sorts and Resolving Contention

Overview/Description
To tune the sort operation and manage rollback segments

Target Audience
Network administrators, database administrators

Prerequisites
Completion ofOracle Introduction, Oracle8i Database Administration, and Oracle8i Backup and Recovery SmartCurricula

Expected Duration
3:00 Hours

Objectives:

Oracle8i Performance Tuning: Tuning Sorts and Resolving Contention

  • To outline strategies for optimizing sort operations
  • To explain how to monitor and tune rollback segment activity
  • To describe how Oracle locks data and how to tune lock contention


    • Course Number: OR854SE