RE: Insert contention on RAC

From: Bobak, Mark <>
Date: Wed, 25 Jun 2008 17:59:13 -0400
Message-ID: <>

Another option would be:
Insert one row into table
Alter table <table_name> minimize records_per_block; Insert as many rows as you'll need. (You'll get one block per row inserted.) Delete from <table_name>;
Alter table <table_name> nominimize records_per_block;

That way, you don't have to mess w/ pctused/pctfree calculations. You'll get exactly one row per block. It's just a little quicker/cleaner way to extend the table to the size you need.


Mark J. Bobak
Senior Database Administrator, System & Product Technologies
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059

ProQuest...Start here.

-----Original Message-----
From: [] On Behalf Of Tim Gorman
Sent: Wednesday, June 25, 2008 5:45 PM
Subject: RE: Insert contention on RAC

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:59:13 CDT

Original text of this message