Compiling Objects Manually Through SQL Commands First find the Invalid Objects in the Database by below given query. SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = ‘INVALID’; For a more detailed …

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

This Query Calculate the Datafile Growth on a Yearly Basis