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/