Re: DBWR performance

From: <andrew.protasov_at_gmail.com>
Date: Sun, 20 May 2012 13:40:47 -0700 (PDT)
Message-ID: <78a5f117-8c5d-4730-b13f-266b0931774f_at_googlegroups.com>

I found it in redhat docs for oracle (sorry, ugly link). There is no timing there either. But it matched your recommendation for deadline scheduler, so how bad could it really be :-).

http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&ved=0CG4QFjAC&url=http%3A%2F%2Fwww.redhat.com%2Frhecm%2Frest-rhecm%2Fjcr%2Frepository%2Fcollaboration%2Fjcr%3Asystem%2Fjcr%3AversionStorage%2Fee6fe0000a0526020f35498ae39e9939%2F11%2Fjcr%3AfrozenNode%2Frh%3AresourceFile&ei=2VS5T8jCHciugQfBx_jNCg&usg=AFQjCNHnR8YHYz3LMEmQW7IG3YmhYT0VoQ

4.1.3 Automatic System Tuning for Database Storage The tuned package in Red Hat Enterprise Linux 6.2 is recommended for automatically tuning the system for common workloads: enterprise storage, high network throughput, and power savings. For Oracle Database, enable the enterprise-storage profile to set the I/O scheduler, adjust the read-ahead buffers for non-system disks, etc.

# yum install tuned
# chkconfig tuned on
# tuned-adm profile enterprise-storage

On Sunday, May 20, 2012 3:10:27 PM UTC-5, Mladen Gogala wrote:
> On Sun, 20 May 2012 11:39:39 -0700, andrew.protasov wrote:
>
> > Is there oracle use case with timing before and after the change where
> > it helped?
>
> No, there is my ample experience and common sense. Is there a documented
> Oracle use case where using "tuned" has helped?
>
>
>
> --
> http://mgogala.byethost5.com
Received on Sun May 20 2012 - 15:40:47 CDT