菜鸟大明儿哥

摘要： SELECT Upper(F.TABLESPACE_NAME) "TablespaceName", D.TOT_GROOTTE_MB "Total(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "Used(M)", To_char(Round(( D.TOT_GROOT 阅读全文

摘要： SELECT owner, tablespace_name, ROUND (SUM (BYTES) / 1024 / 1024, 2) "USED(M)" FROM dba_segmentsGROUP BY owner, tablespace_nameORDER BY SUM (BYTES) DES 阅读全文