select f.tname "TableSpace",
round(sum(d.bytes)/1024, 0) "Total(KByte)",
round((sum(d.bytes) - sum(f.bytes))/1024, 0) "UsedSpace(KByte)",
round((sum(d.bytes) - sum(f.bytes))/sum(d.bytes)*100, 0) "Used(%)",
round(sum(f.bytes)/1024, 0) "FreeSpace(KByte)"
from
(select sum(bytes) bytes,
tablespace_name tname
from dba_free_space
group by tablespace_name) f,
(select sum(bytes) bytes,
tablespace_name tname
from dba_data_files
group by tablespace_name) d
where f.tname = d.tname
group by f.tname
round(sum(d.bytes)/1024, 0) "Total(KByte)",
round((sum(d.bytes) - sum(f.bytes))/1024, 0) "UsedSpace(KByte)",
round((sum(d.bytes) - sum(f.bytes))/sum(d.bytes)*100, 0) "Used(%)",
round(sum(f.bytes)/1024, 0) "FreeSpace(KByte)"
from
(select sum(bytes) bytes,
tablespace_name tname
from dba_free_space
group by tablespace_name) f,
(select sum(bytes) bytes,
tablespace_name tname
from dba_data_files
group by tablespace_name) d
where f.tname = d.tname
group by f.tname
'만사가귀찮아' 카테고리의 다른 글
SAP Request 상태 수정 (0) | 2008.06.16 |
---|---|
ORA-01008 (SAP ABAP) (0) | 2008.06.16 |
SAP BTE : Business Transaction Events (0) | 2008.06.16 |
sap 유용 program (0) | 2008.06.16 |
Window 공유 삭제 (0) | 2008.06.16 |