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

book

Article ID: 206878

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine 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.

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. 

 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Database: Oracle only

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  - Planned release in November 2021
Automation.Engine 21.0.0  - Available