cancel
Showing results for 
Search instead for 
Did you mean: 

In SAP system, Which objects are recommended to use ASSM?

Former Member
0 Kudos

Deart expert,

I've just study on the "fragmentation"

One question come to me

In SAP system, do we use often the ASSM to manage tablespace? in both 10g and 11g?

Which objects are recommended using ASSM?

Thank you!

Kate

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kate,

ASSM is a standard in the SAP environment from a long time of period. This feature has been added into Oracle by 9i release. Please note that there are some differences to use ASSM on RAC and non-RAC environments.

Please find the answers in the note, below;

https://service.sap.com/sap/support/notes/620803

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hello Orkun Gedik,

Thank you for your answer.

Does that means if you set up a SAP+oracle system like ERP 6.05, all the tablespace present is in the default mode: ASSM?

If not want to know which objects are using ASSM?

And if new objects are going to be created , Which kind of objects are recommended to use ASSM?

Thank you!

Kate


Former Member
0 Kudos

Hi,

All the tablespaces will be created with AUTO segment space management, except PSAPTEMP, PSAPUNDO and SYSTEM

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hello Orkun Gedik,

Thank you!

It is clear.

BR,

Kate

Former Member
0 Kudos

You're welcome 🙂

Answers (0)