select segment_name, bytes/1024/1024 spacefrom user_segments
where segment_type = 'TABLE' ORDER BY space desc
sapce列即是表大小