Solved

Reconstruct DML statements from Oracle sqlarea

Posted on 2012-03-12
1
388 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 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Pfile and SPfile - Oracle 2 57
querying by the sum of a column in decimal 7 56
oracle rollup query 3 51
Read only access to a Procedure in oracle? 4 48
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now