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.
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.
Release : 12.3
Component : AUTOMATION ENGINE
Database: Oracle only
Update to a fix version listed below or a newer version if available.
Component(s): Automation Engine
Automation.Engine 12.2.10 - available
Automation.Engine 12.3.7 - Planned release in November 2021
Automation.Engine 21.0.0 - Available