Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2519158
  • 博文数量: 323
  • 博客积分: 10211
  • 博客等级: 上将
  • 技术积分: 4934
  • 用 户 组: 普通用户
  • 注册时间: 2006-08-27 14:56
文章分类

全部博文(323)

文章存档

2012年(5)

2011年(3)

2010年(6)

2009年(140)

2008年(169)

分类: Oracle

2008-07-05 16:24:22

$ sqlplus "/as sysdba"
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 * from sm$ts_used;
TABLESPACE_NAME                     BYTES
------------------------------ ----------
SYSTEM                          510197760
USERS                             3080192
TBS_1                              196608
SYSAUX                          433586176
EXAMPLE                          79953920
UNDOTBS1                         17104896
6 rows selected.
SQL> select * from sm$ts_free;
TABLESPACE_NAME                     BYTES
------------------------------ ----------
SYSTEM                            3538944
USERS                             2097152
TBS_1                           104660992
SYSAUX                            6750208
EXAMPLE                          77266944
UNDOTBS1                        203030528
TBS_2                           104792064
7 rows selected.
 
查看这两个视图的定义:
 
SQL> select text from dba_views where view_name='SM$TS_USED';
TEXT
--------------------------------------------------------------------------------
select tablespace_name, sum(bytes) bytes from dba_segments
    group by tablespace_name

SQL> select text from dba_views where view_name='SM$TS_FREE';
TEXT
--------------------------------------------------------------------------------
select tablespace_name, sum(bytes) bytes from dba_free_space
    group by tablespace_name
阅读(1328) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~