您当前位置:设计在线网 >> Oracle >> 浏览文章

oracle存储大小查看语句执行(示例)

分享到:
本文章讲述了oracle存储大小查看语句执行(示例).

[email protected]:/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>

推荐阅读:
有关图书馆信息管理系统简介
简述Oracle利用UTL_INADDR注入
实例讲解:解决Slave_SQL_Running:Nomysql故障

相关文章:

推荐文章  
赞助商链接  
热门排行  
主题推广  
中国设计在线网 All Rights Reserved. 互联网违法和不良信息举报
信息产业部备案号:湘ICP备09001063号