Page History
...
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. Note that
| Info |
|---|
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.
|
Required INIT.IRA changes
Toimprove performance, change some parameter valuesand make sure thevaluesmatch thoselisted in the appropriatetable.
You can change theparameter values on a newand on an existing Oracleinstance. Tables 2 through 5 describethe general and Oracleversion-specificparameters.
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 |
|---|---|---|