- <>
选择一个。tablespace_name“tbsname”, 100圆(nvl (b.bytes_free, 0)/a.bytes_alloc) * 100, 2)“比”,
轮(a.bytes_alloc/1024/1024, 2)“大小(M)”轮(nvl (b.bytes_free, 0)/1024/1024, 2)“自由(M)”,
(a.bytes_alloc-nvl (b.bytes_free, 0))/1024/1024, 2)“usedM)”to_char (sysdate”yyyy-mm-dd hh34: mi: ss”)“get_time”
(
选择f。tablespace_name,总和(f.bytes) bytes_alloc总和(解码(f.maxbytes f.autoextensible,‘是的’,‘不’,f.bytes)) maxbytes从dba_data_files f
group by tablespace_name),
(选择f。tablespace_name总和(f.bytes) bytes_free从dba_free_space f
group by tablespace_name) b
。tablespace_name=b。tablespace_name
订单2,
2。
选择D。SUM_SPACE TABLESPACE_NAME,空间”(M)”、块
SUM_BLOCKS SPACE-NVL (FREE_SPACE, 0)“USED_SPACE (M)”,
(1-NVL (FREE_SPACE, 0)/空间)* 100,2)“USED_RATE (%)”,FREE_SPACE
“FREE_SPACE (M)“
(选择TABLESPACE_NAME,圆(总和(字节数)/(1024 * 1024),2)
空间,总和(块)块从DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) D
(选择TABLESPACE_NAME,圆(总和(字节数)/(1024 * 1024),2)FREE_SPACE从DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F
D。TABLESPACE_NAME=F.TABLESPACE_NAME (+)
UNION ALL——如果有tempfile
选择D。SUM_SPACE TABLESPACE_NAME,空间”(M)”块SUM_BLOCKS
USED_SPACE“USED_SPACE (M)”,圆(NVL (USED_SPACE, 0)/空间* 100,2)
“USED_RATE (%)”,
NVL (FREE_SPACE, 0)“FREE_SPACE (M)”从
(选择TABLESPACE_NAME,圆(总和(字节数)/(1024 * 1024),2)
空间,总和(块)块从DBA_TEMP_FILES
GROUP BY TABLESPACE_NAME) D
(选择TABLESPACE_NAME,圆(总和(BYTES_USED)/(1024 * 1024), 2)
USED_SPACE,
轮(总和(BYTES_FREE)/(1024 * 1024), 2) FREE_SPACE
从V $ TEMP_SPACE_HEADER
GROUP BY TABLESPACE_NAME) F
D。TABLESPACE_NAME=F.TABLESPACE_NAME (+)
