Re: ** import tuning

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Thu, 9 Jun 2005 08:37:19 +0800
Message-ID: <5e30486205060817375bd1742a@mail.gmail.com>

Whilst we're corrupting databases to make them go faster ... :-)

_wait_for_sync is another one to play around with, and as well as making your redo logs enormous (because even with _disable_logging you still "switch" logs when they get "full")

hth
connor

On 6/9/05, Mladen Gogala <mgogala_at_allegientsystems.com> wrote:
> Marquez, Chris wrote:

>=20


> >

> >Yes, I only use it to speed the IMPort on a non production database and

> >un-set it!

> >*BUT* even unsetting _disable_logging can be challenging...you must

> >cycle through all the redo logs after unsetting and before you can go

> >into archive log mode.

> >I'm not recommending this parameter for normal business use.
> >

--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 09 2005 - 02:08:20 CDT