Tuning the Infrastructure Management database for performance
The BMC TrueSight Infrastructure Management Server supports a SAP SQL Anywhere or Oracle database.
- A SAP SQL Anywhere ASA database comes embedded with BMC TrueSight Infrastructure Management Server. Most of the settings are optimized out-of-the-box. You can tune the SAP SQL Anywhere database according to your deployment type. For more information, see Performance-tuning-recommendations-for-data-and-event-management.
- An Oracle Database requires the database installation on a separate computer. You can tune several Infrastructure Management properties and Oracle Database parameters to optimize performance. The following tables provides the most common properties and changes that you should consider before installing BMC TrueSight Infrastructure Management Server.
Tuning recommendations for Oracle database
Tuning recommendations for Oracle database with Report Engine
The following tuning recommendations apply only when you integrate BMC TrueSight Operations Management Report Engine with BMC TrueSight Infrastructure Management.
After you change these settings, restart the Oracle server and then restart the Infrastructure Management server.
To resize available REDO log files before Infrastructure Management installation
To set the CURSOR_SHARING attribute
By default, Oracle sets the CURSOR_SHARING attribute to EXACT.
You can change this attribute to FORCE, which reduces the number of new cursors created in the database. This setting creates new cursors only when needed and reduces memory consumption, resulting in better performance.
To change the CURSOR_SHARING attribute value:
- Log on to the Oracle server as the Super Admin user. For example:
sqlplus sys/<sys password> as sysdba - Run the following command:
alter system set CURSOR_SHARING=’FORCE'; - Restart the Infrastructure Management server.
Related topics
Supported-databases-and-Web-consoles-requirements-for-Infrastructure-Management
Performance-tuning-recommendations-for-Cloud-Lifecycle-Management
Performance-tuning-recommendations-for-data-and-event-management
Performance-tuning-recommendations-for-event-and-impact-management
Best-practices-and-configuration-guidelines-for-performance-and-scalability