RE: Insert contention on RAC

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

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

ProQuest...Start here.


-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman
Sent: Wednesday, June 25, 2008 5:45 PM
To: mwf_at_rsiz.com
Cc: paul.baumgartel_at_credit-suisse.com; oracle-l_at_freelists.org
Subject: 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


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