OraFAQ Forum: Server Administration » Removing Row chaining

Home » RDBMS Server » Server Administration » Removing Row chaining (9.2.0.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Removing Row chaining [message #306036]

Wed, 12 March 2008 11:18

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

Report message to a moderator

Re: Removing Row chaining [message #306043 is a reply to message #306036]

Wed, 12 March 2008 11:40

Michel Cadot
Messages: 68684
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

Report message to a moderator

Re: Removing Row chaining [message #306121 is a reply to message #306043]

Wed, 12 March 2008 22:37

trantuananh24hg
Messages: 744
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.

Report message to a moderator

Previous Topic:	Size details for files in Tablespace
Next Topic:	error in adding initialization parameters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 20:04:42 CDT 2024