Which client requests to the database can be captured as part of the workload capture?

You are working on an online transaction processing (OLTP) system. The middle-tier applications
use connection pooling to connect to the database. Presently, you have a single-node database.
The company plans to migrate the database to a RAC environment. Before you move to a RAC
environment, you want to test the performance of the SQL statements and the peak workload on

the new environment. To accomplish the Database Capture for replay, you identified the peak
workload period on the existing system and started the Database Capture. Which client requests
to the database can be captured as part of the workload capture? (Choose all that apply.)

You are working on an online transaction processing (OLTP) system. The middle-tier applications
use connection pooling to connect to the database. Presently, you have a single-node database.
The company plans to migrate the database to a RAC environment. Before you move to a RAC
environment, you want to test the performance of the SQL statements and the peak workload on

the new environment. To accomplish the Database Capture for replay, you identified the peak
workload period on the existing system and started the Database Capture. Which client requests
to the database can be captured as part of the workload capture? (Choose all that apply.)

A.
flashback query

B.
distributed transactions

C.
logging in and logging out of sessions

D.
all DDL statements having bind variables

E.
path load of data from external files



Leave a Reply 1

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


L. Zhu

L. Zhu

A is wrong. flashback queries not captured
B is wrong. distributed transactions not captured
C is right. login/out
D is right.
E is wrong. direct path loading not captured

So C.D. are correct