Re: DBWR pegged out

I'd be asking what "write complete waits" have to due with temp.
Looks to me that its something to do with transactions and
rollback/undo.
http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/waitevents003.htm#sthref4131

What does the ASH report show?

On Tue, Mar 8, 2011 at 9:59 AM, Kevin Closson <ora_kclosson@xxxxxxxxx> wrote:
> I'd be asking myself (and oracle perhaps) two questions: 1) why am I writing
> to TEMP at all and 2) if sessions need to spill to temp on 11.2 why are they
> not doing so in the direct path?
>
> BTW, what class of server is this?
>
> ________________________________
> From: Doug Gernaat <dag@xxxxxxxxxxxxxxx>
> To: oracle-l@xxxxxxxxxxxxx
> Sent: Tue, March 8, 2011 7:55:04 AM
> Subject: DBWR pegged out
>
> after oracle suggested bumping up db_writer_processes from 2 to 4, at times
> it
> is still getting pegged out. "write complete waits" will become a top time
> event.
> drilling down will show:
>
> SID    User                            Wait state/time    Waiting Location
> 23    db_user              In waiting (2ms)    write complete waits, TEMP
> datafile:604
> 30    db_user              In waiting (88ms)    write complete waits, TEMP
> datafile:604
> 179    db_user              In waiting (101ms)    write complete waits, TEMP
> datafile:604
> 189    db_user              In waiting (0ms)    write complete waits, TEMP
> datafile:604
> 354    db_user              In waiting (109ms)    write complete waits, TEMP
> datafile:604
> 1532    db_user              In waiting (6ms)    write complete waits, TEMP
> datafile:604
>
> and diff users will fall in out of these write complete waits. i always see
> TEMP... not any other dfiles.
> also during these times... ora_ckpt will start blocking other sessions. is
> this I/O contention? any suggestions?
>
> dbwr_io_slaves is set to 0.
> this is 11.2.0.2 on solaris sparc 64.
>
> thanks
> -doug-

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Other related posts: