Remapping Connections

After the replay data is initialized, connection strings used in the workload capture need to be remapped so that user sessions can connect to the appropriate databases and perform external interactions as captured during replay. To view connection mappings, use the DBA_WORKLOAD_CONNECTION_MAP view. For information about connection remapping, see "Connection Remapping".

To remap connections:

• Use the REMAP_CONNECTION procedure:

  BEGIN
    DBMS_WORKLOAD_REPLAY.REMAP_CONNECTION (connection_id => 101,
                             replay_connection => 'dlsun244:3434/bjava21');
  END;
  /
  

  In this example, the connection that corresponds to the connection ID 101 will use the new connection string defined by the replay_connection parameter.

  The REMAP_CONNECTION procedure in this example uses the following parameters:

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

  • The replay_connection required parameter specifies the new connection string that will be used during workload replay.