Temporary Tablespace Sizing in Oracle for SAP

[Former Member]

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.

[former_member207186]

Hi,

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

Regards,

Bíborka

[ashish_vikas]

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