Skip to Content
avatar image
Former Member

Cleaning up of the System

Hi ,

In one of our servers we are having a space constraint.So we are planning to do a cleanup.Below is the list which are occupying the most.Could anyone throw some light where we can delete the data and if yes how.Thanks.

Owner Object Type Tablespace KBytes Blocks Extents

SAPSR3 AGR_HIERT TABLE PSAPSR3 1.769.472 221.184 27

SAPSR3 ARFCSDATA TABLE PSAPSR3 3.866.624 483.328 171

SAPSR3 AGR_HIERT~0 INDEX PSAPSR3 1.507.328 188.416 23

SAPSR3 E071~1 INDEX PSAPSR3 1.769.472 221.184 27

SAPSR3 E071K TABLE PSAPSR3 1.769.472 221.184 27

SAPSR3 GLFUNCA TABLE PSAPSR3 1.376.256 172.032 21

SAPSR3 E071K~0 INDEX PSAPSR3 1.769.472 221.184 27

SAPSR3 E071K~ULI INDEX PSAPSR3 1.769.472 221.184 27

SAPSR3 MC13VD0ITMSETUP TABLE PSAPSR3 1.245.184 155.648 19

SAPSR3 MC13VD0KONSETUP TABLE PSAPSR3 1.572.864 196.608 24

SAPSR3 PCL2 TABLE PSAPSR3 4.063.232 507.904 62

SAPSR3 TBTCO TABLE PSAPSR3 1.769.472 221.184 195

SAPSR3 TBTCO~9 INDEX PSAPSR3 1.007.616 125.952 179

SAPSR3 TBTCP TABLE PSAPSR3 2.097.152 262.144 200

SAPSR3 DDNTF TABLE PSAPSR3 1.048.576 131.072 128

SAPSR3 TST01 TABLE PSAPSR3 1.245.184 155.648 187

SAPSR3 EDI40 TABLE PSAPSR3 1.245.184 155.648 131

SAPSR3 VARI TABLE PSAPSR3 3.216.384 402.048 162

SAPSR3 VARI~0 INDEX PSAPSR3 1.032.192 129.024 182

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 02, 2010 at 06:27 AM

    Hi,

    Do you really intend to delete some tables and indexes ?

    The only way safe way to reduce the growth of a SAP database is to use SAP archiving.

    Regards,

    Olivier

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      > In our system, we consider a table as big starting at 100 GB...

      Completely agree. Infact I have seen PCL2 go upto 500 GB hence the example.

      Regards.

      Ruchit.

  • Jun 02, 2010 at 09:26 AM

    You don't delete data because you have space issues... you get more disk space!... Either by adding additional disks to your box or space from a SAN.

    As mentioned by Olivier the most viable way to reduce the amount of data in the system is to do archiving... but then you are just moving the data to a content repository. Additional to that archiving is done mainly to increase system performance rather than saving space.

    Hardware is cheap... my recomendation will be to get extra space.

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded