查看數(shù)據(jù)庫的空間增長趨勢
有時我們想知道數(shù)據(jù)庫創(chuàng)建以來數(shù)據(jù)文件的空間增長情況，可以以下語句初略統(tǒng)計：
SELECT TO_CHAR(creation_time, 'RRRR-MM') "month",SUM(bytes) growth
FROM sys.v_$datafile
GROUP BY TO_CHAR(creation_time, 'RRRR-MM')
ORDER BY TO_CHAR(creation_time, 'RRRR-MM');
month GROWTH
-------------- ----------
2019-05 2076180480
2022-04 20971520
2022-07 38797312
標簽：
