DISABLE ALL EXISTING AUDIT OPTIONS

select 'noaudit '||AUDIT_OPTION || ' by '||user_name||';'  from dba_stmt_audit_opts where user_name is not null
union
select  'noaudit '||PRIVILEGE  || ' by '||user_name||';'   from dba_priv_audit_opts where user_name is not null
union
select 'noaudit '||AUDIT_OPTION || ';'  from dba_stmt_audit_opts where user_name is null
union
select  'noaudit '||PRIVILEGE  || ';'   from dba_priv_audit_opts  where user_name is null ;