RE: Insert contention on RAC
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "tim@xxxxxxxxx" <tim@xxxxxxxxx>, "mwf@xxxxxxxx" <mwf@xxxxxxxx>
- Date: Wed, 25 Jun 2008 17:59:13 -0400
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@xxxxxxxxxxxx
www.proquest.com
www.csa.com
ProQuest...Start here.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Tim Gorman
Sent: Wednesday, June 25, 2008 5:45 PM
To: mwf@xxxxxxxx
Cc: paul.baumgartel@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Insert contention on RAC
Dang Mark! We're going to have to rename you "MacGyver"..... ;-)
Quoting "Mark W. Farnham" <mwf@xxxxxxxx>:
> 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
