Re: log writer tuning

Anand Rao wrote:
Sure, i agree it is too general and that it could not even be an IO problem.
my suggestion was to go raw for redologs since its good for redo write performance. Now, Direct IO is another beast. i do have my reservations about it but hey, its a free world.
if Remigiusz can tell us that raw volumes for redologs aren't worth it since he tried it, then we have definitive proof.
without knowing the disk array details, i really can't comment. i don't even know what application he has, what's the IO rate/pattern, especially redo rate. 



thanks for advice.
In general we moved from raw devices to file system files due to easier management and probably wouldn't resign of it 


--
---------------------------------------
Remigiusz Sokolowski <rems@xxxxxxxx>
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL  v.  4.x
Oracle v. 10.x
---------------------------------------

--
http://www.freelists.org/webpage/oracle-l

Other related posts: