Skip to Content

SASCONT1 table growing of 3 GB

Hello,

After applying the support packages in our Solution Manager,

the table SASACONT1 has grown 3 GB.

1. Would you know what does this table contain?

2. Are there standard reports to clean/purge it?

Thanks in advance for your answer.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 17, 2012 at 03:29 PM

    Table SASCONT1 contains documents os Solution Manager.

    Yo have and explanation of the growing size of the table and how to reduce the size with a report: http://scn.sap.com/community/it-management/alm/solution-manager/blog/2012/07/17/how-to-reduce-the-size-of-tables-sacont01-and-sasacont1-in-solution-manager

    Regards,

    Nerea de Andrés

    Add comment
    10|10000 characters needed characters exceeded

    • Hello,

      I have purge old sessions up to 30.6.2012 with th report RDSMOPREDUCEDATA.

      But nothing has been deleted in SASACONT1 Table.

      Before the report execution:

      SQL> select count(*) from sapsr3.sasacont1;

         1405948

      After the report execution:

      SQL>  select count(*) from sapsr3.sasacont1;

         1405948

      Would you know why nothing has been purged in this table?

      Thanks in advance for your answer.

  • avatar image
    Former Member
    May 14, 2012 at 06:31 PM

    This growth looks normal to me. same table is over 4gb in our system too and .

    Regards

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Benoît Schmid

      I am currently not aware of what kind of data is getting stored in these tables also i am not aware of archiving options for this table.

      Try opening a message with SAP.

      Regards

      Amit Padmawar

  • Oct 23, 2012 at 07:08 AM

    Hello,

    Would you know why it has only increased in size when SPS were applied?

    01.10.2012                                         5.308.416                    0                  81                  0            1.024      01.09.2012                                         5.308.416                    0                  81                  0            1.024      01.08.2012                                         5.308.416                    0                  81                  0            1.024      01.07.2012                                         5.308.416                    0                  81                  0            1.024      01.06.2012                                         5.308.416                    0                  81                  0            1.024      01.05.2012                                         5.308.416                3.080.192                  81                 47            1.024      01.04.2012                                         2.228.224                    0                  34                  0            1.024      01.03.2012                                         2.228.224                    0                  34                  0            1.024      01.02.2012                                         2.228.224                    0                  34                  0            1.024      01.01.2012                                         2.228.224                    0                  34                  0            1.024      01.12.2011                                         2.228.224                    0                  34                  0            1.024      01.11.2011                                         2.228.224                    0                  34                  0            1.024     

    Thanks in advance for your answer.

    Add comment
    10|10000 characters needed characters exceeded