As of Oracle 11g, you can use “replay” features to capture the commands executed in a database and then replay them elsewhere. 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 ...

Get Oracle Database 12c The Complete Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.