Profile

e-Catalog

Contact

Search

Cart

Oracle8i Performance Tuning: Managing Mixed Workloads

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 explain database resource management concepts and to describe how to manage a multithreaded server (MTS) environment

Learning Objectives

Explain database resource management concepts. Configure the Database Resource Manager. Describe how to use Oracle Expert to tune a database, and collect and analyze data. Manage an MTS environment. Discuss how to tune an operating system.

Topics Covered

Database resource management - Resource management concepts - Configuring Database Resource Manager - Hands-on: Creating a resource plan Oracle Expert - Tuning steps - Collecting data Analyzing the data The multithreaded server - Setting up an MTS environment - Monitoring an MTS environment - Hands-on: Using MTS-related views Operating system tuning - Tuning CPU usage - Tuning I/O and memory