CHAPTER 31SQL Replay

As of Oracle 11g, you can use "replay" features to capture the commands executed in a database and then replay them elsewhere. The operations can be captured from one database and replayed on another. You can use the capture and replay features to perform diagnostic operations or to test applications under production conditions.

Replay capabilities are particularly useful when evaluating the impacts of changes on multiuser packaged applications for which you do not have direct access to all the code. Oracle will capture the commands executed within the database regardless of their origin; the captured behavior is independent of the originating program.

High-level Configuration

Replay consists of the following processes and ...

Get Oracle Database 11g The Complete Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.