Home / AppsDBA Scripts / Query to Check Oracle Database Growth

Query to Check Oracle Database Growth

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;

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

How to Get Apps Password From Backend

How to Get Apps Password From Backend   STEP 1.  First login to Database through …

Leave a Reply