Re: Question about redo size in dump file and view

"joel garry" <joel-garry_at_home.com> wrote in message news:d71b37dc-19fb-44f8-967c-ca2870eda8a6_at_j32g2000yqh.googlegroups.com...

>>>

The TYP:2 (in CHANGE #1 TYP:2 CLS: 1 AFN:4 DBA:0x0100090f OBJ:70582 SCN: ...) means delayed logging?

If I'm understanding this (unlikely :-) the difference would be previous testing on the block.

>>>

It's possible - it's a detail I haven't investigated. I did two inserts one after the other in the same transaction on the same block, and the redo record for the second one was TYP; 0, so you could be right.

The redo record would have to hold the previous contents of the ITL slot that this transaction had take over, so there would have to be a flag to say that this information was in the record.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html