What is segment shrink?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is segment shrink?
Rating:
Segment shrink is a mechanism available in Oracle 10g. It compresses the data blocks in a table or index and optionally moves the High-Water-Mark (HWM) down, making the unused space available for other segments in the tablespace.
Rating:
Was this information helpful?
Other articles
- What is OFA?
- What is the DBMS_FILE_TRANSFER package?
- What is the quote operator?
- What is DBMS_WORKLOAD_REPOSITORY?
- What is the DB_CACHE_SIZE parameter?
