DEFERRED_SEGMENT_CREATION

彦祖的小号

于 2021-07-14 13:34:12 发布

阅读量124

点赞数

分类专栏： Oracle 文章标签： python

本文链接：https://blog.csdn.net/linsuhangoracle/article/details/118725553

版权

Oracle 专栏收录该内容

193 篇文章 0 订阅

订阅专栏

Oracle11gR2 新加参数 DEFERRED_SEGMENT_CREATION, 默认TRUE
By default, the database uses deferred segment creation to update only database metadata when creating tables, indexes, and partitions. When a user inserts the first row into a table or partition, the database creates segments for the table or partition, its LOB columns, and its indexes.
Deferred segment creation avoids using database resources unnecessarily. For example, installation of an application can create thousands of objects, consuming significant disk space. Many of these objects may never be used.
Show parameter deferred_segment_creation
也可以在创建segment时声明：
create table scott.t1(id int,name char(10) SEGMENT CREATION IMMEDIATE;
create table scott.t1(id int,name char(10) SEGMENT CREATION DEFERRED;
select table_name, segment_created from user_tables ;