当前所在位置:珠峰网资料 >> 计算机 >> Oracle认证 >> 正文
oracle存储大小查看语句
发布时间:2011/3/7 10:33:00 来源:城市学习网 编辑:ziteng

    oracle@T218NP01:/home/db/oracle#sqlplus '/as sysdba'
    SQL*Plus: Release 10.2.0.3.0 - Production on Mon Oct 18 16:36:32 2010
    Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
    With the Partitioning, Real Application Clusters, OLAP and Data Mining options
    SQL> desc dba_data_files
    Name                                      Null?    Type
    ----------------------------------------- -------- ----------------------------
    FILE_NAME                                          VARCHAR2(513)
    FILE_ID                                            NUMBER
    TABLESPACE_NAME                                    VARCHAR2(30)
    BYTES                                              NUMBER
    BLOCKS                                             NUMBER
    STATUS                                             VARCHAR2(9)
    RELATIVE_FNO                                       NUMBER
    AUTOEXTENSIBLE                                     VARCHAR2(3)
    MAXBYTES                                           NUMBER
    MAXBLOCKS                                          NUMBER
    INCREMENT_BY                                       NUMBER
    USER_BYTES                                         NUMBER
    USER_BLOCKS                                        NUMBER
    ONLINE_STATUS                                      VARCHAR2(7)
    SQL> select FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024 from dba_data_files;
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rsystem
    SYSTEM                                    4000
    /dev/vgdata/rundotbs1
    UNDOTBS1                                 10235
    /dev/vgdata/rsysaux
    SYSAUX                                    4000
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rtools
    TOOLS                                     1000
    /dev/vgdata/rundotbs2
    UNDOTBS2                                 10000
    /dev/vgdata/rusers
    USERS                                       60
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rtbs_ciss02_01_1
    TBS_CISS02_01                            20000
    /dev/vgdata/rtbs_ciss02_01_2
    TBS_CISS02_01                            20000
    /dev/vgdata/rtbs_ciss02_02_1
    TBS_CISS02_02                            20000
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rtbs_ciss02_02_2
    TBS_CISS02_02                            20000
    /dev/vgdata/rtbs_ciss08_01_1
    TBS_CISS08_01                            20000
    /dev/vgdata/rtbs_ciss08_01_2
    TBS_CISS08_01                            20000
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rtbs_ciss08_01_3
    TBS_CISS08_01                            20000
    /dev/vgdata/rtbs_ciss08_01_4
    TBS_CISS08_01                            20000
    /dev/vgdata/rtbs_ciss08_02_1
    TBS_CISS08_02                            20000
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rtbs_ciss08_02_2
    TBS_CISS08_02                            20000
    /dev/vgdata/rtbs_ciss08_02_3
    TBS_CISS08_02                            20000
    /dev/vgdata/rtbs_ciss08_02_4
    TBS_CISS08_02                            20000
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rindx_ciss08_01_1
    INDX_CISS08_01                           20000
    /dev/vgdata/rindx_ciss08_01_2
    INDX_CISS08_01                           20000
    /dev/vgdata/rindx_ciss08_01_3
    INDX_CISS08_01                           20000
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rtbs_ciss08_03_1
    TBS_CISS08_03                            20000
    /dev/vgdata/rtbs_ciss08_03_2
    TBS_CISS08_03                            20000
    /dev/vgdata/rtbs_ciss08_03_3
    TBS_CISS08_03                            20000
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rtbs_ciss08_03_4
    TBS_CISS08_03                            20000
    /dev/vgdata/rindx_ciss02_01_1
    INDX_CISS02_01                           20000
    /dev/vgdata/rindx_ciss02_01_2
    INDX_CISS02_01                           20000
    FILE_NAME
    --------------------------------------------------------------------------------
    TABLESPACE_NAME                BYTES/1024/1024
    ------------------------------ ---------------
    /dev/vgdata/rindx_ciss02_01_3
    INDX_CISS02_01                           20000
    28 rows selected.
    SQL>

广告合作:400-664-0084 全国热线:400-664-0084
Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15066211号
珠峰网 版权所有 All Rights Reserved