RE: Please a parameter to disable undo, like _disable_logging

From: John Clarke <jclarke_at_centroidsys.com>
Date: Tue, 5 Oct 2004 23:33:36 -0400
Message-ID: <20041005233336.6d9a082c@centroidsys.com>

/*+ append */ disables redo, not undo (as does =5Fdisable=5Flogging).

Array/bulk inserts will reduce the amount of undo you generate, so this = method will help. But you can't avoid undo altogether.

At least you're not updating or deleting the 10,000,000 rows.

John

• Original Message ----- From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com> To: oracle-l_at_freelists.org Sent: Tue, 5 Oct 2004 20:23:01 -0400 Subject: RE: Please a parameter to disable undo, like =5Fdisable=5Floggi= ng

> thanks

>=20
> but /*+ append */ too bypasses undo, and if you set =5Fdisable=5Floggi=
ng you run
> the same risk, if you have a problem.
> I think for a test database could be acceptable. For example I'm tryin=
g to
> create a 10 000 000 records in my home for testing
> purposes, so this will be greatly welcome.
> I bet there should be a way.

>=20

> =20
> Juan Carlos Reyes Pacheco
> OCP
> --
> http://www.freelists.org/webpage/oracle-l
>=20

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

Received on Tue Oct 05 2004 - 22:29:10 CDT