Re: DBWR pegged out
Date: Tue, 8 Mar 2011 18:55:01 -0800 (PST)
Stop asking the *right* question! I need my bandwidth allotment to ask rhetorical questions.
PS. Beer circa EOM March! Be there!
From: Greg Rahn <greg_at_structureddata.org> To: oracle-l_at_freelists.org
Sent: Tue, March 8, 2011 10:51:41 AM
Subject: 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
What does the ASH report show?
On Tue, Mar 8, 2011 at 9:59 AM, Kevin Closson <ora_kclosson_at_yahoo.com> 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_at_its.msstate.edu>
> To: oracle-l_at_freelists.org
> 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
> is still getting pegged out. "write complete waits" will become a top time
> drilling down will show:
> SID User Wait state/time Waiting Location
> 23 db_user In waiting (2ms) write complete waits, TEMP
> 30 db_user In waiting (88ms) write complete waits, TEMP
> 179 db_user In waiting (101ms) write complete waits, TEMP
> 189 db_user In waiting (0ms) write complete waits, TEMP
> 354 db_user In waiting (109ms) write complete waits, TEMP
> 1532 db_user In waiting (6ms) write complete waits, TEMP
> 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 18.104.22.168 on solaris sparc 64.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 08 2011 - 20:55:01 CST