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 machine on which the production 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 performed the following operations for replay:
1) You preprocessed the captured workload.
2) You restored the replay database to match the capture database at the start of the workload capture.
3) You resolved all external references.
4) You set up replay clients.
You have the following replay considerations:
1) minimal data divergence to be ensured
2) all sessions to connect immediately.
3) user waits between issuing calls to be kept to a minimum
What replay options would you choose to accomplish the replay?
A.
SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 0,
CONNECT_TIME_SCALE = 0 and
THINK_TIME_AUTO_CORRECT = TRUE
B.
SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 0,
CONNECT_TIME_SCALE = 100 and
THINK_TIME_AUTO_CORRECT = TRUE
C.
SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 100,
CONNECT_TIME_SCALE = 0 and
THINK_TIME_AUTO_CORRECT = FALSE
D.
SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 100,
CONNECT_TIME_SCALE = 100 and
THINK_TIME_AUTO_CORRECT = TRUE