oracle workload capture,Oracle OCP IZ0-053 Q257(workload capture)

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

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.

XA transactions

XA transactions are not captured or replayed. All local transactions are captured.

JAVA_XA transactions

If the workload uses the JAVA_XA package, JAVA_XA function and procedure calls are captured as normal PL/SQL workload. To avoid problems during workload replay, consider dropping theJAVA_XA package on the replay system to enable the replay to complete successfully.

Database Resident Connection Pooling (DRCP)

Workloads using OUT binds

Multi-threaded Server (MTS) and shared server sessions with synchronization mode set to OBJECT_ID

Migrated sessions

The workload is captured for migrated sessions. However, user logins or session migration operations are not captured. Without a valid user login or session migration, the replay may cause errors because the workload may be replayed by a wrong user.