Download Oracle Database Real Application Testing User's Guide

9
9
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" on page 8-2.
This chapter contains the following sections:
■
Prerequisites for Capturing a Database Workload
■
Workload Capture Options
■
Workload Capture Restrictions
■
Enabling and Disabling the Workload Capture Feature
■
Capturing a Database Workload Using Enterprise Manager
■
Monitoring Workload Capture Using Enterprise Manager
■
Capturing a Database Workload Using APIs
■
Monitoring Workload Capture Using Views
Prerequisites for Capturing a Database Workload
Before starting a workload capture, you should have a strategy in place to restore the
database on the test system. Before a workload can be replayed, the logical state of the
application data on the replay system should be similar to that of the capture system
when replay begins. To accomplish this, consider using one of the following methods:
■
Recovery Manager (RMAN) DUPLICATE command
■
Snapshot standby
■
Data Pump Import and Export
This will allow you to restore the database on the replay system to the application
state as of the workload capture start time.
See Also:
■
■
■
Oracle Database Backup and Recovery User's Guide for information
about duplicating a database using RMAN
Oracle Data Guard Concepts and Administration for information
about managing snapshot standby databases
Oracle Database Utilities for information about using Data Pump
Capturing a Database Workload 9-1