10 Capturing a Database Workload

This chapter describes how to capture a database workload on the production system. The first step in using Database Replay is to capture the production workload. For more information about how capturing a database workload fits within the Database Replay architecture, see "Workload Capture".

This chapter contains the following sections:

• Prerequisites for Capturing a Database Workload

• Setting Up the Capture Directory

• Workload Capture Options

• Workload Capture Restrictions

• Enabling and Disabling the Workload Capture Feature

• Enterprise Manager Privileges and Roles

• Capturing a Database Workload Using Enterprise Manager

• Capturing Workloads from Multiple Databases Concurrently

• Monitoring a Workload Capture Using Enterprise Manager

• Importing a Workload External to Enterprise Manager

• Creating Subsets from an Existing Workload

• Copying or Moving a Workload to a New Location

• Capturing a Database Workload Using APIs

• Monitoring Workload Capture Using Views