Which three actions would you perform to accomplish the realistic replay of the peak workload on the test machine?

You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP)
system.The applications running on the database use connection pooling to connect to the
database to perform transactions.
The company wants to upgrade the CPU and the memory for the machine on which the database
is running. To test the realistic workload on the new machine with increased CPU and memory,
you identified the peak workload time for the database and captured the workload on the
production system.

You set up the test machine with the upgraded CPU and memory and installed the database with
the same version as production.
Which three actions would you perform to accomplish the realistic replay of the peak workload on
the test machine? (Choose three.)

You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP)
system.The applications running on the database use connection pooling to connect to the
database to perform transactions.
The company wants to upgrade the CPU and the memory for the machine on which the database
is running. To test the realistic workload on the new machine with increased CPU and memory,
you identified the peak workload time for the database and captured the workload on the
production system.

You set up the test machine with the upgraded CPU and memory and installed the database with
the same version as production.
Which three actions would you perform to accomplish the realistic replay of the peak workload on
the test machine? (Choose three.)

A.
Preprocess the captured workload for the specified target database version.

B.
Set up as many replay clients as there are actual clients to the production system.

C.
Set up all the replay clients on the same machine on which the test database is running.

D.
Resolve all external references such as database links, external tables, and directory objects.

E.
Restore the replay database to match the capture database at the start of the workload capture.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is right. target DB version is necessary
B is wrong. replay client can initiate multiple sessions with DB
C is wrong. running on hosts
D is right. external reference
E is right. DB starting point.

So A.D.E. are correct