Query to find table size in oracle

 

Sometimes we may need to find the table size in oracle database. Below query provides the size of  a table in the database.

How to find table size:

---------------------------

select sum(bytes)/(1021*1024*2014) as size_in_GB from dba_segments where SEGMENT_NAME like 'XXEMPLOYEES' and segment_type='TABLE';

Thanks for going through the post.............