1Z0-062 · Question #161
Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled. You want to perform online segment shrink to reclaim f
The correct answer is A. Row movement is enabled.. Online segment shrink requires row movement to be enabled on the table so Oracle can relocate rows to compact the segment below the high water mark.
Question
Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled. You want to perform online segment shrink to reclaim fragmented free space below the high water mark. What should you ensure before the start of the operation?
Exhibit
Options
- ARow movement is enabled.
- BReferential integrity constraints for the table are disabled.
- CNo queries are running on this table.
- DExtra disk space equivalent to the size of the segment is available in the tablespace.
- ENo pending transaction exists on the table.
How the community answered
(36 responses)- A86% (31)
- C6% (2)
- D6% (2)
- E3% (1)
Why each option
Online segment shrink requires row movement to be enabled on the table so Oracle can relocate rows to compact the segment below the high water mark.
Online segment shrink physically moves rows toward the beginning of the segment and then resets the high water mark; because row addresses (rowids) change during this process, Oracle requires row movement to be explicitly enabled via ALTER TABLE ... ENABLE ROW MOVEMENT before the operation can proceed.
Referential integrity constraints do not need to be disabled because segment shrink moves rows within the same table without altering the data values that foreign keys reference.
Online segment shrink is specifically designed to run concurrently with queries and DML; the table does not need to be idle.
Segment shrink reclaims and reuses space within the existing segment rather than creating a copy, so no additional free space equal to the segment size is required.
Pending transactions are not a blocking prerequisite; the online shrink operation handles row-level concurrency internally and does not require a transaction-free table.
Concept tested: Oracle online segment shrink row movement prerequisite
Source: https://docs.oracle.com/database/121/ADMIN/schema.htm#ADMIN13357
Topics
Community Discussion
No community discussion yet for this question.
