About Query-Only Database Replay

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.