Database Administration (MOSC)

MOSC Banner

disable audit for sysman

edited Apr 9, 2015 2:35PM in Database Administration (MOSC) 2 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center