How to find table size?
select segment_name,segment_type,bytes/1024/1024 MB from dba_segments where segment_type='TABLE' and segment_name='<yourtablename>';
Example:
select segment_name,segment_type,bytes/1024/1024 MB from dba_segments where segment_type='TABLE' and segment_name='QADER_T1';
SQL> select segment_name,segment_type,bytes/1024/1024 MB from dba_segments where segment_type='TABLE' and segment_name='QADER_T1';
SEGMENT_NAME SEGMENT_TYPE MB
-------------------------------------------------------------------------------------------------------------------------------- ------------------ ----------
QADER_T1 TABLE 4776
No comments:
Post a Comment