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: Disabling redo and rollback

Re: Disabling redo and rollback

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 18 Jan 2003 09:30:00 +1100
Message-ID: <_j%V9.26713$jM5.70025@newsfeeds.bigpond.com>


If you want a list of all the parameters, including the hidden ones, you can log on as SYS and do a select ksppinm, ksppdesc from x$ksppi.

Regards
HJR "Pablo Sanchez" <pablo_at_dev.null> wrote in message news:Xns93069AD17CD59pingottpingottbah_at_216.166.71.233...
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in news:kM_V9.26687
> $jM5.69892_at_newsfeeds.bigpond.com:
>
> > However, there is a hidden parameter called _disable_logging (and
> > yes, that's an underscore at the beginning of it). Stick that in
> > your init.ora, and set it to true. Bounce the instance. Voila.
>
> Very cool! I was looking for that param. Didn't need it just yet but
> I can see that it _might_ be useful during a conversion where a cold
> backup is done pre and post anyway.
>
> Thx!
> --
> Pablo Sanchez, High-Performance Database Engineering
> http://www.hpdbe.com
Received on Fri Jan 17 2003 - 16:30:00 CST

Original text of this message

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