测试oracle表空间自动扩展特性与分配固定size的关系(存储属性)

bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 16 00:51:19 2009

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

 

SQL>select tablespace_name,sum(bytes/1024/1024) mb from dba_segments where tablespace_name='AAA' group by tablespace_name  ----查询aaa表空间的目前使用大小

TABLESPACE_NAME                        MB

------------------------------ ----------

AAA                                   446

SQL> select tablespace_name,bytes/1024/1024 mb from dba_data_files;  ---查询aaa表空间的分配大小

TABLESPACE_NAME                        MB

------------------------------ ----------

USERS                                   5

SYSAUX                                390

UNDOTBS1                              580

SYSTEM                                490

AAA                                   450

SQL> select tablespace_name,autoextensible from dba_data_files;---查询aaa表空间是否自动扩展

TABLESPACE_NAME                AUT

------------------------------ ---

USERS                          YES

SYSAUX                         YES

UNDOTBS1                       YES

SYSTEM                         YES

AAA                            YES

SQL> select tablespace_name,maxblocks*8 from dba_data_files;---查询aaa表空间最大扩展大小（注：当表空间开启了自动扩展特性，表空间会一直扩展到操作系统支持的最大大小）

TABLESPACE_NAME                MAXBLOCKS*8

------------------------------ -----------

USERS                             33554416

SYSAUX                            33554416

UNDOTBS1                          33554416

SYSTEM                            33554416

AAA                               33554416

SQL>

基于 以上.所以此表空间不用手工再次扩展了.

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

转载于:http://blog.itpub.net/9240380/viewspace-589346/