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

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
KV
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: 64103
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.

Regards
Michel
Re: Removing Row chaining [message #306121 is a reply to message #306043] Wed, 12 March 2008 22:37 Go to previous message
trantuananh24hg
Messages: 668
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
   PCTFREE 20
   PCTUSED 40
   STORAGE (INITIAL 20K
            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: Size details for files in Tablespace
Next Topic: error in adding initialization parameters
Goto Forum:
  


Current Time: Sat Dec 03 11:58:27 CST 2016

Total time taken to generate the page: 0.08176 seconds