|
Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
NOARCHIVELOG and rollback segments
NOARCHIVELOG and rollback segments
Hi group,
- Does NOARCHIVELOG offer any performance benefits other than saving
on the archived redo logs - and maybe the extra I/O associated with
archiving these logs? Let's say my redo log is 1G, can you expect any
significant performance by running in NOARCHIVELOG mode?
- Can a transaction span more than one rollback segment?
- For a rollback segment contains 4 extents. Ext 1 contains committed
data. Ext 2 contains uncomitted data. Ext 3 contains committed data.
If data on Ext 2 remains uncommitted, will the data on Ext 3 ever get
overwritten?
Thanks!
John
Received on Wed Nov 05 2003 - 12:25:43 CST
Original text of this message
