Oracle 11gR2 创建无数据对象临时不分配segment
做实验发现Oracle11gR2,创建无数据的table、index等对象,oracle为了节省空间,开始并不分配segment,而是等有dml操作时才会分配segment,即使dml回滚,分配的segment并不回收。
简单实验如下:
SQL> create table test(a number);
Table created.
SQL> create index ind_test on test(a);
Index created.
QL> select segment_name,bytes from dba_segments wheresegment_name='TEST' and owner='WXLUN';
no rows selected
SQL> insert into test values(1);
1 row created.
SQL>
SQL> col SEGMENT_NAME for a22
SQL> select segment_name,bytes from dba_segments wheresegment_name in ('TEST','IND_TEST') and owner='WXLUN';
SEGMENT_NAME
BYTES
---------------------- ----------
IND_TEST
相关推荐
dxyadc 2020-06-26
某某某 2020-01-12
hell0kitty 2019-10-21
molong0 2019-05-08
tpyangqingyuan 2019-01-10
ReganHoo 2010-12-03
IceStreamLab 2019-07-01
ShoppingChen 2019-01-10
独苏揽月 2019-06-28
forrestou 2019-06-27
mojianc 2019-06-27
Cei语言 2014-04-24
wasdzjh 2019-05-06
JackSparrow 2018-08-03
der 2019-02-12
xianyuxiaoqiang 2018-09-28
forrestou 2018-09-26
wumingxiaozei 2018-02-10
HANHUABAO 2015-05-24