| balaji |
Posted: Jun 25, 2008 05:02:53 PM |
Total Post: 150
Joined: May, 2008
|
Dear all,
i can find ist of tablespace name which shows fragmentation information from the view dba_free_space.
but i want to know the condition required to tune the tablespace and table fragementation.
can anybody help me out??
|
|
|
 Gitesh |
| Posted: Jun 26, 2008 01:02:33 AM |  |
|
Total Post: 322
Joined: May, 2005
|
You got from dba_free_space then it indicates user dropped so many objects from database. If this type of sceniro is true then create different tablespace for high volatile tables.
If responce becomes too slow then you can consider fragmentation. At present locally managed tablespace with system allocation uses bitmap in the datafile. It will automatically coalase this space and allocate next available space to table object.
If object fragmentation is there then you should need to re-create or rebuild object it is highly recommended.
|
|
|
|
|
| positive |
| Posted: Jun 27, 2008 05:18:19 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
Try enabling row migration using;
SQL>alter table tablename enable row movement;
REbuild indexes using;
sql>alter index index-name rebuild online;
Alter table,index,materialized view,materialized view log using shrink space clause that coalesces space.
eg:
sql>alter table tablename shrink space;
|
|
|
|
|
| positive |
| Posted: Aug 11, 2008 09:12:41 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
