简便查询表空间的使用情况
db1-> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Sep 24 14:59:14 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select * from sm$ts_used;
TABLESPACE_NAME BYTES
------------------------------ ----------
SL_DATA_TS 5310775296
SYSAUX 984809472
UNDOTBS1 664928256
USERS 7447576576
TEST 2019229696
SYSTEM 939720704
BCLOG 19070976
UNDOTBS2 95354880
8 rows selected.
SQL> select * from sm$ts_free;
TABLESPACE_NAME BYTES
------------------------------ ----------
SL_DATA_TS 1421475840
UNDOTBS1 462225408
SYSAUX 88866816
USERS 2018050048
TEST 1227096064
SYSTEM 133955584
UNDOTBS2 1058013184
BCLOG 1079771136
8 rows selected.
SQL>
是不是觉得方便多得多呢。
建议继续学习:
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:Mike.Xu 来源: DBA Blog
- 标签: 表空间
- 发布时间:2009-10-12 09:08:51
- [69] Twitter/微博客的学习摘要
- [65] find命令的一点注意事项
- [64] 如何拿下简短的域名
- [64] IOS安全–浅谈关于IOS加固的几种方法
- [62] Go Reflect 性能
- [62] android 开发入门
- [61] 流程管理与用户研究
- [59] Oracle MTS模式下 进程地址与会话信
- [58] 读书笔记-壹百度:百度十年千倍的29条法则
- [58] 图书馆的世界纪录