可以查sys_log$$对应的具体表，然后再根据业务需求调整
SELECT B.TABLE_NAME,

   B.COLUMN_NAME,

   A.SEGMENT_NAME,

   a.SEGMENT_TYPE,

   ROUND(SUM(A.BYTES / 1024 / 1024 / 1024), 2) G
复制

FROM DBA_SEGMENTS A

LEFT JOIN DBA_LOBS B

ON A.OWNER = B.OWNER
复制

AND A.SEGMENT_NAME = B.SEGMENT_NAME

–WHERE B.SEGMENT_NAME = ‘SYS_LOB0000026212C00002$$’

HAVING ROUND(SUM(A.BYTES / 1024 / 1024 / 1024), 2) >1

GROUP BY B.TABLE_NAME, B.COLUMN_NAME, A.SEGMENT_NAME,a.SEGMENT_TYPE;