Question Re: Parameter recommendations for CMS database with Oracle 19c in Technology Q&A

Parameter recommendations for CMS database with Oracle 19c

guidan — Tue, 25 Aug 2020 07:27:07 GMT

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.

Re: Parameter recommendations for CMS database with Oracle 19c

Former Member — Tue, 25 Aug 2020 07:41:49 GMT

Hi Daniel,

According to the Note, the recommendations are for SAP NetWeaver-based Products. SAP BusinessObjects falls under the Business Intelligence suite of products and hence according to me the Note would not be applicable for CMS Database.

Regards,

Sharvari

Re: Parameter recommendations for CMS database with Oracle 19c

guidan — Tue, 25 Aug 2020 08:19:45 GMT

Hello,

Thank you for your answer.

Do you know if there is a note or whitepaper about parameter recommendations for CMS database with Oracle as for SAP NetWeaver-based Products ?

Regards,

Daniel

Re: Parameter recommendations for CMS database with Oracle 19c

Former Member — Tue, 25 Aug 2020 08:43:01 GMT

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

Re: Parameter recommendations for CMS database with Oracle 19c

denis_konovalov — Tue, 25 Aug 2020 11:13:44 GMT

I'd like to know who told you that CMS DB is an OLAP DB.
It is not.
The note you mentioned is irrelevant for CMS DB type of processing. The KBA provided by Sharvari above is the right one.

CMS DB does lots of small reads with occasional large read and not a lot of writes (which are also fairly small), so your DBA will need to monitor and adjust parameters accordingly.

Re: Parameter recommendations for CMS database with Oracle 19c

guidan — Tue, 25 Aug 2020 12:41:54 GMT

OK, thank you Denis.

So CMS database is rather an OLTP DB.