Determine the Number and Size of Extents (13)

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

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

文章标签：

本文介绍了表空间管理中本地管理的两种类型：统一管理和系统管理。统一管理允许指定固定大小的扩展区，而系统管理则由Oracle自动确定最优的扩展区大小。文章还详细解释了不同设置下的工作原理和技术细节。

A tablespace that manages its extents locally can have either uniform extent sizes or
variable extent sizes that are determined automatically by the system. When you
create the tablespace, the UNIFORM or AUTOALLOCATE (system-managed) clause
specifies the type of allocation.
■ For uniform extents, you can specify an extent size or use the default size, which is
1 MB. Ensure that each extent contains at least five database blocks, given the
database block size. Temporary tablespaces that manage their extents locally can
only use this type of allocation.
■ For system-managed extents, Oracle determines the optimal size of additional
extents, with a minimum extent size of 64 KB. If the tablespaces are created with 'segment space management auto’, and if the database block size is 16K or higher, then Oracle manages segment size by creating extents with a minimum size of 1M.This is the default for permanent tablespaces.

The storage parameters INITIAL, NEXT, PCTINCREASE, and MINEXTENTS cannot be
specified at the tablespace level for locally managed tablespaces. They can, however,
be specified at the segment level. In this case, INITIAL, NEXT, PCTINCREASE, and
MINEXTENTS are used together to compute the initial size of the segment. After the
segment size is computed, internal algorithms determine the size of each extent.

[@more@]

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

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