select b.owner, a.table_name, a.num_rows, b.bytes/1024/1024||'M' as table_size from dba_all_tables a join dba_segments b on a.owner = b.owner and a.table_name = b.segment_name where a.table_name = 'TC_DOC_FILE' --需要查询的表 and b.segment_type IN ('TABLE','TABLE PARTITION','TABLE SUBPARTITION','LOBSEGMENT') ORDER BY owner,table_size DESC; |
|