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

Report message to a moderator

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: 10708
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.

Report message to a moderator

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: 10708
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

Report message to a moderator

Previous Topic: 10g - gather_stats_job
Next Topic: i/o and disk planning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 13:20:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.