Parameter recommendations for CMS database with Oracle 19c

[#1]

According to SAP support, SAP BO BI 4.2 CMS (Central Management Server) database is an OLAP database and the recommendations in note 2470718 are valid for CMS database.

Can anyone confirm ?

Thank you.

[Former Member]

Hi Daniel,

There are a couple of suggestions in the SAP KBA :

https://launchpad.support.sap.com/#/notes/2420789 which you can refer.

As such, no settings or parameters are mandatory from the product side. However, if the Oracle DBA would update statistics, rebuild indexes it would help in improving the performance.

If you are facing performance issues or any other issues with the CMS Database, it needs to be investigated for a root cause.

Regards,

Sharvari