SecureFile LOBs not reorganize by MQ Reorg (UC_REORG stored procedure)

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When using the automatic MQ Table reorganization (UC_REORG stored procedure), some tables with LOB fields, created with the 'SECUREFILE' parameter, are not being reorganized. i.e.: MQMEM.

For more details on Oracle Lob-Segments please see: https://oracle-base.com/articles/misc/alter-table-shrink-space-online.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Database: Oracle only

Cause

Starting from Oracle 12c LOB segments are created as SECUREFILE-LOBs by default, hence the automatic MQ-Table reorg doesn't work anymore as intended.

Resolution

Solution:

Update to a fix version listed below or a newer version if available.

Fix version:

Component(s): Automation Engine

Automation.Engine 12.2.10 - Available
Automation.Engine 12.3.7   - Available
Automation.Engine 21.0.0   - Available

Additional Information

For more details about the new UC_REORG procedure and its usage are available here