測試oracle表空間自動擴充套件特性與分配固定size的關係(儲存屬性)

wisdomone1發表於2009-04-16

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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章