Unified audit trail table (CLI_SWPxxxx) can't be split (Doc ID 2482534.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

The partition "HIGH_PART" of unified audit trail table "CLI_SWPxxxxxxx" can't be split even the size is much bigger than 1024MB.

example:

col OWNER form a10
col TABLE_NAME form a30
col COLUMN_NAME form a20
col SEGMENT_NAME form a30
col PARTITION_NAME form a20
col LOB_PARTITION_NAME form a30

set linesize 160 pages 9999
select l.owner,l.table_name,l.column_name,l.segment_name,s.partition_name,p.partition_name,
trunc(s.bytes/1048576,1) "SIZE(MB)"
from dba_lobs l, dba_segments s, dba_lob_partitions p
where l.segment_name=s.segment_name
and s.tablespace_name='SYSAUX'
and l.owner='AUDSYS'
and l.table_name=p.table_name
and s.partition_name=p.lob_partition_name
order by 5 desc,2,3;

OWNER TABLE_NAME COLUMN_NAME SEGMENT_NAME PARTITION_NAME PARTITION_NAME SIZE(MB)
---------- ------------------------------ -------------------- ------------------------------ -------------------- -------------------- ----------
AUDSYS CLI_SWPxxxxxxx LOG_PIECE SYS_LOB0000086381C00014$$ SYS_LOB_P183538 HIGH_PART 449938.1                  <----       near to 450GB

Changes

In 12.1.0.2, The MMON worker action "CLI Partition execution" is used to split unified audit trail table "CLI_SWPxxxxxxx"

partition "HIGH_PART" every 5 mins.

When the return value of "BYTES" is more than 1024MB, the new partition should be splitted.

--The query to get the size of "HIGH_PART"

Select BYTES, extents from dba_segments where OWNER = :1 and PARTITION_NAME = :2

But, the data type of return value "BYTES" is UB4, when the query <Select BYTES, extents from dba_segments

where OWNER = 'AUDSYS' and PARTITION_NAME = 'HIGH_PART'> reaches 4596760 blocks and 37656657920 bytes size,

the return will overflowed and the partition will not be splitted.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.