Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to move LOB segment caused by unified auditing

User_KYWTCNov 23 2020 — edited Nov 23 2020

HI Team,

We enabled unified auditing and we are purging records every 3 hours. Even though we purge audit records for every 3 hours, we could see the LOB segment that is present under AUDSYS schema is not releasing the space.

We came to know it is due to the bug 18109788 : CLEANUP OF UNIFIED AUDIT TRAIL DOES NOT RELEASE LOB SEGMENT SPACE . But is there any way to reclaim space occupied by the lob segment? How to move the audsys LOB segment to another tablespace ?

OWNER SEGMENT_NAME SIZE_M
------ ----------------------------- --------------------- ----------
AUDSYS SYS_LOB0000091784C00014$$~ 107046.125

Thanks,
Bala

Added on Nov 23 2020

#database-security, #database-security-general

2 comments

2,674 views