大家都知道要查询表空间的使用情况可以通过查询其视图写长长的一段脚本，我想大家都会写了。可是否有简便的方法呢？接下来我们看下如下例子：

    db1-> sqlplus / as sysdba

    SQL*Plus: Release 10.2.0.4.0 - Production on Thu Sep 24 14:59:14 2009

    Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

    Connected to:

    Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

    With the Partitioning, Real Application Clusters, OLAP, Data Mining

    and Real Application Testing options

    SQL> select * from sm$ts_used;

    TABLESPACE_NAME                     BYTES

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

    SL_DATA_TS                     5310775296

    SYSAUX                          984809472

    UNDOTBS1                        664928256

    USERS                          7447576576

    TEST                           2019229696

    SYSTEM                          939720704

    BCLOG                            19070976

    UNDOTBS2                         95354880

    8 rows selected.

    SQL> select * from sm$ts_free;

    TABLESPACE_NAME                     BYTES

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

    SL_DATA_TS                     1421475840

    UNDOTBS1                        462225408

    SYSAUX                           88866816

    USERS                          2018050048

    TEST                           1227096064

    SYSTEM                          133955584

    UNDOTBS2                       1058013184

    BCLOG                          1079771136

    8 rows selected.

    SQL>

    是不是觉得方便多得多呢。

建议继续学习：

1. Innodb文件表空间结构    (阅读：3475)
2. Innodb共享表空间VS独立表空间    (阅读：2229)