Your company wants to upgrade the current production database to the RAC environment. To perform testing
before migrating to the RAC environment, you performed the workload capture on the production database to
record the peak workload. You set up the test RAC database and want to replay the recorded workload on the
testmachine. Note the following steps that you may require to replay the database workload:
1) Preprocess the captured workload.
2) Restart the database in RESTRICTED mode.3) Set up the Replay Clients.
4) Restore the test database to the point when the capture started.
5) Remap connections.
Arrange the steps required in the correct sequence to accomplish this task on the test machine.
A.
1, 4, 5, 3 (2 is not required.)
B.
1, 4, 3, 5 (2 is not required.)
C.
1, 2, 4, 5 (3 is not required.)
D.
2, 1, 5, 3, 4
E.
1, 2, 4, 5, 3
Explanation:
11.1 Steps for Replaying a Database Workload
Proper planning of the workload replay and preparation of the replay system ensures that the replay will be
accurate. Before replaying a database workload, review and complete the following steps as appropriate:
Setting Up the Replay Directory
Restoring the Database
Resolving
to External Systems
Remapping Connections
User Remapping
Specifying Replay Options
Using Filters with Workload Replay
Setting Up Replay Clients