Oracle存储大小查看语句-优快云博客

本文介绍了一个用于查询Oracle数据库中各表空间存储大小的SQL语句。通过执行该语句，可以获取不同表空间对应的文件名及存储容量（以MB为单位），便于管理员监控和管理数据库存储资源。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

From:http://soft.doit.com.cn/article/2011/1229/6458636.shtml

oracle存储大小查看语句

/*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>/*