From: Reidy, Ron (Ron.Reidy_at_arraybiopharma.com)
Date: Tue Sep 30 2003 - 00:15:09 CEST
Date: Mon, 29 Sep 2003 16:15:09 -0600 Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B1F7F3D@fiji.arraybp.com> From: "Reidy, Ron" <Ron.Reidy@arraybiopharma.com> Subject: RE: [suse-oracle] enabling async IO, performance questions
My performance issues are centered around many processes having large (numbers and seconds) of the wait event 'free buffer wait'. This wait is symptomatic of DBWR not being able to keep up with it's task load. In earlier version of Oracle, one could set up DBWR slaves. This feature is depricated. There are some other parameters (hidden and otherwise) that could be adjusted to help with this issue, but from my research (Steve Adfam's site, metalink, Google), using async IO would yield the biggest bang for the buck.
I am not sure about what factor it will improve things. I will need to test it out. In my situation described above, I expect this wait event to significantly decrease or vanish altogether.
I do not know of any side effects.
-----------------
Ron Reidy
Senior DBA
Array BioPharma, Inc.
303.386.1480
-----Original Message-----
From: Volkmar Woinke [mailto:biotechman73@yahoo.com]
Sent: Monday, September 29, 2003 4:02 PM
To: SuSE-oracle@suse.com
Subject: RE: [suse-oracle] enabling async IO, performance questions
Hi everyone,
Following the thread, I was reminded of the fact that
I wanted to ask the list about performance issues
related to async IO.
1.) Can the experienced folks give any indication as
to how enabling async IO can improve performance, i.e.
roughly speaking by what factor can it improve, given
that all other factors are left alone ?
[I am aware that this is somewhat difficult to answer,
but just a general hint would be fine, "Forget it, not
worth the effort", or "You should look into it, it can
help quite a bit", something like that =) ]
2.) Are there any negative sideffects [makes Oracle
less stable, etc.] for 9iR2 on Linux that are known or
that anyone has encountered ? I'm debating enabling it
on my production server, but given the fact that the
machine has more muscle than is even required at this
point, I'm having second thoughts about giving it a
go...
Thanks,
Volkmar
=====
War is terrorism on a bigger budget.
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- To unsubscribe, email: suse-oracle-unsubscribe@suse.com For additional commands, email: suse-oracle-help@suse.com Please see http://www.suse.com/oracle/ before posting This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system. -- To unsubscribe, email: suse-oracle-unsubscribe@suse.com For additional commands, email: suse-oracle-help@suse.com Please see http://www.suse.com/oracle/ before posting
This archive was generated by hypermail 2.1.7 : Tue Sep 30 2003 - 00:15:41 CEST