The database manager settings are set at the instance level. The settings that affect performance involve memory size, how fenced processes behave, and whether the database instance is monitored.
Database manager settings | Value for performance tuning | Descriptions |
---|---|---|
RQRIOBLK | 65535 | Sets the size of the communication buffer between remote applications and their database agents on the database server. |
HEALTH_MON | OFF | Specifies whether an instance, the associated databases, and database objects are monitored. |
MON_HEAP_SZ | AUTOMATIC | Specifies the amount of the memory, in 4-KB pages, that is allocated to database system monitor data. The AUTOMATIC value means that the monitor heap size can increase as needed until the limit of the instance memory is reached. |
KEEPFENCED | NO | Indicates whether a fenced mode process is kept after a fenced mode routine call is complete. If you have many fenced processes, you can set the KEEPFENCED setting to YES, but then you must monitor your memory usage. |
AGENT_STACK_SZ | For UNIX or Linux operating
systems: 1024 For Windows operating system: 1000 |
Determines the amount of virtual memory, measured in 4-KB pages, that is allocated for each agent. |