Re: Disabling redo and rollback

"Phil Kaufman" <philk_at_dbcsmartsoftware.com> wrote in message news:B4_V9.13$A9.2345076_at_mantis.golden.net...
> Folks,
>
> My environment is Oracle 8.0.5 and higher/Windows 2000.
>
> My question may seem fairly novice, but here it is. I have written a
> in-house export/import program, which works on multivendor databases. At
> any rate, I was wondering if it is possible to disable the redo and
rollback
> for a transaction that does the import, and if so, how exactly I would do
> this, and if so, what kind of improvement in performance can I expect.
>

You can't ever disable rollback. Unless you do discrete transactions, that is... which import isn't doing. Redo can't be switched off either, officially... except by doing a NOLOGGING transaction, which import doesn't do. 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.

However, it's a hidden parameter for a reason: it's lethal. If you had a crash, power failure or a shutdown abort in the middle of your import, your database would be totally kacked up, without the slightest possibility of recovering it or making it in any way usable thereafter.

A prior complete, cold backup would solve that problem, of course... but then it will probably take you as long to do the backup+bounce as it would have done to perform the import in the first place.

Anyways: those are your choices.

Personally, I'd forget all about it, and just let import do its thing.

Regards
HJR
> Thanks!
>
>
Received on Fri Jan 17 2003 - 15:51:58 CST