This section helps you configure the Oracle-based PMDB after you install Precise. This is not a replacement of the content within Installation and Administration. The configuration recommendations help you to fine-tune the PMDB, which then results in faster and more efficient performance.
Prerequisites
Before applying the information in this section, refer to the content within Installation and Administration . We recommend that the PMDB is an Oracle-dedicated instance.
Make sure that you are creating the database with the proper NLS_CHARACTERSET. When the monitored Oracle instances use a multiple byte character set, use UTF8.
AL32UTF8 is not supported by the PMDB.
The following table specifies the database block size prerequisite.
Table 1 Database block size prerequisite
| Parameter | Value | Improvement |
|---|---|---|
| db_block_size | Minimum 8KB (16KB recommended) | This value defines the Oracle block size. The block size is set when creating the database and cannot be changed afterwards. A value of at least 8 KB ensures that the PMDB can perform smoothly. A lower value may cause serious performance problems.
To review the default block size value, check the |
Required INIT.IRA changes
To improve performance, change some parameter values and make sure the values match those listed in the appropriate table.
You can change the parameter values on a new and on an existing Oracle instance. Tables 2 through 5 describe the general and Oracle version-specific parameters.
Table 2 General parameters
| Parameter | Value | Improvement / Remarks |
|---|---|---|
Table 3 8i parameters
| Parameter | Value | Improvement / Remarks |
|---|---|---|
Table 4 9i parameters
| Parameter | Value | Improvement / Remarks |
|---|---|---|
Table 5 10g parameters
| Parameter | Value | Improvement / Remarks |
|---|---|---|