Home » RDBMS Server » Server Administration » Removing Row chaining (
Removing Row chaining [message #306036] Wed, 12 March 2008 11:18 Go to next message
Messages: 75
Registered: February 2005

Any documents/procedure on the most effective way to Removing row chaining will be very helpful.

Could anyone please help me out with one?

Thank you
Re: Removing Row chaining [message #306043 is a reply to message #306036] Wed, 12 March 2008 11:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65150
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Real row chaining can't be removed. Its source comes from row greater than block size. The only way is to have greater block size.

Migrating rows may be removed by moving the rows (exp/imp, alter table move...) and can be (in some part) prevented with a higher pctfree.

Re: Removing Row chaining [message #306121 is a reply to message #306043] Wed, 12 March 2008 22:37 Go to previous message
Messages: 696
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
I think, I may avoid row_mirgation by

1/Move table to the other segment, and increase PCTFREE corrseponding
SQL> alter table X move
            NEXT 40K
            MINEXTENTS 2
            MAXEXTENTS 20
            PCTINCREASE 0);

2/ Rebuild Index on that table
SQL> alter index X_indx rebuild; 

With Really Chained_Row, said Michel, he's right.
Previous Topic: granting a user rights to another users account
Next Topic: Size details for files in Tablespace
Goto Forum:

Current Time: Mon Aug 21 18:30:18 CDT 2017

Total time taken to generate the page: 0.09178 seconds