Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Logminer Question
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-lReceived on Sat Dec 08 2007 - 13:59:19 CST
![]() |
![]() |