MQ Parameters (Oracle)

Systemwide variables that contain the parameters relevant for the message queues in Oracle environments.

The Automation Engine checks the block count of the message queue tables (MQPWP, MQWP, MQDWP, MQRWP, MQOWP and MQCPnnn) at the interval specified in MQ_CHECK_TIME.

Note: Optionally, if the block count exceeds the value specified in MQ_BLOCK_COUNT, you can set AUTOMATIC_MQ_REORG to Y and have the Automation Engine automatically reorganize the message queue. We highly recommend contacting our Support Team before you change this parameter because, in some cases, it may negatively affect your system performance.

AUTOMATIC_MQ_REORG

Description: Determines whether the message queue tables are reorganized automatically.
Allowed values: Y and N
Default value: N
Restart required: No

MQ_BLOCK_COUNT

Description: Defines the number of blocks after which the message queue is to be reorganized.
Allowed values: 0 to 100000
Default value: 64
Restart required: No

MQ_CHECK_TIME

Description: Defines the interval in seconds at which message queues are checked.
Allowed values: 0 to 1000000

Value 0 means that no check is made.
Default value: 600
Restart required: No