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 Replay".
To remap connection strings:
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.
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 APIs".
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.
Set the replay_connection
parameter to the new connection string that will be used during replay.
Oracle Database PL/SQL Packages and Types Reference for information about the REMAP_CONNECTION
procedure