Re: _disable_logging does not seems to work

Hi!

_disable_logging disables actual redo writing to disk, but it doesn't disable the internal calls to fill redo buffers or smth like that. If you check from OS level, you should see that there's very little activity on redologs.

Tanel.

"charlie cs" <cs3526(no-spam)@yahoo.com> wrote in message news:bXpla.8451$d8.7263_at_nwrdny02.gnilink.net...
> We are using 9.2.020 on windows 2000.
> We have a database for testing purpose. Every time we recreate the new
> database and then importing the data from production to ensure identical
> environment for testing purpose.
>
> I set _disable_logging=true to speed up the import. But oracle still
using
> the online redo logs, when I search against the v$log, I can still see the
> status of log member changing from inactive=>current=>active.
>
> How can I completely turn off the redo logging? Unable to recove is not
our
> concern here. We just want a fast import.
>
> Thanks for your help.
>
>
Received on Fri Apr 11 2003 - 01:38:42 CDT