Re: write complete waits

  • From: Matt Anderson <matta576@xxxxxxxxx>
  • To: jt2354@xxxxxxxxx, Michael Calisi <oracle455@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 28 Sep 2015 18:41:35 +0000

Why would there be a wait event for an asynchronous write to complete?
Isn't not waiting for completion the whole point behind asynchronous writes?

Matt

On Mon, Sep 28, 2015 at 12:00 PM John Thomas <jt2354@xxxxxxxxx> wrote:

Just the filesystem io one which defines asynchronous, direct io or etc as
supported by whatever platform you are on.

AIO driver status might be another thing to check.

Regards

JT

On Mon, 28 Sep 2015 18:05 Michael Calisi <oracle455@xxxxxxxxx> wrote:

No parameter changes recently? Any particular Oracle parameter you are
thinking about?


On Mon, Sep 28, 2015 at 12:25 PM, John Thomas <jt2354@xxxxxxxxx> wrote:

Is that not a wait for asynchronous write completion? Haven't changed
parameters related to filesystem io or similar recently, have you?

Regards

JT

On Mon, 28 Sep 2015 16:39 Michael Calisi <oracle455@xxxxxxxxx> wrote:

A new event suddenly start to appear in my Top 10 Events. Wondering
what may be the cause and how to avoid.it Any information will be
helpful.

Thanks,

Top 10 Foreground Events by Total Wait Time
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tota Wait % DB
Event Waits Time Avg(ms) time Wait
Class
------------------------------ ------------ ---- ------- ------
----------
DB CPU 14.5 18.1
write complete waits 115 13.8 120204 17.3
Configurat



Other related posts: