Xref: alice comp.databases.oracle.server:39563
Path: alice!news-feed.fnsi.net!netnews.com!newsswitch.lcs.mit.edu!newsfeed.cwix.com!204.238.120.130!news-feeds.jump.net!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: nguffey@jdriscoll.com
Newsgroups: comp.databases.oracle.server
Subject: rollback segment usage
Date: Tue, 02 Feb 1999 16:19:33 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 9
Message-ID: <7978ia$9vc$1@nnrp1.dejanews.com>
X-Article-Creation-Date: Tue Feb 02 16:19:33 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
X-Http-Proxy: 1.0 PROXY_SERVER, 1.0 x13.dejanews.com:80 (Squid/1.1.22) for client 209.30.134.99

Several Questions: 1.  When Oracle writes a before image to a rollback
segment, is it writing only the row being modified, or is it writing the
entire datablock? 2.  Does a SCN apply only to the row on a data block being
modified, or to the entire block? 3.  Multiple transactions can use the same
rollback segment, but under what conditions, if any, can multiple
transactions use the same extent in a particular rollback segment?

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own