Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 25, 2014 at 11:21 AM

    Hi Dhavan,

    You need to first clear old records either by means of archiving or deletion process supported by SAP.

    Post this you may Reorg the table which will inturn shrink the LOB segment as well.

    For Archiving you may use archiving object: /SAPPPO/PPO

    There is a report /SAPPO/DELETE_ORDERS which deletes the orders including the two payload tables FEHT_MESS_PERS and FEHT_MESS_REF. The payload of PPO orders that were previously deleted must be removed from the system individually.

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded