My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The partition "HIGH_PART" of unified audit trail table "CLI_SWPxxxxxxx" can't be splitted 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 slave 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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