RE: Please a parameter to disable undo, like _disable_logging

  • From: John Clarke <jclarke@xxxxxxxxxxxxxxx>
  • To: jreyes@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 5 Oct 2004 23:33:36 -0400

/*+ 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@xxxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
> --
> //www.freelists.org/webpage/oracle-l
>=20

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2004