Setting Up the Replay Schedule and Parameters Using Enterprise Manager

The Replay schedule feature enables you to scale up the instances of captured workloads to be included in a consolidated Replay, and then control the relative playback scheduling of the instances within the Replay. The relative scheduling of the captured workload instances is visually displayed by updating the alignment of the active session chart for each instance.

This feature is available for Cloud Control Database plug-in 12.1.0.5 and later releases.

This feature enables you to accomplish the following tasks:

  • Offset instances so that they execute at different time intervals

    You can adjust the relative replay start time of each workload instance to align the average active sessions peak times for scheduled instances of Capture workloads. This alignment of the workload peaks potentially maximizes the load on the system, so that you can experiment with how the test system responds under different workload conditions.

  • Scale up the Replay workload by adding instances of the Captured workload

    Each added instance is replayed independently of the other instances.

    When you scale up a workload by specifying multiple instances of it, the default and recommended configuration is to replay the DML statements in one of the instances. All of the additional instances will only replay the query (ready-only) statements.

    For example, if a workload has a SQL Insert to an employee database, you normally would want to have only one instance that executes the Insert, and the others would bypass user calls that modify the database with this Insert. However, you can override the default setting of an instance by unchecking the Replay Query-only check box to replay all statements in the workload.

To access the Plan Replay Schedule page:

  1. From the Database Replay home page, click on the Replay Tasks tab.

  2. Click on the name of an existing Replay task with more than one workload to navigate to the Replay Task page.

  3. Click Create to create a new Replay.

  4. Provide the requisite information in the Create Replay pop-up, then click OK.

    The new Replay appears in the Replays table.

  5. Click the name of your new Replay in the Replays table.

    A Task List now appears in the Replay page.

  6. Click the Plan Replay Schedule link.

    The Plan Replay Schedule page appears.

To scale up a Replay:

  1. In the drop-down next to the Add Workload Instance button, select the Capture workload for which you want to add an instance.

  2. Click Add Workload Instance to add the instance.

To schedule the time intervals:

  1. From the Replay Delay column, either leave the default value of 0 for the first Capture instance, or adjust the number of minutes desired before the instance starts to execute.

  2. Repeat the step above for each Capture instance until you have set all of the values to represent how you want the performance spikes to execute for your testing needs.

To auto-align workload peaks:

  1. Click the Auto-align button.

To specify query-only instances:

  1. For each instance that you want to be query-only, enable the Replay Query-only check box.

To review the updated schedule:

  1. From the Replay Task tab of the Database Replay page, click the Replay task link containing your scheduled Replay.

    The Replay Task page appears.

  2. Click the scheduled Replay in the Replays table.

  3. Select the Review tab in the Replay page.