Version: 11.2.0.4 , we already moved tables to new dedicated table space
that did not solve our issue, now main issue we are seeing is DBWR blocking
sessions. There is no increase in application load,no storage changes
happend
8672, 1( 2) 11.23 free buffer waits 11.22 SYS oracle@xxxxxxxxxxxxxxxx
(DBW4) 9/60
[ 15%] 0
8295, 1( 2) 6.44 free buffer waits 6.44 SYS oracle@xxxxxxxxxxxxxxxx (DBW3) 9/60
[ 15%] 0
select *
from v$sysstat
where name in ('free buffer requested','free buffer inspected');
147 free buffer requested 8 14867814106 3411924934
151 free buffer inspected 8 13762349048 941676439
Thanks,
Balwanth
On Fri, Feb 24, 2017 at 9:53 AM, Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
wrote:
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=2120366.1
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> 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