查看fga审计规则

select * from dba_audit_policies;

查看fga审计记录

select * from dba_fga_audit_trail;

对应基表sys.fga_log$ 该表带lob字段，

暂停fga审计

exec dbms_fga.disable_policy(object_schema=>'BSUSER', object_name=> 'MS_BRDA', policy_name=> 'MS_BRDA_AUDIT');

删除fga审计

exec dbms_fga.drop_policy(object_schema=>'BSUSER', object_name=> 'MS_BRDA', policy_name=> 'MS_BRDA_AUDIT');

清理日志表

truncate table sys.fga_log$

ITPub博客

oracle fga审计（字段级）