OraFAQ Forum: Performance Tuning » Oracle Row Chaining and Migration

Home » RDBMS Server » Performance Tuning » Oracle Row Chaining and Migration (Oracle 10.2.0.4 AIX 6L )

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

Oracle Row Chaining and Migration [message #482600]

Sat, 13 November 2010 09:32

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello Expert,

Recently i have been working analyzing Oracle Row Chaining and Migration in the database.

Is their any way to track the chaining & migration of rows as part of database health checkup. Please put light on the topic

Else we have analyze the table for detecting row Chaining and Migration.

With Regards,
Jay vardhan

Report message to a moderator

Re: Oracle Row Chaining and Migration [message #482603 is a reply to message #482600]

Sat, 13 November 2010 09:58

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Is their any way to track the chaining & migration of rows

ANALYZE TABLE LIST CHAINED ROWS.

No need to do it as part of database health checkup, too expensive, too dangerous (unless you do it in maintenance windows and think Oracle has no bug), just a waste of time and resources.
Do it only when you experience some problem, better modify the application to prevent this as much as possible.

Regards
Michel

Report message to a moderator

Re: Oracle Row Chaining and Migration [message #482604 is a reply to message #482603]

Sat, 13 November 2010 10:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

problem avoidance is superior to problem detection & correction.

Report message to a moderator

Re: Oracle Row Chaining and Migration [message #482605 is a reply to message #482604]

Sat, 13 November 2010 10:34

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks Michel,for your valuable advise.

really appreciate for the prompt and effective response.

Regards,
Jay vardhan

Report message to a moderator

Re: Oracle Row Chaining and Migration [message #482606 is a reply to message #482605]

Sat, 13 November 2010 10:44

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Remember you cannot avoid row chaining but maybe recreating the table into a tablespace with larger block.
Row migrating comes from update that increase the size of row so limit this case.

Regards
Michel

Report message to a moderator

Previous Topic:	which index is best for query performance
Next Topic:	Slow Running Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 18:56:12 CDT 2024