Hi,
we had ORACLE DB's running on FAS3050 for a long time. The only bottleneck we got were high RTT's in some cases but we managed to better this with bigger aggregates. I think there is a recomendation not to fill WAFL more than 80% as it is true for every filesystem i know.
The throughput was always ok on our DB-volumes. If your dba is not totaly convinced you can offer him the use of 15k-drives. We use them too and got great RTT's (normaly about 2-3ms) on our db-volumes.
I have never seen an FAS960 running oracle, but once i talked to a consultant from oracle and he said, that in his lab he has some 960 running oracle db's over NFS and it works fine.
On argument you can offer is that oracle itself uses Netapp and NFS and runs one of the biggest Netapp-Instalations in the world in their datacenter in Austin.
Another good point might be the capabilities of FlexClone. We do not use it right now but it can speed up development and integration! This is not special for 3050 or 960 but it is a plus for netapp.
For configuration issues you can find some best-practises and other articles on NOW. I would suggest to read them first, because there are some important points about mount-options! But i am still no expert about this whole topic, but i do my best to become one ;-)
Regards
Jochen
-----Original Message----- From: Miller, Michael CTR USTRANSCOM J2 [mailto:michael.miller.ctr@ustranscom.mil] Sent: Tuesday, December 05, 2006 7:38 PM To: Willeke, Jochen; toasters@mathworks.com Subject: RE: optimize volume/qtree for oracle db
Jochen I don't have the answer to your question but I do have a question for you. We have an Oracle db here that the dba wants to run it on an EMC system using RAID 10. We would have to buy the system but since we already have NetApp I am trying to convince him that a NetApp system (FAS960 or FAS3050) would do the job just fine. Can you let me know how you have your Oracle on NetApp configured and how well it works for you?
Thanks Mike Miller
-----Original Message----- From: owner-toasters@mathworks.com [mailto:owner-toasters@mathworks.com] On Behalf Of Willeke, Jochen Sent: Tuesday, December 05, 2006 11:01 AM To: toasters@mathworks.com Subject: optimize volume/qtree for oracle db
Hi,
currently we are running an oracle db on an FAS6070c and today we had some complaints that for some hours operations which use a lot of getattr-ops, like ls -la does, are slower than they used to be.
An oracle-colleague told me that he thinks there is a best-pratcise for volumes with oracle-db inside which describes something that boosts up getattr's.
I did not find anything appropriate on NOW. Has anybody ever come accross this issue?
Best Regards and thanks in advance
Jochen