Skip to content

Instantly share code, notes, and snippets.

@jotapepinheiro
Created June 1, 2015 15:53
Show Gist options
  • Save jotapepinheiro/a5c12da27e470420d276 to your computer and use it in GitHub Desktop.
Save jotapepinheiro/a5c12da27e470420d276 to your computer and use it in GitHub Desktop.
Verifica espaço no banco oracle
SELECT DDF.TABLESPACE_NAME "TablespaceName",
DDF.FILE_NAME "DataFile",
DDF.BYTES / (1024 * 1024) "Total(MB)",
ROUND((DDF.BYTES - SUM(NVL(DFS.BYTES, 0))) / (1024 * 1024), 1) "Used(MB)",
ROUND(SUM(NVL(DFS.BYTES, 0)) / (1024 * 1024), 1) "Free(MB)"
FROM SYS.DBA_FREE_SPACE DFS
LEFT JOIN SYS.DBA_DATA_FILES DDF ON DFS.FILE_ID = DDF.FILE_ID
WHERE DDF.TABLESPACE_NAME = 'ETURMALINATAB'
GROUP BY DDF.TABLESPACE_NAME, DDF.FILE_NAME, DDF.BYTES
ORDER BY DDF.TABLESPACE_NAME, DDF.FILE_NAME;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment