SYS_LOB0000076574C00008$$

在运行查询对象大小时：

---本用户下
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