We help IT Professionals succeed at work.

Reconstruct DML statements from Oracle sqlarea

ITDeptAtPCS
ITDeptAtPCS asked
on
How can I reconstruct a complete DML statements (any insert/update/delete) that has occured in an oracle enviroment over a given time period in the sequence that those statements occured?
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
I can read this question two ways:
1- already existing transactions on a current database:
    If you do not have auditing turned on, check out LogMiner.
http://docs.oracle.com/cd/B19306_01/server.102/b14215/logminer.htm

2- You wish to reproduce workload and do not have existing transactions.  Check out Real Application Testing (RAT):
http://www.oracle.com/us/products/database/options/real-application-testing/overview/index.html

Explore More ContentExplore courses, solutions, and other research materials related to this topic.