Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

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;

Related Posts
Write a comment