查看表空间的容量
来源:互联网 发布:linux 退出gdb调试 编辑:程序博客网 时间:2024/06/05 02:11
set line 300 pages 2000
Select d.tablespace_name,
Space "Sum_space(M)",
Blocks sum_blocks,
Space - nvl(free_space, 0) "Used_space(M)",
round((1 - nvl(free_space, 0) / Space) * 100, 2) "Used_rate(%)",
free_space "Free_space(M)"
From (Select tablespace_name,
round(Sum(bytes) / (1024 * 1024), 2) Space,
Sum(blocks) Blocks
From dba_data_files
Group By tablespace_name) d,
(Select tablespace_name,
round(Sum(bytes) / (1024 * 1024), 2) free_space
From dba_free_space
Group By tablespace_name) f
Where d.tablespace_name = f.tablespace_name(+)
Union All
Select d.tablespace_name,
Space "Sum_space(M)",
blocks sum_blocks,
used_space "Used_space(M)",
round(nvl(used_space, 0) / Space * 100, 2) "Used_rate(%)",
nvl(free_space, 0) "Free_space(M)"
From (Select tablespace_name,
round(Sum(bytes) / (1024 * 1024), 2) Space,
Sum(blocks) blocks
From dba_temp_files
Group By tablespace_name) d,
(Select tablespace_name,
round(Sum(bytes_used) / (1024 * 1024), 2) used_space,
round(Sum(bytes_free) / (1024 * 1024), 2) free_space
From v$temp_space_header
Group By tablespace_name) f
Where d.tablespace_name = f.tablespace_name(+);
--------eg.
TABLESPACE_NAME Sum_space(M) SUM_BLOCKS Used_space(M) Used_rate(%) Free_space(M)
------------------------------ -------------------- -------------------- -------------------- -------------------- --------------------
BOSSDATA 784248 100383744 187199.44 23.87 597048.56
SYSTEM 2047 262016 299.5 14.63 1747.5
UNDOTBS1 40867 5230976 1192.06 2.92 39674.94
TEMP 16380 2096640 11786 71.95 4594
Select d.tablespace_name,
Space "Sum_space(M)",
Blocks sum_blocks,
Space - nvl(free_space, 0) "Used_space(M)",
round((1 - nvl(free_space, 0) / Space) * 100, 2) "Used_rate(%)",
free_space "Free_space(M)"
From (Select tablespace_name,
round(Sum(bytes) / (1024 * 1024), 2) Space,
Sum(blocks) Blocks
From dba_data_files
Group By tablespace_name) d,
(Select tablespace_name,
round(Sum(bytes) / (1024 * 1024), 2) free_space
From dba_free_space
Group By tablespace_name) f
Where d.tablespace_name = f.tablespace_name(+)
Union All
Select d.tablespace_name,
Space "Sum_space(M)",
blocks sum_blocks,
used_space "Used_space(M)",
round(nvl(used_space, 0) / Space * 100, 2) "Used_rate(%)",
nvl(free_space, 0) "Free_space(M)"
From (Select tablespace_name,
round(Sum(bytes) / (1024 * 1024), 2) Space,
Sum(blocks) blocks
From dba_temp_files
Group By tablespace_name) d,
(Select tablespace_name,
round(Sum(bytes_used) / (1024 * 1024), 2) used_space,
round(Sum(bytes_free) / (1024 * 1024), 2) free_space
From v$temp_space_header
Group By tablespace_name) f
Where d.tablespace_name = f.tablespace_name(+);
--------eg.
TABLESPACE_NAME Sum_space(M) SUM_BLOCKS Used_space(M) Used_rate(%) Free_space(M)
------------------------------ -------------------- -------------------- -------------------- -------------------- --------------------
BOSSDATA 784248 100383744 187199.44 23.87 597048.56
SYSTEM 2047 262016 299.5 14.63 1747.5
UNDOTBS1 40867 5230976 1192.06 2.92 39674.94
TEMP 16380 2096640 11786 71.95 4594
- 查看表空间的容量
- ORACLE查看表空间容量及剩余容量
- 表空间容量查看与增加undo表空间
- oracle 表空间下表的容量
- dba_segments 查看表使用的容量
- 查看Linux磁盘容量,空间大小
- 表空间的查看
- oracle数据库的最大数据容量限制和表空间的最大数据容量限制
- ORACLE更改表空间容量
- 扩展undo表空间容量
- oracle表空间容量查询
- ORACLE数据库、表空间、表的容量相关查询--1
- 如何检测Oracle的可用性和表空间容量
- oracle数据库和表空间的最大数据容量限制
- 预估表和索引空间容量的方法
- 【数据库】MYSQL查看数据库所占空间大小容量命令
- oracle 表空间的查看
- 查看表空间的大小
- dba_segments 查看表使用的容量
- linux或者UC/OS
- 第一章-内核模块
- Eclipse中java文件和jsp字体大小设置
- 对于OATableBean&OAAdvancedTableBean中NUMBER数据按指定格式显示
- 查看表空间的容量
- Android Log
- 【Unity3D 游戏开发之一】搭建Unity3D环境&导出自带Demo示例
- 炫彩界面库设计
- Session的生命周期
- 重新定位自己
- 实际项目中的常见算法
- Asp.net Jquery Dialog 2
- 一些琐碎的思绪