RE: "log file parallel write" wait times get increased a lot after upgrading from 10203 to 10204

From: <Joel.Patterson_at_crowley.com>
Date: Tue, 30 Nov 2010 09:35:00 -0500
Message-ID: <862A23A0E240AC489F5234B8E410B6200E93B732_at_JAXMSG03.crowley.com>

The default for _lgwr_async_io = false, right? At least it is in my database.

It is a hidden parameter, so was it changed in 10203? Perhaps ... Not sure how much documentation there is on these parameters, but might be inclined to believe that because they are hidden there is a shortage of documentation.

Joel Patterson
Database Administrator
904 727-2546

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eagle Fan Sent: Tuesday, November 30, 2010 2:07 AM To: oracle-l_at_freelists.org
Subject: "log file parallel write" wait times get increased a lot after upgrading from 10203 to 10204

hi:

I noticed that after upgraded from 10203 to 10204, the number of waits of parallel write got increased a lot.

We are using lgwr async IO (_lgwr_async_io=true and disk_asynch_io=true). OS is Solaris 10. SNAP_TIME TOTAL_WAITS TIME_WAITED
----------------- ----------- -----------

20100425 00:00:00        1193          20
20100426 00:00:00        1187          19
20100427 00:00:00    83753743     3122627  -- after upgraded from 10203 to 10204
20100428 00:00:00    94783396     3353594
20100429 00:00:00    96792543     3320591
20100430 00:00:00    98197875     3245199
20100501 00:00:00    98144618     3162137

I checked several databases, all of them had the same behavior.

I tried to find some docs to explain this on metalink, but I didn't find anything.

Did anybody also have such change before? What's the reason behind this?

And I'm curious what the result is if _lgwr_async_io is false.

Thanks in advance.

--

Eagle Fan (www.dbafan.com<http://www.dbafan.com>)

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 30 2010 - 08:35:00 CST