Skip to Content

Trace why SOFFCONT1 grows

Good afternnon,

SOFFCONT1 table grows quite fast on our system.

I am suspecting processes that send emails and save a copy in the database.

Would someone know how I could get the owner, program name and data type that are stored in this table.

This would help me tracing out why the table is growing?

Thanks in advance for your reply.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 15, 2010 at 05:57 AM

    I am suspecting processes that send emails and save a copy in the database.

    You may be right. Actually email attachments (among other things, not email related) are stored in this table.

    And you know how huge powerpoint presentations may become.

    regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Benoît Schmid

      Hi ,

      You can try searching in the related tables like SOOD and SOOS, which give you data like when it was created, who created it and the message title , type of the message etc.

      Based on these info, you can find out which message type is increasing on a regular basis and who creates them.

      Regards,

      Shail.

  • avatar image
    Former Member
    Apr 14, 2010 at 11:19 PM

    Check the note given below for periodic maintenance of this table and it has all the info you have asked.

    Link: [Note 966854 - Reorganization - New report]

    The below note may be usefull if you are looking for reorging other tables.

    Link: [Note 706478 - Preventing Basis tables from increasing considerably]

    Add comment
    10|10000 characters needed characters exceeded