MQ Parameters (Oracle)

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

The Automation Engine checks the block size of the message queues MQPWP, MQWP, MQDWP, MWRWP, MQOWP and MQCPnnn at the interval specified in MQ_CHECK_TIME .Optionally, if the block size 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, thus improving the performance of your AE system.

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