审计 FGA_LOG$表清理

DB 11.2.0.4 ，oracle 12c之后审计表是按照时间切片自动分区

Partitioning The AUD$ Table (Doc ID 1379831.1)    

Is it supported to partition the SYS.AUD$ table?
No. Oracle does not support the partitioning of AUD$ in 11g or any of the previous releases. This is because of the architectural
 dependencies on these tables. If these tables are partitioned then you risk to encounter the following errors :
ORA-00600: internal error code, arguments: [kcbgtcr_1], [0], [0], [1], [620], [], [], []
ORA-07445: exception encountered: core dump [kgiopn()+1536] [SIGSEGV] [Invalid permissions for mapped object] [0x000000040] [] []

Note: New 12c CLI audit trails (Unified audit trail tables) are time partitioned and there is no plan to support partitioning of
 existing audit trail (aud$ and fga_log$) tables

数据库版本11G

审计参数DB

查询system表空间,segment 50G 是FGA_LOG$表

How to cleanup the log table FGA_LOG$ ? (Doc ID 402528.1)    
SQL> truncate table fga_log$;
Table truncated.
SQL> delete from fga_log$ where timestamp# < sysdate-14;

实际暂时未操作，计划停库关闭数据库审计功能后清理审计基表。

--在11G版本中，建议关闭审计选项。

alter system set audit_trail='none' scope=spfile sid='*';