RE: Insert contention on RAC
Date: Wed, 25 Jun 2008 15:44:37 -0600
Dang Mark! We're going to have to rename you "MacGyver"..... ;-)
Quoting "Mark W. Farnham" <mwf_at_rsiz.com>:
> You can decouple from the time of the run by inflating a table of a
> different name and using rename. You can mess with pctfree and pctused so
> you can inflate the table with one row per block, alter pctfree and pctused,
> and then run the delete.
> If the target table has its own tablespace you can drop the tablespace and
> re-transport in the tablespace with the pre-inflated empty table.