在运行查询对象大小时:
---本用户下
select segment_name,ROUND(sum(bytes) / (1024 * 1024 * 1024),2) as "size(G)"
from user_segments
group by segment_name
order by sum(bytes) desc;
发现有一个SYS_LOB0000076574C00008$$值很大
通过dba_objects查询,得到类型为 LOB
select * from dba_objects where OBJECT_NAME = 'SYS_LOB0000076082C00001$$';
通过dba_lobs得到该对象对应的表名,还有该表里CLOB字段的字段名
SQL> select TABLE_NAME,COLUMN_NAME,SEGMENT_NAME from dba_lobs where SEGMENT_NAME='SYS_LOB0000076082C00001$$';
TABLE_NAME COLUMN_NAME SEGMENT_NAME
----------- ---------- -----------------
PAGING_LOG SQL_STR SYS_LOB0000076082C00001$$
SQL> desc PAGING_LOG
名称 是否为空? 类型
----------------------------------------- -------- --------
SQL_STR CLOB
CREATE_TIME DATE