Skip to Content

Temporary Tablespace Sizing in Oracle for SAP

Hi All,

I require a small clarification on , how to size Temporary Tablepace for SAP ECC systems below are the current details,

DB size                          :- 1 TB

Business Tablespace      :- 70 GB free

Temporary Tablepspace   :- 2 GB

What is the calculation required to create Temp TableSpace sizde in SAP.

Kindly give your thoughts on this.

Thanks

Pradeep.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 09, 2015 at 11:01 AM

    416772 - General tablespace types, temporary tablespace parameters


    Recommended size and memory parameters for temp. tsp. PSAPTEMP[2]:

    -----------------------------------------------------------------------

    The temporary tablespace (tempsize) should be at least twice the size of the largest DB index.


    Regards,

    Ashish

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 09, 2015 at 11:24 AM

    Hi,

    Regarding this issue/question, you can check carefully the SAP Note 659946 - "FAQ: Temporary tablespaces" .

    Regards,

    Bíborka

    Add comment
    10|10000 characters needed characters exceeded