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 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) load testing to be performed
2) all the 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 = FALSE, THINK_TIME_SCALE = 0, CONNECT_TIME_SCALE = 0 and
THINK_TIME_AUTO_CORRECT = FALSE
B.
SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 100, CONNECT_TIME_SCALE = 0
and THINK_TIME_AUTO_CORRECT = FALSE
C.
SYNCHRONIZATION = FALSE, THINK_TIME_SCALE = 100, CONNECT_TIME_SCALE = 100
and
THINK_TIME_AUTO_CORRECT = TRUE
D.
SYNCHRONIZATION = TRUE, THINK_TIME_SCALE = 100, CONNECT_TIME_SCALE = 100
and
THINK_TIME_AUTO_CORRECT = FALSE
2) all the sessions to connect immediately
3) user waits between issuing calls to be kept to a minimum
So connect_time_scale = 0
think_time_scale=0
think_time_auto_correct=false
So A is correct