The BMC TrueSight Infrastructure Management Server supports a SAP SQL Anywhere or Oracle database.
Parameter description | Value command | Procedure |
---|---|---|
Set the number of processes and sessions. |
|
|
Set the |
| Reset |
Set memory allocation. |
| Set memory allocation to half of the system memory. |
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. Parameter description Value command Set the number of processes. Set memory allocation. Tuning recommendations for Oracle database with Report Engine
alter system set processes = 1250 scope=spfile;
alter system set memory_max_target=
20480
M scope=spfile;
alter system set memory_target=20480M scope=spfile;
Set the number of job queue processes. alter system set job_queue_processes = 25 scope=spfile;
Parameter description | Value command | Procedure |
---|---|---|
Set REDO01. |
| To avoid |
Set REDO02. |
| To avoid |
Set REDO03. |
| To avoid |
Check status of redo log files. |
| Set status of one redo log file to |
Set audit_trail and scope. |
| Alter the |
Set |
| Add |
Best Practice
In a production environment, it is important to size the redo log files to ensure that the frequency of redo log switches is not more than 5 log switches per hour during peak DML activity. Oracle provides the v$log_history view that tracks the historical frequency of log switches, and this can be correlated to periods of high update activity when log switching is peaking.
Set a redo log file with an initial size of minimum 500 MB and increase the size (1 GB → 1.5 GB → 2 GB) based on the log switch rate.
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:
sqlplus sys/<sys password> as sysdba
alter system set CURSOR_SHARING=’FORCE';
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
1 Comment
Jonathan Macey