What does coalescing a tablespace do?
Coalescing is reducing de-fragments space by combining neighboring free extents into large single extents.
SQL>ALTER TABLESPACE TS1 COALESCE;
Coalescing is reducing de-fragments space by combining neighboring free extents into large single extents.
SQL>ALTER TABLESPACE TS1 COALESCE;
A table has been identified as needing reorganization. How
would you plan for it? How would you implement it?
Stop the applications
Disable the constraints
Move the table to some other empty tablespace and bring back
Rebuild the indexes
Enable the constraints
Start the Applications
Validate the invalid objects
No comments:
Post a Comment