ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXTENT MANAGEMENT-SYSTEM

EXTENT MANAGEMENT-SYSTEM

原创 Linux操作系统 作者:comfeng 时间:2008-05-17 16:27:08 0 删除 编辑

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 04:16:44 2008

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

SQL> connect / as sysdba
Connected.
SQL> create tablespace test
  2  datafile '/u01/app/oracle/oradata/orcl/test01.dbf'
  3  size 100M
  4  autoextend on next 50M maxsize unlimited
  5  extent management local;          

Tablespace created.

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 04:21:28 2008

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

SQL> connect / as sysdba
Connected.
SQL> select tablespace_name,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEST';

TABLESPACE_NAME                EXTENT_MAN ALLOCATIO
------------------------------ ---------- ---------
TEST                           LOCAL      SYSTEM

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 05:10:25 2008

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

SQL> connect / as sysdba
Connected.
SQL> select initial_extent/1024 from dba_tablespaces where tablespace_name='TEST';

INITIAL_EXTENT/1024
-------------------
                 64

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 05:14:55 2008

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

SQL> connect / as sysdba
Connected.
SQL> create table table1(x number)
  2  tablespace test
  3  storage(initial 70K next 70K);

Table created.

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 05:23:51 2008

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

SQL> connect / as sysdba
Connected.
SQL> select extent_id,bytes/1024 from dba_extents where segment_name='TABLE1' and segment_type='TABLE';

 EXTENT_ID BYTES/1024
---------- ----------
         0         64
         1         64

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 06:02:43 2008

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

SQL> connect / as sysdba
Connected.
SQL> create table table2(x number)
  2  tablespace test
  3  storage(initial 130M next 130M);

Table created.

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 17 06:10:38 2008

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

SQL> connect / as sysdba
Connected.
SQL> select extent_id,bytes/1024/1024 from dba_extents where segment_name='TABLE2' and segment_type='TABLE';

 EXTENT_ID BYTES/1024/1024
---------- ---------------
         0               8
         1               8
         2               8
         3               8
         4               8
         5               8
         6               8
         7               8
         8               8
         9               8
        10               8

 EXTENT_ID BYTES/1024/1024
---------- ---------------
        11               8
        12               8
        13               8
        14               8
        15               8
        16               8

17 rows selected.

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

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

下一篇: SSH
请登录后发表评论 登录
全部评论

注册时间:2008-05-13

  • 博文量
    5
  • 访问量
    11105