Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Recommendations for the Oracle processes parameter


Reports data warehouse recommendations

BMC recommends that the Oracle processes parameter for both the BMC Server Automation database and the Oracle database (that is used as the reports data warehouse) be set to 800 (instead of the default of 400) because of high process load.

The ETL execution spawns multiple Oracle processes and makes multiple connections to the reports data warehouse. The actual number of processes that are needed is based on the number of domains (such as Inventory and Audit) for which ETL is being run in parallel.

In addition, the IBM Cognos reports server makes connections to the reports data warehouse, which increases the process load on the reports database server.

Portal content store recommendations

BMC recommends that the processes parameter for the portal content store instance use the default setting. For default setting details, see the Oracle documentation.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*