Re: Disabling rollback. Is it possible?

From: David Scott <dscott_at_is.net>
Date: 1995/08/17
Message-ID: <dscott-1708952049280001_at_dscott.is.net>#1/1

In article <DDAy2r.249_at_txnews.amd.com>, darryl snedeker <darryl.snedeker_at_amd.com> wrote:

> You cannot disable rollback segments.
>
> Before Image read-consistency functionality is a fundamental and
 necessary component to any
> fully relational database. While it's true that Oracle v7.2 will
 introduce 'operations' that
> will allow you to turn off logging (UNRECOVERABLE), this will not
 provide any benefit to your
> rollback segment problems.

OTOH, have you looked into the benefits of "set transaction read_only" and read-only tablespaces in 7.1 and up? You may be able to make some gains here, but YMMV.

Just my $0.02...

---

David Scott
...how can I keep from singing?
email: dscott_at_is.net

---

Received on Thu Aug 17 1995 - 00:00:00 CEST