"log file parallel write" wait times get increased a lot after upgrading from 10203 to 10204
- From: Eagle Fan <eagle.f@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 30 Nov 2010 15:07:09 +0800
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)
Other related posts:
