Database Size (2)

From NazimWIKI
Revision as of 23:09, 8 November 2019 by Admin (talk | contribs) (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>")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
SELECT TARGET_NAME
     , ROUND (SUM (FILE_SIZE) / 1024 / 1024 / 1024) GB
  FROM MGMT$db_datafiles_all
GROUP BY TARGET_NAME