Home » RDBMS Server » Performance Tuning » Script to Defragment Tables, Index and TableSpace
Script to Defragment Tables, Index and TableSpace [message #196255] Wed, 04 October 2006 12:04 Go to next message
dvaddi
Messages: 2
Registered: October 2006
Junior Member
Hello ,

Can I get any script which I can use for defragmentation of the Tables,Index and Tablespace.

Or can I refer any document anything else for the scripts.

Thanks
Re: Script to Defragment Tables, Index and TableSpace [message #196258 is a reply to message #196255] Wed, 04 October 2006 12:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Defragmentation is more or less a dead concept (almost, but not entirely).
http://www.oracle.com/technology/deploy/availability/pdf/defrag.pdf

Above doc was written several years before.
Information still stays good.
Just search this forum/google.
Re: Script to Defragment Tables, Index and TableSpace [message #196260 is a reply to message #196258] Wed, 04 October 2006 12:12 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And to get the complete picture, Please read this
http://www.quest-pipelines.com/newsletter-v3/0302_F.htm
Previous Topic: 10g - gather_stats_job
Next Topic: i/o and disk planning
Goto Forum:
  


Current Time: Sat Dec 03 10:16:56 CST 2016

Total time taken to generate the page: 0.10581 seconds