The dba tested on the two systems using NetApp/nSeries storage. Both are AIX lpars
The QA system is AIX 7100-03 Host Utilities 6.0.0.0 QA Mounts for one of 25 databases - all mounts are the same /dev/fslv148 /oracle/fnce20p/dbfiles jfs2 Jun 14 10:25 rw,cio,log=/dev/loglv50 /dev/fslv149 /oracle/fnce20p/temp jfs2 Jun 14 10:25 rw,cio,log=/dev/loglv50 /dev/fslv144 /oracle/fnce20p/logs1 jfs2 Jun 14 10:25 rw,cio,log=/dev/loglv49 /dev/fslv145 /oracle/fnce20p/logs2 jfs2 Jun 14 10:25 rw,cio,log=/dev/loglv49 /dev/fslv146 /oracle/fnce20p/archive jfs2 Jun 14 10:25 rw,log=/dev/loglv49 /dev/fslv147 /oracle/fnce20p/dump jfs2 Jun 14 10:25 rw,log=/dev/loglv49 /dev/ramdisk0 /oracle/fnce20p/tempram jfs2 Jun 22 06:05 rw,cio,log=INLINE One /etc/filesystems entry - all are the same /oracle/fnce20p/dbfiles: dev = /dev/fslv148 vfs = jfs2 log = /dev/loglv50 mount = true check = false options = rw,cio account = false The Prod system is AIX 6100-08 Host Utilities 6.0.0.0 Prod Mounts for one of 25 databases - all mounts are the same /dev/fslv148 /oracle/fnce20p/dbfiles jfs2 Jun 28 20:30 rw,cio,log=/dev/loglv50 /dev/fslv147 /oracle/fnce20p/dump jfs2 Jun 28 20:30 rw,log=/dev/loglv49 /dev/fslv149 /oracle/fnce20p/temp jfs2 Jun 28 20:30 rw,cio,log=/dev/loglv50 /dev/fslv145 /oracle/fnce20p/logs2 jfs2 Jun 28 20:30 rw,cio,log=/dev/loglv49 /dev/fslv146 /oracle/fnce20p/archive jfs2 Jun 28 20:30 rw,log=/dev/loglv49 /dev/fslv144 /oracle/fnce20p/logs1 jfs2 Jun 28 20:30 rw,cio,log=/dev/loglv49 One /etc/filesystems entry - all are the same. Mount is "false" due to this being a Veritas VCS cluster. /oracle/fnce20p/dbfiles: dev = /dev/fslv148 vfs = jfs2 log = /dev/loglv50 mount = false check = false options = rw,cio account = false From: jordan slingerland [mailto:jordan.slingerl...@gmail.com] Sent: Wednesday, June 29, 2016 8:30 PM To: Rhodes, Richard L. <rrho...@firstenergycorp.com> Cc: toast...@teaparty.net Subject: Re: OnTap read block size? Please post the mount line from /etc/fstab or /etc/filesystems etc along with client os version On Jun 29, 2016 10:44 AM, "Rhodes, Richard L." <rrho...@firstenergycorp.com<mailto:rrho...@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 toast...@teaparty.net<mailto:toast...@teaparty.net> http://www.teaparty.net/mailman/listinfo/toasters ----------------------------------------- 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.