RE: Insert contention on RAC

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.

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