Oracle分析表空间使用率及top对象

1.检查表空间使用率

select * from dba_tablespace_usage_metrics

 

2.检查大对象

select owner,segment_name,segment_type,bytes from dba_segments order by bytes desc;

 --查找lob对象属于哪些表

select owner,table_name,column_name,segment_name from dba_lobs where segment_name in ('SYS_LOB0000082601C00008$$')