For cases in which you have captured a large workload covering a long period of time, you may only want to replay a portion of it to accelerate testing. The Database Replay Workload Subsetting feature enables you to create new workloads by extracting portions of an existing captured workload.
Enterprise Manager provides a wizard to extract a subset of data from an existing workload that you can use for Replay on a test system. Each extracted subset is a legitimate workload that can be replayed on its own or with other workloads in a consolidated Replay.
To perform a Replay, you need to preprocess the workloads.
This feature is available for Cloud Control Database plug-in 12.1.0.5 and later releases.
To extract subsets from a workload:
From the Captured Workloads tab of the Database Replay page, select a workload for which you want to extract a subset, then click Subset.
The Subset Workload: Define page appears, showing an Active Sessions History chart for the workload.
Select a starting and ending time for the subset you want to extract from the workload:
Click Add above the Subsets table at the bottom of the page.
The Create Subset pop-up appears.
Select either snapshot or calendar times, provide start and end times, then click OK.
Snapshot time is the preferred choice, because not all performance data may be available for the calendar time you select.
Your selected time period now appears in the Active Sessions chart as a greyed-out segment.
Optional: Define one or more additional subsets with different time periods than those you selected in the step above.
Optional: In the Advanced Parameters section, indicate whether you want to include incomplete calls after the subset workload ends. The default is to include incomplete calls when the subset workload begins.
These parameters enable you to include the calls outside of your defined boundaries. For example, when you specify a starting and ending time as the boundaries for a transaction, the transaction may have started before your indicated start time, and may also have continued after your indicated end time.
Click Next.
The Subset Workload: Database page appears.
Click the search icon next to the Database Target field and select a database for subsetting from the Search and Select: Targets pop-up that appears.
The system now requests database and host credentials.
Provide the requisite input for the step above, then click Next.
The Subset Workload: Location page appears.
If the source host and staged database host are the same, the location is pre-populated, so you do not need to provide the location for the source workload files.
If the source host and staged database host are not the same, do the following:
Choose whether you want to access the workload files from the host name shown in the Host field, or whether you want to copy the files from the source host to the Destination Host shown.
Access Directly means that the database to be used to subset the workload can access the original workload directly using the specified file system location. This is typically the case when the original workload is stored at a network shared location.
Access Copy means that the two hosts are not in the shared network path. You need to provide the source host credentials so that Enterprise Manager can copy the original workload from its current location to the specified location on the subset database host.
Depending on your choice above, either provide the directory location containing the workload files, or provide the location for the destination host.
In the Subset field, specify the storage location for each subset, then click Next.
The Subset Workload: Schedule page appears.
Indicate when you want to start the subset job, then click Next.
The Subset Workload: Review page appears.
If everything appears as you have intended, click Submit.
The Database Replay page reappears and displays a message stating that the job was submitted successfully. The Status column for your subset in the Replay Tasks table will show In Progress.