Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Oscar.

Asked: January 18, 2025 - 10:31 pm UTC

Last updated: January 24, 2025 - 8:05 am UTC

Version: 19

Viewed 1000+ times

You Asked

Hi!,

What is the best way to defragment SYS.AUD$?

It is possible to use DBMS_REDEFINITION.REDEF_TABLE ?


Thank you in advance.

and Connor said...

The best way would be to use DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION to move AUD$ to a new tablespace.

That will unload/reload the data

Rating

  (2 ratings)

Comments

Oscar, January 22, 2025 - 6:16 pm UTC

Would there be something wrong with using shrink on sys.aud$?
Connor McDonald
January 23, 2025 - 6:08 am UTC

I suspect it would work, but "work" is not the same as "supported" :-)

I would be raising an SR for confirmation before heading down that path

A reader, January 23, 2025 - 6:39 am UTC

Thank you very much Connor,

All the best !

Connor McDonald
January 24, 2025 - 8:05 am UTC

glad we could help

More to Explore

DBMS_AUDIT_MGMT

More on PL/SQL routine DBMS_AUDIT_MGMT here