|
I'm a little unclear what your question is. You
haven't missed anything except for the newer features
of Oracle that make items like the ALTER TABLESPACE
COALESCE command obsolete for today's Oracle DBA. This
command will only defragment contiguous chunks of free
space. It will not move any objects around, and it will
not defragment objects. Additionally, if the default
value for PCTINCREASE is a non-zero value for this
tablespace, SMON will automatically coalesce free
space for that tablespace, in effect issuing the above
command for you.
If you read my answer
again, and using your own comments, you will notice
that "This does not always pull the free space
together but, most of the time it does." Your solution
was to export/import the objects to fix this problem.
My solution is to use Oracle's new Locally Managed
Tablespaces with uniform extents sizes. This way, you
don't have to periodically issue the ALTER TABLESPACE
COALESCE command, and you don't have to worry about
ever having chunks of free space too small to use.
Granted, my solution isn't easier in the short term,
but I believe it to be a better solution in the long
term.
For More Information
|
