disable audit for sysman
How do I disable audit from sysman user? I tried noaudit commands to remove system audit.
SQL> select username, count(*) from SYS.DBA_AUDIT_OBJECT group by username order by 2 desc;
USERNAME COUNT(*)
------------------------------ ----------
SYSMAN 4434290
DBSNMP 2682256
SYSTEM 5860
I have even removed all audit options. I am still seeing audit records generated for sysman.
SQL> select * from dba_stmt_audit_opts
union
select * from dba_priv_audit_opts;
no rows selected
Here are some of the audit SQLs recorded:
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B1 , VALUE = :B6 , STRING_VALUE = :B5 WHERE TARGET_GUID = :B4 AND METRIC_GUID = :B3 AND KEY_VALUE = :B2 AND COLLECTION_TIMESTAMP < :B1