Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Logminer Question

Logminer Question

From: Ahbaid Gaffoor <ahbaid_at_att.net>
Date: Sat, 08 Dec 2007 11:59:19 -0800
Message-ID: <475AF797.6090202@att.net>


We're trying to figure out exactly what an application has done in the db. I restored an archive log from tape and mined it.

When querying the logminer view I'm seeing two rows for a transaction in V$LOGMNR_CONTENTS The first row has sql entries in SQL_REDO and SQL_UNDO, and the ROLLBACK field is 0

The second row has sql only in SQL_REDO and the ROLLBACK field is 1

Both rows have the same SCN and TIMESTAMP, does this mean that the first row was applied and the second was indeed a rollback entry?

What's especially puzzling is we are not seeing any lost connections or abnormal program terminations, so what's causing this rollback entry?

all ideas and comments welcome.

thanks

Ahbaid

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Dec 08 2007 - 13:59:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US