In a query-only database replay, only the read-only queries of a workload capture are replayed. In other words, in a query-only replay, only SELECT statements are sent to the server at replay time. No DML statements are executed during a query-only replay, and the replay does not make any changes to user schemas or data.
Note:
A query-only database replay can be performed with Consolidated Database Replay only.
Note:
Query-only database replays are meant to be used and executed in test environments only.
Do not use query-only database replays on production systems.
Divergence is expected during query-only database replays.