-
Hello,
Can anyone tell me if there is a easier way(simple script or command line) to DEFRAG the Tablespaces?
-
alter tablespace <tablespace_name> coalesce;
This wiil work lf pctincrease is > 0
sanjay_kansara@hotmail.com
-
Defragmentation
hi, do u try move tables ?
If u have some tables in tablespace, try to use extents equal for all tables, if will do it, all tables with only value, wiil be more easy for administration ....
Sandro Lobo
sslobo@globo.com
Sandro Lobo
Oracle DBA
www.geocities.com/sslobopt
-
alter tablespace coalesce will always works as long as you issue it manually. If you want Oracle to do it manually set pctincrease > 0 although personally I never set this value to bigger than zero.
Also when you talk defragmentation what kind are you referring? There are mainly three, Free Space, Extents, Block.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|