Query to Check Oracle Database Growth
August 2, 2017
AppsDBA Scripts, Database Scripts, Scripts
![Query to Check Oracle Database Growth](https://syedsaadali.com/wp-content/uploads/2023/05/SyedSaadAli_ACE_linkedin-e1685600570483.png)
This Query Calculate the Datafile Growth on a Yearly Basis
SELECT To_char(creation_time, ‘RRRR’) year,
To_char(creation_time, ‘MM’) month,
Round(SUM(bytes) / 1024 / 1024 / 1024) gb
FROM v$datafile
GROUP BY To_char(creation_time, ‘RRRR’),
To_char(creation_time, ‘MM’)
ORDER BY 1,
2;
Related Posts