Database Tablesize Increases Indiscriminately Over Time (Doc ID 2535656.1)

Last updated on DECEMBER 05, 2023

Applies to:

Symptoms

Database tablesize increases indiscriminately over time. The following query shows that LOBSEGMENT consumes almost 80% of total tablespace:

SQL>SELECT SEGMENT_NAME, SEGMENT_TYPE, (SUM(BYTES)/1024/1024) MB_SIZE FROM DBA_SEGMENTS WHERE OWNER='TABLESPACE_NAME' GROUP BY SEGMENT_NAME, SEGMENT_TYPE ORDER BY 3 DESC;

Result:
SEGMENT Name : <SEGMENT_NAME>
Example: SYS_LOB0000030729C00004$$

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.