快速查看表空间的使用情况

最新推荐文章于 2024-04-18 05:32:12 发布

court511024

最新推荐文章于 2024-04-18 05:32:12 发布

阅读量190

点赞数

文章标签：操作系统

通过sm$ts_free,sm$ts_used,sm$ts_avail快速查看表空间使用情况[@more@]

通过sys用户登录

SQL>conn / as sysdba

SQL> select tablespace_name,sum(bytes)/1024/1024 "size(M)" from sm$ts_avail group by tablespace_name;

TABLESPACE_NAME size(M)
------------------------------ ----------
ASB 1424
CDT_LSTD 1024
DEV 1024
DRSYS 20
INDX 20
RBS 50
RCPJ 1024
SMIS_DATA 1024
SYSTEM 280
TEMP 179.375
TOOLS 10
TS_TCMS_DATA 1024
USERS 20

13 rows selected

SQL> select tablespace_name,sum(bytes)/1024/1024 "size(M)" from sm$ts_used group by tablespace_name;

TABLESPACE_NAME size(M)
------------------------------ ----------
ASB 1379.4375
CDT_LSTD 52.6875
DEV 27.75
DRSYS 4.125
RBS 28
RCPJ 8.5625
SMIS_DATA 17.25
SYSTEM 271.492187
TEMP 6.0625
TS_TCMS_DATA 231.3125
USERS 1.125

11 rows selected

SQL> select tablespace_name,sum(bytes)/1024/1024 "size(M)" from sm$ts_free group by tablespace_name;

TABLESPACE_NAME size(M)
------------------------------ ----------
ASB 44.5
CDT_LSTD 971.25
DEV 996.1875
DRSYS 15.8671875
INDX 19.9921875
RBS 21.9921875
RCPJ 1015.375
SMIS_DATA 1006.6875
SYSTEM 8.5
TEMP 173.304687
TOOLS 9.9921875
TS_TCMS_DATA 792.625
USERS 18.8671875

13 rows selected

如果普通用户查看，必须授予 SELECT_CATALOG_ROLE的权限

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/188692/viewspace-903269/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/188692/viewspace-903269/