Re: Logminer Question

  • From: Ahbaid Gaffoor <ahbaid@xxxxxxx>
  • To: nigel_cl_thomas@xxxxxxxxx
  • Date: Sun, 09 Dec 2007 11:59:36 -0800

Hello Nigel,
there are no deferred constraints, actually the design is so bad that there are very few constraints.
I'm beginning to want to take the app from the developer and start going through it with a fine tooth comb. This is perhaps the best approach to see what's going wrong.
The problem I am faced with is the developer is claiming "Oracle is doing something" :) 

I think I need to tear the app apart...
but, back to my original question, am I correct that "ROLLBACK=1" indicates that this transaction was applied to rollback a row?
Also, how do you order entries in V$LOGMNR_CONTENTS if they have the same SCN and TIMESTAMP? 

many thanks

Ahbaid


Nigel Thomas wrote:

Ahbaid
Are there any deferred constraints in your schema - ie something that might not be rejected until the end of the transaction? Again, you should see an exception - but it might be raised somewhere unexpected (unexpected by the developer, that is). See eg http://www.oracle-base.com/articles/8i/ConstraintCheckingUpdates.php. Other possibilities: 
- any autonomous transactions that could fail?
- any WHEN OTHERS THEN NULL?
Regards Nigel
----- Original Message ---- 
From: Ahbaid Gaffoor <ahbaid@xxxxxxx>
To: Finn Jorgensen <finn.oracledba@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Sunday, December 9, 2007 6:18:48 AM
Subject: Re: Logminer Question
What's puzzling is the developer is claiming that no ORA- errors were seen, so even with a PK or unique key violation that should throw an error.
Does Oracle actually apply the transaction then roll it back in cases of PK/Unique viloations? 

Interesting, I'll test for that

thanks!

Ahbaid

Finn Jorgensen wrote:
Barring a user rollback operation, perhaps an insert into a table with a PK or unique index which was violated? Finn
On Dec 8, 2007 2:59 PM, Ahbaid Gaffoor <ahbaid@xxxxxxx <mailto:ahbaid@xxxxxxx>> wrote: 

    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
    --
    //www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2007