Difference between revisions of "Database Size (2)"

From NazimWIKI
Jump to navigation Jump to search
(Created page with "<blockquote><pre> SELECT TARGET_NAME , ROUND (SUM (FILE_SIZE) / 1024 / 1024 / 1024) GB FROM MGMT$db_datafiles_all GROUP BY TARGET_NAME </pre></blockquote>")
 
(No difference)

Latest revision as of 23:09, 8 November 2019

SELECT TARGET_NAME
     , ROUND (SUM (FILE_SIZE) / 1024 / 1024 / 1024) GB
  FROM MGMT$db_datafiles_all
GROUP BY TARGET_NAME