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

Which client requests to the database can be captured as a part of the workload capture?
(Choose all that apply.)

Which client requests to the database can be captured as a 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

Show Hint

Leave a Reply 1

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

Jake from SF

Jake from SF

C and D are correct:

https://docs.oracle.com/cd/B28359_01/server.111/e12253/dbr_capture.htm

Workload Capture Restrictions
The following types of client requests are not captured in a workload:

Direct path load of data from external files using utilities such as SQL*Loader

Shared server requests (Oracle MTS)

Oracle Streams

Advanced replication streams

Non-PL/SQL based Advanced Queuing (AQ)

Flashback queries

Oracle Call Interface (OCI) based object navigations

Non SQL-based object access

Distributed transactions (any distributed transactions that are captured will be replayed as local transactions)

Reply