PSA Table Space

[Former Member]

Hello All

Currently we are facing major perforamance problem in our Production system due to PSA table space.Additionaly there were daily load cycle.Now a new application was developed and was added to Production system.So, we have decided to find out which objects are using how much PSA table space.Is there any ABAP which can give me which object is using how much table space?Or An ABAP which can give me the list of objects using PSA table space.

Thanks in advance

Yogesh Mali

[Former Member · Accepted solution]

Hi

Try to debugging DB02 transaction

BR

AndyML

[klaus_werner]

Andy has already given you most of the information. In transaction DB02 you can find out the largest objects, names of PSA tables are /BIC/B*. Tablespace depends on whether you have old or new layout (and possibly assigned individual tablespace to some PSA). Change log tables from ODS objects are also technically PSA tables. Be careful deleting these if data may still be needed for delta loading. The link between the PSA and the object can be found in RSTSODS (fields ODSNAME and ODSNAME_TECH).

Regards, Klaus

[Former Member]

Hi Klaus

Thanks for your response.This was helpful information.

Best Regards

Yogesh

[Former Member]

Hi

1. There are all PSA tables in table RSTSODS. Field ODSNAME_TECH.

2. CALL FUNCTION 'RSAR_ODS_API_DEL'

Good luck

AndyML