Database Testing Guide
ContentsOpens a new window
Opens a new window
Page 226 of 308

Remapping Connection Using APIs

This section describes how to remap connection strings for a consolidated replay using the DBMS_WORKLOAD_REPLAY package. For information about connection remapping, see "Remapping Connections for Consolidated Database ReplayOpens a new window".

To remap connection strings:

  1. Use the REMAP_CONNECTION procedure:

    DBMS_WORKLOAD_REPLAY.REMAP_CONNECTION (
       schedule_cap_id   IN NUMBER,
       connection_id     IN NUMBER,
       replay_connection IN VARCHAR2);
    

    This procedure remaps the captured connection to a new connection string for all participating workload captures in the replay schedule.

  2. Set the schedule_capture_id parameter to a participating workload capture in the current replay schedule.

    The schedule_capture_id parameter is the unique identifier returned when adding the workload capture to the replay schedule, as described in "Adding Workload Captures to Replay Schedules Using APIsOpens a new window".

  3. Set the connection_id parameter to the connection to be remapped.

    The connection_id parameter is generated when replay data is initialized and corresponds to a connection from the workload capture.

  4. Set the replay_connection parameter to the new connection string that will be used during replay.

See Also:

Oracle Database PL/SQL Packages and Types Reference for information about the REMAP_CONNECTION procedure

Previous PageOpens a new window
Page 226 of 308
Next PageOpens a new window