7-mode or cDOT? (presume 7-mode)
NFS or LUN (presume NFS)
Were the best practices followed when mounting ? There is a NetApp library doc with the appropriate mount options for most UNIXs Possibly even a KB
Is the NetApp configured for large read/write sizes? The default was like 32K and you can increase to 64K (65536)
What about using Oracle's NFS stack and by-passing the OS? This is MUCH FASTER!
--tmac
*Tim McCarthy, **Principal Consultant*
On Wed, Jun 29, 2016 at 10:36 AM, Rhodes, Richard L. < rrhodes@firstenergycorp.com> wrote:
OnTap 8.1.2p1
Our DBA's are complaining that our nSeries (N3220/FAS2240) is reading really slow due to it only returning small 16k blocks. The DBA's are saying the Oracle multi-block read ahead should be reading 128 x 16k blocks = 2m read, but it's only seems to be reading/returning 16k at a time.
On a AIX filesystem mounted CIO, if I run
"dd if=/dev/zero of=z bs=1m count=9999"I see writes of 500k.
In the same filesystem mounted CIO, if I read an existing db file
"dd if=<dbfile> of=/dev/null bs=1m"
I see reads of up to 30k.
Q) Is there a limit in OnTap on read size?
Thanks
Rick
- The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. *
Toasters mailing list Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters