Useful sql scripts for Daily activities

Full Database Size: SELECT ROUND (SUM (used.bytes) / 1024 / 1024 / 1024) || ‘ GB’“Database Size”,ROUND (SUM (used.bytes) / 1024 / 1024 / 1024)ROUND (free.p / 1024 / 1024 / 1024)|| ‘ GB’ “Used space”,ROUND (free.p / 1024 / 1024 / 1024) || ‘ GB’ “Free space”FROM (SELECT bytes FROM v$datafile UNION ALLSELECT bytes …

Useful sql scripts for Daily activities Read More »