Re: INSERTs and Rollback Segments

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Wed, 02 Feb 2000 08:02:05 GMT
Message-ID: <3897dedc.2609697@news-server>

On Wed, 02 Feb 2000 06:08:09 GMT, atta707_at_my-deja.com wrote:

>
>what information is written in the rollback segment when we INSERT a
>record in any table?
>

If table has indexes, the index block before images as they are filled up. Volume can be very large, depending on number/size of indexes. If the table grows by a lot, you may get some associated dictionary table before images, such as SEG$ and a few others. But the volume will be small as there will virtually be activity only when a new extent is allocated.

And that's all. I'm assuming of course you don't have triggers that write on other tables or other hidden "peculiarites".

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Wed Feb 02 2000 - 02:02:05 CST