首页 > 应用开发 > IT综合 > Locally Managed Tablespaces (50)

Locally Managed Tablespaces (50)

原创 IT综合 作者:tsinglee 时间:2007-09-29 17:49:50 0 删除 编辑

A tablespace that manages its own extents maintains a bitmap in each datafile to keep
track of the free or used status of blocks in that datafile. Each bit in the bitmap
corresponds to a block or a group of blocks. When an extent is allocated or freed for
reuse, Oracle changes the bitmap values to show the new status of the blocks. These
changes do not generate rollback information because they do not update tables in the
data dictionary (except for special cases such as tablespace quota information).
Locally managed tablespaces have the following advantages over dictionary managed
1 Local management of extents automatically tracks adjacent free space, eliminating
the need to coalesce free extents.
2 Local management of extents avoids recursive space management operations.
Such recursive operations can occur in dictionary managed tablespaces if
consuming or releasing space in an extent results in another operation that
consumes or releases space in a data dictionary table or rollback segment.

1. 每个数据文件通过维护一个位图来跟踪
2. 当一个区间被分配或者释放 , Oracle更新位图的值来说明块的状态 , 不产生回滚信息
3. lmt相比dmt有如下优势
a. lmt不用合并空间的区间
b. 避免空间管理的递归


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量