Re: enq: HW – contention..
Date: Fri, 24 Feb 2017 09:26:36 -0500
Message-ID: <CAL72EnBS0fWyE8NeY2HkQ18-Bu2XvAa20rzA_v3rKu1TY_nEXg_at_mail.gmail.com>
Query is
insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid,
On Fri, Feb 24, 2017 at 9:24 AM, Balwanth B <balwanthdba_at_gmail.com> wrote:
> Hello everyone,
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)
>
> 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
Received on Fri Feb 24 2017 - 15:26:36 CET