We are planning an XI 3.1 Oracle landscape. I found some discussions indicating that the CMS and Audit schemas should be on different databases (Audit database vs. CMS system database), but I am looking for some official SAP/BOBJ documentation on this. I checked but did not find any documents, notes, etc…
Also, one person posting on the thread that I cited mentioned that the CMS schema uses a lot of LOBs.
If so, has anybody used SecureFiles in Oracle 11 with CMS?
According to SAP note #1426979, and other documentation, it improves LOB database performance?
How you segregate your CMS and audit databases is very dependent on the hardware they will run on and how frequently you will be running audit queries. If you have slower systems you may want to separate them so that audit queries do not impact CMS performance. Things like CMS cache size, scheduled object checks and the like can all increase the load on the database server and if you throw auditing queries in the mix you may see an impact on the system.
We currently run both schema’s in the same instance and everything moves along just fine but we have some pretty good hardware running the database.
(BOB member since 2006-07-28)