Friday, July 27, 2007

Oracle Performance Papers on NetApp Storage URLs

I keeping receiving various queries about various platform performance papers for NetApp storage for Oracle databases.
Here's the list of my favorites not in any particular order.

Database Performance with NAS: Optimizing Oracle on NFS

http://www.netapp.com/library/tr/3322.pdf


Linux (RHEL 4) 64-Bit Performance with
NFS, iSCSI, and FCP Using an Oracle Database
on NetApp Storage
http://www.netapp.com/library/tr/3495.pdf


ORACLE 10g PERFORMANCE – PROTOCOL COMPARISON ON SUN SOLARIS 10
http://www.netapp.com/library/tr/3496.pdf


AIX Performance with NFS, iSCSI, and FCPUsing an Oracle® Database on NetApp Storage
http://www.netapp.com/library/tr/3408.pdf


Linux (RHEL 3 32bit): A Performance Comparison Study of Oracle® Real Application Clusters Against
FCP, NFS, and iSCSI

http://www.netapp.com/library/tr/3423.pdf

HP-UX® 64-Bit NFS Performance with NetApp Storage Using an Oracle10gTM Database
http://www.netapp.com/library/tr/3557.pdf

Tuesday, July 24, 2007

Mulitple DB Writers use'm or not?

There was this comment on some blog that suggested that given that now we're in 2007 and most operating systems that matter support async i/o. There shouldn't be a need for multiple db writers.

Though I agree in principal with that. However, I have observed in my testing using an OLTP workload on a Sun V40z RHEL4 64bit Performance on Oracle that it did help performance when using multiple dbwriters as many as cores on the system. I thought I'd pass this info on for any one that may be wondering.

Thursday, July 19, 2007

Space reservation on DataONTAP for Databases

There is an interesting discussion around space reservations for Data ONTAP in the following comments section -


Space Reservations in the comments section