oracle 查看表空间大小
来源:互联网 发布:做漫画用什么软件 编辑:程序博客网 时间:2024/05/16 11:12
set linesize 200;
SELECT d.status "Status",
d.tablespace_name "Name",
d.contents "Type",
d.extent_management "Extent Management",
NVL(a.bytes / 1024 / 1024, 0) "Size (M)",
NVL(a.bytes - NVL(f.bytes, 0), 0) / 1024 / 1024 "Used (M)",
NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0) "Used %"
FROM sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) a,
(select tablespace_name, sum(bytes) bytes
from dba_free_space
group by tablespace_name) f
WHERE d.tablespace_name = a.tablespace_name(+) AND
d.tablespace_name = f.tablespace_name(+) AND
NOT
(d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY')
UNION ALL
SELECT d.status "Status",
d.tablespace_name "Name",
d.contents "Type",
d.extent_management "Extent Management",
NVL(a.bytes / 1024 / 1024, 0) "Size (M)",
NVL(t.bytes, 0) / 1024 / 1024 "Used (M)",
NVL(t.bytes / a.bytes * 100, 0) "Used %"
FROM sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes
from dba_temp_files
group by tablespace_name) a,
(select tablespace_name, sum(bytes_cached) bytes
from v$temp_extent_pool
group by tablespace_name) t
WHERE d.tablespace_name = a.tablespace_name(+) AND
d.tablespace_name = t.tablespace_name(+) AND
d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY';
SELECT d.status "Status",
d.tablespace_name "Name",
d.contents "Type",
d.extent_management "Extent Management",
NVL(a.bytes / 1024 / 1024, 0) "Size (M)",
NVL(a.bytes - NVL(f.bytes, 0), 0) / 1024 / 1024 "Used (M)",
NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0) "Used %"
FROM sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) a,
(select tablespace_name, sum(bytes) bytes
from dba_free_space
group by tablespace_name) f
WHERE d.tablespace_name = a.tablespace_name(+) AND
d.tablespace_name = f.tablespace_name(+) AND
NOT
(d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY')
UNION ALL
SELECT d.status "Status",
d.tablespace_name "Name",
d.contents "Type",
d.extent_management "Extent Management",
NVL(a.bytes / 1024 / 1024, 0) "Size (M)",
NVL(t.bytes, 0) / 1024 / 1024 "Used (M)",
NVL(t.bytes / a.bytes * 100, 0) "Used %"
FROM sys.dba_tablespaces d,
(select tablespace_name, sum(bytes) bytes
from dba_temp_files
group by tablespace_name) a,
(select tablespace_name, sum(bytes_cached) bytes
from v$temp_extent_pool
group by tablespace_name) t
WHERE d.tablespace_name = a.tablespace_name(+) AND
d.tablespace_name = t.tablespace_name(+) AND
d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY';
0 0
- oracle表空间大小查看
- 查看oracle表空间大小
- 查看oracle表空间大小
- Oracle查看表空间大小
- 查看oracle表空间大小
- oracle 查看表空间大小
- oracle 查看表空间大小
- 查看Oracle表空间大小
- ORACLE查看表空间大小
- 查看ORACLE表空间大小及所剩空间大小
- 查看oracle表空间大小、使用情况
- ORACLE 查看各表空间大小
- Oracle-查看表空间大小(小总结)
- 查看Oracle表空间大小的方法
- 查看Oracle数据库表空间大小
- 查看oracle表空间已使用大小
- 查看Oracle表空间大小的方法
- 查看Oracle表空间大小的方法
- sql server日期时间转字符串
- java基础学习记录之利用数组进行进制转换的学习与练习五
- Mac 操作
- Matlab中的匿名函数的使用
- HDU 1114 又见完全背包问题(必须装满)
- oracle 查看表空间大小
- 浙大PAT 1024. Palindromic Number (25)
- 发现一个c++中代替goto的方法
- 频率抽取(DIF)基2FFT算法的MATLAB实现
- 深入理解OAuth2.0协议
- linux下brctl配置网桥
- poj2262
- JEP 192 String Deduplication in G1
- sql 通配符