Skip to content

Instantly share code, notes, and snippets.

@jzi96

jzi96/Oracle Get Size of Segments

Last active November 4, 2015 21:17
Show Gist options
  • Save jzi96/10447042 to your computer and use it in GitHub Desktop.
Save jzi96/10447042 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle Get Size of Segments
Raw
Oracle Get Size of Segments
SELECT * FROM (
SELECT
OWNER, SEGMENT_NAME, SEGMENT_TYPE, BYTES/1024/1024 SIZE_MB
FROM
DBA_SEGMENTS
ORDER BY
BYTES/1024/1024 DESC ) WHERE ROWNUM <= 20;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment