RE: Insert contention on RAC

From: Tim Gorman <>
Date: Wed, 25 Jun 2008 15:44:37 -0600
Message-ID: <>

Dang Mark! We're going to have to rename you "MacGyver"..... ;-)

Quoting "Mark W. Farnham" <>:

> 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.

Received on Wed Jun 25 2008 - 16:44:37 CDT

Original text of this message