Re: enq: HW – contention..

there are some bugs and some notes on this area. i suggest you browse MoS. You may want to start here:

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1434614.1 <https://support.oracle.com/epmos/faces/DocumentDisplay?id=1434614.1>

https://support.oracle.com/epmos/faces/DocumentDisplay?id=2120366.1 <https://support.oracle.com/epmos/faces/DocumentDisplay?id=2120366.1>

https://support.oracle.com/epmos/faces/BugDisplay?id=20448588 <https://support.oracle.com/epmos/faces/BugDisplay?id=20448588>

> On Feb 24, 2017, at 6:48 AM, Tim Gorman <tim.evdbt_at_gmail.com> wrote:
>
> 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