Re: enq: HW – contention..
Date: Fri, 24 Feb 2017 07:48:49 -0700
Message-ID: <6fb07eac-fb84-3652-7e54-1bf5a51f8c32_at_gmail.com>
Balwanth,
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-lReceived on Fri Feb 24 2017 - 15:48:49 CET