SELECT a.tablespace_name \u8868\u7a7a\u95f4\u540d,<\/p>\n\n\n\n
total \u8868\u7a7a\u95f4\u5927\u5c0f,<\/p>\n\n\n\n
free \u8868\u7a7a\u95f4\u5269\u4f59\u5927\u5c0f,<\/p>\n\n\n\n
(total – free) \u8868\u7a7a\u95f4\u4f7f\u7528\u5927\u5c0f,<\/p>\n\n\n\n
ROUND((total – free) \/ total, 4) * 100 \u4f7f\u7528\u7387<\/p>\n\n\n\n
FROM (SELECT tablespace_name, ROUND(SUM(bytes) \/ (1024 * 1024), 4) free<\/p>\n\n\n\n
FROM DBA_FREE_SPACE<\/p>\n\n\n\n
GROUP BY tablespace_name) a,<\/p>\n\n\n\n
(SELECT tablespace_name, ROUND(SUM(bytes) \/ (1024 * 1024), 4) total<\/p>\n\n\n\n
FROM DBA_DATA_FILES<\/p>\n\n\n\n
GROUP BY tablespace_name) b<\/p>\n\n\n\n
WHERE a.tablespace_name = b.tablespace_name<\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT a.tablespace_name \u8868\u7a7a\u95f4\u540d, … <\/p>\n