[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Reconstruct DML statements from Oracle sqlarea

Posted on 2012-03-12
1
Medium Priority
?
433 Views
Last Modified: 2012-06-22
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?
0
Comment
Question by:ITDeptAtPCS
1 Comment
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1500 total points
ID: 37712606
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

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question