Regarding the SAP big tables in ECC 6.0

[Former Member]

Hi,

We are having SAP ECC 6.0 running on Oracle 10.2g database. Please can anyone of you give fine details on the big tables as below. What are they? Where are they being used? Do they need to be so big? Can we clean them up?

Table Size

TST03 220 GB

COEP 125 GB

SOFFCONT1 92 GB

GLPCA 31 GB

EDI40 18GB

Thanks,

Narendra

[former_member204080 · Accepted solution]

Hi,

TST03 ->it stores the spool related data.To delete old spool requests run reports RSPO0041 and RSPO1041

This way u can clean it up

[Former Member]

Hello Narendra,

TST03 merits special attention, certainly if it is the largest table in your database. TST03 contains the contents of spool requests and it often happens that at some time in the past there was a huge number of spool data in the system causing TST03 to inflate enormously. Even if this spool data was cleaned up later Oracle will not shrink the table automatically. It is perfectly possible that you have a 220 GB table containing virtually nothing.

There are a lot of fancy scripts and procedures around to find out how much data is actually in the table, but personally I often use a quick-and-dirty check based on the current statistics.

sqlplus /
select (num_rows * avg_row_len)/(1024*1024) "MB IN USE" from dba_tables where table_name = 'TST03';

This will produce a (rough) estimate of the amount of space actually taken up by rows in the table. If this is very far below 220 GB then the table is overinflated and you do best to reorganize it online with BRSPACE.

As to the other tables: there are procedures for prevention, archiving and/or deletion for all of them. The best advice was given in an earlier response to your post, namely to use the SAP Database Management Guide.

Regards,

Mark

[Former Member]

Hi Narendra,

Please go through the Data Management Guide of SAP.

https://websmp109.sap-ag.de/~sapidb/011000358700005044382000E

It contains the details of what action needs to be taken for the tables you require.

Hope this helps.

Regards,

SP.

[former_member188883]

Hi Narendra,

Table Size

TST03 220 GB -> Spool table

COEP 125 GB -> CO Object: Line Items (by Period)

SOFFCONT1 92 GB -> SOFF: Table for Document Contents (import/export)

GLPCA 31 GB -> EC-PCA: Actual Line Items

EDI40 18GB -> IDoc data records for 4.0

For TST03, refer SAP Note 48400 - Reorganization of TemSe and Spool

For COEP -> you need to look for archiving option to reduce size

For SOFFCONT1 -> you need to look for archiving option to reduce size

For GLPCA -> you need to look for archiving option to reduce size

For EDI40 -> Refer SAP Note 40088 - EDI IDoc Deleting and reorganizing IDocs

Regards,

Deepak Kori

[stefan_koehler]

Hello Narendra,

some of these tables are basis tables - some others are application related.

Please check sapnote #706478 for the tables and how to prevent unnecessary table growth. For the other tables that are not mentioned in the sapnote - check them with transaction SARA and the corresponding archive objects.

Regards

Stefan