Reconstruct DML statements from Oracle sqlarea

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?
LVL 1
ITDeptAtPCSAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.