oracle 11G新特性延迟段deferred_segment_creation

 

 

 

CREATE TABLE "DBMT"."JUSTFORTEST2" 
   (    "TEST1" VARCHAR2(2)
   )
  TABLESPACE DATA123;
  
  

SQL> @p deferred_segment_creation;

NAME                                     VALUE
---------------------------------------- ----------------------------------------
deferred_segment_creation                TRUE

SQL> 
SQL> CREATE TABLE "DBMT"."JUSTFORTEST2" 
  2     (    "TEST1" VARCHAR2(2)
  3     )
  4    TABLESPACE DATA123;

表已创建。

SQL> @seg DBMT.JUSTFORTEST2

未选定行

SQL> @p deferred_segment_creation

NAME                                     VALUE
---------------------------------------- ----------------------------------------
deferred_segment_creation                FALSE

SQL> CREATE TABLE "DBMT"."JUSTFORTEST" 
  2     (    "TEST1" VARCHAR2(2)
  3     ) SEGMENT CREATION DEFERRED 
  4    TABLESPACE DATA123;

表已创建。

SQL> @seg DBMT.JUSTFORTEST

未选定行

SQL>  insert into DBMT.justForTest values('1');

已创建 1 行。

SQL> rollback
  2  ;

回退已完成。

SQL> @seg DBMT.JUSTFORTEST

    SEG_MB OWNER                SEGMENT_NAME                   SEG_PART_NAME                  SEGMENT_TYPE         SEG_TABLESPACE_NAME                                                                            BLOCKS     HDRFIL     HDRBLK
---------- -------------------- ------------------------------ ------------------------------ -------------------- ------------------------------------------------------------------------------------------ ---------- ---------- ----------
         0 DBMT                 JUSTFORTEST                                                   TABLE                DATA123                                                                                             8         54    3064194

SQL> CREATE TABLE "DBMT"."JUSTFORTEST1" 
  2     (    "TEST1" VARCHAR2(2)
  3     )
  4    TABLESPACE DATA123;

表已创建。

SQL> @seg DBMT.JUSTFORTEST1

    SEG_MB OWNER                SEGMENT_NAME                   SEG_PART_NAME                  SEGMENT_TYPE         SEG_TABLESPACE_NAME                                                                            BLOCKS     HDRFIL     HDRBLK
---------- -------------------- ------------------------------ ------------------------------ -------------------- ------------------------------------------------------------------------------------------ ---------- ---------- ----------
         0 DBMT                 JUSTFORTEST1                                                  TABLE                DATA123                                                                                             8         54    3064226

SQL> exit
从 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0 断开
[oracle@peach:/home/oracle]$ export ORACLE_PATH=~/scifmation/scripts:~/sdbo/scripts  
[oracle@peach:/home/oracle]$  export SQLPATH=~/scifmation/scripts 
[oracle@peach:/home/oracle]$ alias ora="sqlplus / as sysdba" 
[oracle@peach:/home/oracle]$ alias ll="ls -lrt " 
[oracle@peach:/home/oracle]$  ora  

SQL*Plus: Release 19.0.0.0.0 - Production on 星期二 12月 15 14:38:07 2020
Version 19.7.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


连接到: 
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0


USERNAME             INST_NAME            HOST_NAME                 SID   SERIAL#  VERSION    STARTED  SPID            OPID  CPID            SADDR            PADDR
-------------------- -------------------- ------------------------- ----- -------- ---------- -------- --------------- ----- --------------- ---------------- ----------------
SYS                  fruits               peach                     33    5760     19.0.0.0.0 20201215 20781           34    20780           000000008011CD30 00000000815738B8


SQL> alter session set container=wxoadb;

会话已更改。

SQL> @p  show parameter deferred_segment_creation;

NAME                                     VALUE
---------------------------------------- ----------------------------------------
_show_login_pdb_sessions                 FALSE
_show_mgd_recovery_state                 FALSE
_sql_show_expreval                       FALSE

SQL> @p deferred_segment_creation;

NAME                                     VALUE
---------------------------------------- ----------------------------------------
deferred_segment_creation                TRUE

SQL> 
SQL> CREATE TABLE "DBMT"."JUSTFORTEST2" 
  2     (    "TEST1" VARCHAR2(2)
  3     )
  4    TABLESPACE DATA123;

表已创建。

SQL> @seg DBMT.JUSTFORTEST2

未选定行