Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table FEH_MESS_PERS and column (PAYLOAD) growing

Hi ALL,

Oracle version 11.2.0.3

BRTOOLS 7.20 (30)

SAP version 7.2

The below LOB segment which is more occupied space in CRM
system and I checked with any compression option but my bad as per As per SAP note 1431296 SAP
recommendation not to compress the following table in oracle and if these tables have securefile LOBs, we
should also not compress them
.

The below object which is securefile LOB so we don’t have
any option for compression.

Is there any option available for archiving or deletion the old data’s? Can we make use of them?

Is it any impacting business data?

SELECT table_name, column_name,securefile, compression FROM dba_lobs where SEGMENT_NAME='SYS_LOB0000337570C00008$$';

TABLE_NAME                     COLUMN_NAME                   SECUREFILE                                           COMPRE

FEH_MESS_PERS                  PAYLOAD                                     YES                                                    NO

   


SEGMENT_NAME


SEGMENT_TYPE


Size in GB


TABLESPACE_NAME


SYS_LOB0000337570C00008$$


LOBSEGMENT


  1. 445.073364

PSAPSR3


Please let me know if any more details.

Thanks & Regards,

Dhavan

Former Member
Not what you were looking for? View more on this topic or Ask a question