17,382
社区成员




select e.segment_name ,max(block_id + blocks - 1) HWM
from dba_extents e
where file_id = 10
group by e.segment_name ;
select file# ,df.bytes/1024/1024 file_M,
free_M ,HWM ,
(df.bytes - HWM * df.BLOCK_SIZE)/1024/1024 release_M
from v$datafile df
left join (select file_id ,sum(bytes)/1024/1024 free_M
from dba_free_space
group by file_id) fs
on df.file# = fs.file_id
left join (select file_id ,max(block_id + blocks - 1) HWM
from dba_extents
group by file_id) e
on df.file# = e.file_id
where file# = 10
order by 1;
alter index ASC_MSG_PARA_MID_IDX rebuild online;