查 Datafile 大小

2013-07-26 13:34
[oracle@SIPDB ~]$ sqlplus / as sysdba
 
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 26 13:31:48 2013
 
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
SQL> select tablespace_name,sum(bytes)/1024/1024/1024 from dba_data_files group by tablespace_name;
 
TABLESPACE_NAME                SUM(BYTES)/1024/1024/1024
------------------------------ -------------------------
UNDOTBS1                                      6.11816406
SYSAUX                                           .859375
USERS                                         2.91625977
SYSTEM                                        .712890625
EXAMPLE                                        .09765625
STRM_TBS                                               2
 
6 rows selected.