Thanks for the question, krishna.
Asked: May 04, 2017 - 11:17 am UTC
Last updated: May 06, 2017 - 2:21 am UTC
Version: 11.2.0.4
Viewed 1000+ times
You Asked
Hi,
In our prod database we could see more buffer busy wait events on query "insert on sys.aud$" table?
Can you explain why buffer busy wait occurred on sys.aud$ table and how to avoid ?
and Connor said...
That would suggest you perhaps have lots of auditing going on, hence getting contention for the AUD$ table.
Check the contents of:
DBA_OBJ_AUDIT_OPTS
DBA_PRIV_AUDIT_OPTS
DBA_STMT_AUDIT_OPTS
and see if you have any excessive auditing going on.
If you do need all the options set, then perhaps consider seeing if AUD$ is not in a ASSM tablespace, and moving to one (eg SYSAUX) if that is the case.
Is this answer out of date? If it is, please let us know via a Comment