Re: Logminer Question

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_at_att.net>
> To: Finn Jorgensen <finn.oracledba_at_gmail.com>
> Cc: oracle-l_at_freelists.org
> 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_at_att.net
>> <mailto:ahbaid_at_att.net>> 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
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>

--
http://www.freelists.org/webpage/oracle-l