Xref: alice comp.databases.oracle.server:83002
Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!newsfeed.concentric.net!newsfeed.ozemail.com.au!news1.optus.net.au!optus!intgwpad.nntp.telstra.net!news-server.bigpond.net.au!not-for-mail
From: nsouto@nsw.bigpond.net.au.nospam (Nuno Souto)
Newsgroups: comp.databases.oracle.server
Subject: Re: INSERTs and Rollback Segments
Organization: D.C.S. P/L
Message-ID: <3897dedc.2609697@news-server>
References: <878hk7$pms$1@nnrp1.deja.com>
X-Newsreader: Forte Free Agent 1.11/32.235
Lines: 22
Date: Wed, 02 Feb 2000 08:02:05 GMT
X-Complaints-To: news@bigpond.net.au
X-Trace: news-server.bigpond.net.au 949478525 24.192.48.47 (Wed, 02 Feb 2000 19:02:05 EST)
NNTP-Posting-Date: Wed, 02 Feb 2000 19:02:05 EST

On Wed, 02 Feb 2000 06:08:09 GMT, atta707@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@nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html