-
My tablespace is heavily fragmented. I guess.
I have 30 datafiles for this tablespace.
Each datafile has 1 GIG.
Out of the 1 GIG per datafile, only 30 -50 %
is used.
I have come to a conclusion that the spaces
are not contigous. Also the tablespace has
250 tables(big, medium and small). Also most
of the small to medium tables has a lot of
extents.
This is what I have decided to do:
1.Export the entire database with compress=y
NOTE:The only table with a lot of extents
is 650M.
2.Drop all the tables/truncate the
tables with drop storage
3.Import all entire database
What do you guys think about this approach?
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
|