SR Title
APPLSYS.SYS_LOB0000033489C00004$$ Segment Consuming Approximately 2.9 TB in Oracle E-Business Suite 12.2 Database
Problem Description
Dear Oracle Support,
We are performing a housekeeping and storage optimization exercise on our Oracle E-Business Suite Production environment.
During our storage analysis we observed that the following LOB segment has grown significantly:
Owner : APPLSYS
LOB Segment: SYS_LOB0000033489C00004$$
Current Size: ~2.9 TB
Further investigation shows that this LOB contains millions of documents stored through Oracle EBS attachment functionality.
The major file types stored include:
PDF (~1.6 TB)
JPEG (~438 GB)
PJPEG (~249 GB)
application/octet-stream (~148 GB)
ZIP (~111 GB)
Microsoft Office documents
Our objective is to understand:
Which Oracle EBS table owns this LOB.
Whether Oracle provides any supported purge utility for this data.
Whether old attachments can be archived or deleted safely.
Whether SecureFile LOB migration, LOB shrink, or online reorganization is supported.
Any Oracle recommended housekeeping activity for this LOB.
Whether this growth is expected for Oracle EBS attachments.
Whether any Oracle patches or MOS notes address excessive growth of this LOB segment.
We would appreciate Oracle's guidance before taking any cleanup action in Production.
Information We Will Provide
Oracle EBS Version
Oracle Database Version
AWR Report (if required)
Segment Report
LOB Owner Details
Output of
SELECT owner,
table_name,
column_name,
segment_name
FROM dba_lobs
WHERE segment_name='SYS_LOB0000033489C00004$$';
and
SELECT owner,
segment_name,
bytes/1024/1024/1024 GB
FROM dba_segments
WHERE segment_name='SYS_LOB0000033489C00004$$';
