Skip to content

Instantly share code, notes, and snippets.

@GuiMarthe

GuiMarthe/table_sizes.sql

Created November 22, 2017 16:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save GuiMarthe/1aeca059df51b57a56c44aab415693d5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save GuiMarthe/1aeca059df51b57a56c44aab415693d5 to your computer and use it in GitHub Desktop.
Download ZIP
query for table sizes estimates in MB on oracle databases
Raw
table_sizes.sql
-- Tables + Size MB
select owner, table_name, round((num_rows*avg_row_len)/(1024*1024)) MB
from all_tables
where owner not like 'SYS%' -- Exclude system tables.
and num_rows > 0 -- Ignore empty Tables.
order by MB desc -- Biggest first.
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment