SYS@orcl>select * from dba_tablespace_usage_metrics;
Tablespace USED_SPACE TABLESPACE_SIZE USED_PERCENT
-------------------- ---------- --------------- ------------
CAT
920
128071.88
EXAMPLE
10272 4194302
.24
SYSAUX
31272 4194302
.75
SYSTEM
58016 4194302 1.38
TEMP
0 4194302
.00
UNDOTBS1
192 4194302
.00
脚本查询:
Tablespace File
Free(M) Total(M)Used(%)
-------------------- ------------------------- ---------- ---------- ----------
CAT
2.75 10 73
SYSAUX
15.625260 94
SYSTEM
26.6875480 95
EXAMPLE
69.6875150 54
UNDOTBS1
18.1875 25 28
脚本:
SYS@orcl>select b.tablespace_name,
2substr(b.file_name,instr(b.file_name,'',-1,1)+1) as "filename",
3a.bytes/1024/1024 as "Free(M)",
4b.bytes/1024/1024 as "Total(M)",
5(1-trunc(a.bytes/b.bytes,2))*100 as "Used(%)"
6from (select tablespace_name,file_id,sum(bytes) as bytes
7from dba_free_space group by tablespace_name,FILE_ID) a,
8dba_data_files b
9where a.file_id=b.file_id
10;
请教一下是怎么回事
|