Skip to content

Instantly share code, notes, and snippets.

@rrguntaka
Created September 12, 2012 15:45
Show Gist options
  • Save rrguntaka/3707551 to your computer and use it in GitHub Desktop.
Save rrguntaka/3707551 to your computer and use it in GitHub Desktop.
Oracle Table segment details, to find the space usage for given table
select extent_id, bytes, blocks
from user_extents
where segment_name = '&table_name'
/
select blocks, empty_blocks, avg_space, num_freelist_blocks
from user_tables
where table_name = '&table_name'
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment