Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: disable rollback segments

Re: disable rollback segments

From: Jurij Modic <jmodic_at_src.si>
Date: Sun, 07 Feb 1999 20:19:34 GMT
Message-ID: <36bdf546.2968444@news.arnes.si>


On Sun, 7 Feb 1999 11:23:28 -0600, "Don J. Bohlen" <dbohlen_at_telecomsoft.com> wrote:

>I heard that for large updates , there is a way to disable the rollback
>segment in Oracle 8?
>
>Is this true????

If you are asking how to prevent generating undo entries in the rollback segments, the answer is: you can't! In some circumstances you can avoid generating redo entries in redo log files, but you can't do it for undo entries in rollback segments.

>Don

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Feb 07 1999 - 14:19:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US