Re: Rollback extents

Good point -

Although Oracle uses various optimisations for array inserts and "insert as select" - the rollback generated for inserts should be abouit 80 to 100 bytes per row (without indexes) with the same again, plus the length of each index entry, for each index.

To get 800 bytes per row, you would have to have around 8 indexes on the table - and then rig things so that Oracle didn't pack multiple data/index block changes into a single rollback record.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

D.Y. wrote in message ...


>

>When your SQL statement fails everything will be rolled back. How do you

>know you only inserted 200000 rows? This number doesn't explain the fact

that


>you used 160MB undo space.

>