Skip to Content
author's profile photo Former Member
Former Member

PSA Table Space

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2005 at 02:13 PM

    Hi

    Try to debugging DB02 transaction

    BR

    AndyML

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 24, 2005 at 10:10 AM

    Hi

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

    2. CALL FUNCTION 'RSAR_ODS_API_DEL'

    Good luck

    AndyML

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 24, 2005 at 04:52 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.