O'Reilly logo

Oracle Database 11g The Complete Reference by Kevin Loney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required