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@xxxxxxxxx> 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@xxxxxxxxx
<mailto:balwanthdba@xxxxxxxxx>> 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