Which two client requests are captured during database replay Capture?

Which two client requests are captured during database replay Capture? (Choose two)

Which two client requests are captured during database replay Capture? (Choose two)

A.
Flashback queries

B.
Shared server requests

C.
Login and logoff activities of sessions

D.
Direct path load of data from external files by using utilities such as SQL *loader

E.
Data definition language (DDL) and data manipulation language (DML) operations

Explanation:
9.3 Workload Capture Restrictions
Certain types of user sessions and client requests may sometimes be captured in a
workload, but they are not supported by Database Replay. Capturing these session and
request types in a workload may result in errors during workload replay.
The following types of user sessions and client requests are not supported by Database
Replay:
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 the JAVA_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.
Typically, Database Replay refrains from capturing these types of non-supported user
sessions and client requests. Even when they are captured, Database Replay will not replay
them. Therefore, it is usually not necessary to manually filter out non-supported user
sessions and client requests. In cases where they are captured and found to cause errors
during replay, consider using workload capture filters to exclude them from the workload.



Leave a Reply 0

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