My Oracle Support Banner

Database Tablesize Increases Indiscriminately Over Time (Doc ID 2535656.1)

Last updated on AUGUST 01, 2024

Applies to:

Oracle WebCenter Portal - Version 12.2.1.3.0 and later
Oracle WebCenter Portal for OCI - Version 12.2.1.4_24.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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