Thursday, July 17, 2014

FIND TABLE SIZE

TABLE SIZE

select sum(bytes/1024/1024) “size in MB” from dba_segments where segment_name=’UK’ and segment_type=’TABLE’;
select sum(bytes/1024/1024) “size in MB” from dba_segments where segment_name=’UK’ and segment_type=’TABLE’ and owner='UK';


 

No comments:

Post a Comment