Skip to content

Instantly share code, notes, and snippets.

@mikerodionov

mikerodionov/Check table size in Oracle database.sql

Created April 11, 2019 12:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mikerodionov/f8cd8adb18bec8dbba915c25ce321616 to your computer and use it in GitHub Desktop.
Save mikerodionov/f8cd8adb18bec8dbba915c25ce321616 to your computer and use it in GitHub Desktop.
Download ZIP
Check table size in Oracle database
Raw
Check table size in Oracle database.sql
SELECT segment_name, segment_type, bytes/1024/1024 MB
FROM user_segments
WHERE segment_type='TABLE' AND segment_name='YOUR_TABLE_NAME'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment