Re: enq: HW – contention..

Balwanth,

That table is the one underlying views such as DBA_AUDIT_TRAIL, so high INSERT volumes indicate that someone has used the AUDIT command to initiate database auditing to a level which may be growing intrusive.

You may want to examine the DBA_AUDIT_TRAIL view and find what types of auditing are being generated, and decide if it is necessary or not.

Be aware that people sometimes use the AUDIT command for temporary debugging or troubleshooting purposes, and they may forget to NOAUDIT after they find what they are seeking.

Good luck,

-Tim

On 2/24/17 07:26, Balwanth B wrote:
> Query is
>
> insert into sys.aud$( sessionid, entryid, statement, ntimestamp#,
> userid, userhost, terminal, action#, returncode, logoff$lread,
> logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text,
> spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#,
> process#, auditid, dbid) values(:1, :2, :3,
> SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12,
> cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17,
> :18, :19, :20, :21, :22)
>
>
>
> On Fri, Feb 24, 2017 at 9:24 AM, Balwanth B <balwanthdba_at_gmail.com
> <mailto:balwanthdba_at_gmail.com>> wrote:
>
> Hello everyone,
>
> we are seeing high enq: HW – contention causing by SYS TABLE
> AUD$ (Table under sys user names AUD..
>
> Any ideas how to resolve this?
>
>
> Thanks,
>
> Balwanth
>
>

--
http://www.freelists.org/webpage/oracle-l