oracle user表空间使用率,查看ORACLE表空间使用情况

SQL> SELECT TABLESPACE_NAME,OWNER,SUM(BYTES)/1024/1024 MB FROM DBA_SEGMENTS  2  GROUP BY TABLESPACE_NAME,OWNER;

TABLESPACE_NAME                OWNER                                  MB

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

SYSTEM                         SYS                                464.75

SYSTEM                         SYSTEM                             15.375

SYSAUX                         CTXSYS                              4.625

SYSAUX                         SYSMAN                                 54

SYSTEM                         OUTLN                                  .5

EXAMPLE                        SH                                     56

EXAMPLE                        OE                                   6.25

SYSAUX                         DMSYS                                 .25

SYSAUX                         MDSYS                             32.4375

SYSAUX                         OLAPSYS                           15.5625

USERS                          OE                                 2.5625

TABLESPACE_NAME                OWNER                                  MB

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

USERS                          HUYONG                                .25

SYSAUX                         SYSTEM                             6.8125

EXAMPLE                        HR                                 1.5625

EXAMPLE                        PM                                   2.75

UNDOTBS1                       SYS                                5.3125

SYSAUX                         WMSYS                              5.9375

SYSAUX                         SYS                               80.4375

SYSAUX                         TSMSYS                                .25

SYSAUX                         XDB                               48.5625

SYSAUX                         DBSNMP                             1.5625

SYSAUX                         EXFSYS                              3.625

TABLESPACE_NAME                OWNER                                  MB

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

SYSAUX                         ORDSYS                                 .5

USERS                          SCOTT                             88.4375

EXAMPLE                        IX                                  1.625

25 rows selected.