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

See also:

UC_SYSTEM_SETTINGS - Systemwide Settings