After determining the number of replay clients that are needed to replay the workload, you need to start the replay clients by running the wrc
executable in replay mode on the hosts where they are installed. Once started, each replay client will initiate one or more sessions with the database to drive the workload replay.
In replay mode, the wrc
executable accepts the following keywords:
userid
and password
specify the user ID and password of a replay user for the replay client. If unspecified, these values default to the system
user.
server
specifies the connection string that is used to connect to the replay system. If unspecified, the value defaults to an empty string.
replaydir
specifies the directory that contains the preprocessed workload capture you want to replay. If unspecified, it defaults to the current directory.
workdir
specifies the directory where the client logs will be written. This parameter is only used with the debug
parameter for debugging purposes.
debug
specifies whether debug data will be created. Possible values include:
on
Debug data will be written to files in the working directory
off
No debug data will be written (the default value)
connection_override
specifies whether to override the connection mappings stored in the DBA_WORKLOAD_CONNECTION_MAP
view. If set to TRUE
, connection remappings stored in the DBA_WORKLOAD_CONNECTION_MAP
view will be ignored and the connection string specified using the server
parameter will be used. If set to FALSE
, all replay threads will connect using the connection remappings stored in the DBA_WORKLOAD_CONNECTION_MAP
view. This is the default setting.
The following example shows how to run the wrc
executable in replay mode:
%> wrc system/password@test mode=replay replaydir=./replay
In this example, the wrc
executable starts the replay client to replay the workload capture stored in a subdirectory named replay
under the current directory.
After all replay clients have connected, the database will automatically distribute workload capture streams among all available replay clients and workload replay can begin. You can monitor the status of the replay clients using the V$WORKLOAD_REPLAY_THREAD
view. After the replay finishes, all replay clients will disconnect automatically.