Database Scripts

SELECT Count(*)  FROM   v$backup_async_io  WHERE  status = ‘IN PROGRESS’; 

This Query Calculate the Datafile Growth on a Yearly Basis

QUERY TO FIND information of PRIMARY OR STANDBY DATABASE