How Extents Are Allocated(14)

最新推荐文章于 2025-12-18 10:59:28 发布

转载最新推荐文章于 2025-12-18 10:59:28 发布 · 84 阅读

文章标签：

#数据库

本文介绍了Oracle数据库中表空间管理的不同算法，包括局部管理和字典管理。对于局部管理的表空间，Oracle通过查找候选数据文件及其位图来分配新的扩展区，并在当前文件无法满足需求时转向其他数据文件。

Oracle uses different algorithms to allocate extents, depending on whether they are
locally managed or dictionary managed.
With locally managed tablespaces, Oracle looks for free space to allocate to a new
extent by first determining a candidate datafile in the tablespace and then searching
the datafile’s bitmap for the required number of adjacent free blocks. If that datafile
does not have enough adjacent free space, then Oracle looks in another datafile.[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-968496/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-968496/