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.
direct path load of data from external files



Leave a Reply 0

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