随着时间的流逝,在表空间的对象上执行DML操作会产生单个的不是足够大用来重新使用的空间,但是如果这些空的空间汇总起来的话会产生空间的巨大浪费,这些极度分散的不断增加的对象会导致查询和DML操作性能的下降。
Oracle Database enables you reclaim this empty space with the following online operations—that is, operations that do not block queries or DML against affected objects while the operations are proceeding:
oracle会使你能够在开机状态下释放这些空的空间,而且这些操作不会阻塞任何查询或DML对于收缩的对象
-
Online segment shrink
Online segment shrink operates on table segments and on the segments of the dependent objects of the table, such as indexes and partitions. For each segment, data is compacted to the front of the segment. Free space can either be returned to the tablespace or kept in the segment for future insert operations.
Online segment shrink is permitted only on segments in a locally managed tablespace with automatic segment space management. Online segment shrink is an in-place operation; no additional free space in the tablespace is required.
线上段收缩只对本地ASSM管理的段有效。线上段收缩是一个本地化的操作,不需要额外的表空间。
-
Online table redefinition (also known as reorganization)
Reorganization relocates the table and its dependent objects in a different part of the tablespace. This operation has the desirable side effect of compacting the data for those objects. For this operation to succeed, however, the tablespace must have free space equal to the size of the table and its dependent objects. Reorganization is the only permitted operation for dictionary-managed tablespaces or for locally managed tablespaces with manual segment space management.
The Segment Advisor generates recommendations for shrinking or reorganizing segments that have a significant amount of reclaimable unused space.
段顾问工具会生成推荐信息关于收缩和重组有着大量需要释放的空间的段。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-1869280/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-1869280/