Re: [zfs-discuss] Oracle database on zfs

2009-03-04 Thread Vahid Moghaddasi
On Wed, Mar 4, 2009 at 12:18 PM, Richard Elling wrote: > Vahid Moghaddasi wrote: > >> Thank you all for reply. I will do the recommendation and see if there is >> any change in performance. >> I had seen the documents in the link but I needed to make sure that we can >> not do anything to improve

Re: [zfs-discuss] Oracle database on zfs

2009-03-04 Thread Richard Elling
Vahid Moghaddasi wrote: Thank you all for reply. I will do the recommendation and see if there is any change in performance. I had seen the documents in the link but I needed to make sure that we can not do anything to improve the performance before going to storage guys. You may not have muc

Re: [zfs-discuss] Oracle database on zfs

2009-03-04 Thread Vahid Moghaddasi
Thank you all for reply. I will do the recommendation and see if there is any change in performance. I had seen the documents in the link but I needed to make sure that we can not do anything to improve the performance before going to storage guys. Thanks again, Vahid. On Tue, Mar 3, 2009 at 9:4

Re: [zfs-discuss] Oracle database on zfs

2009-03-03 Thread David Magda
On Mar 3, 2009, at 20:51, Richard Elling wrote: This seems unusual, unless the EMC is mismatched wrt how they may have implemented cache flush. The issues around this are described in the Evil Tuning Guide http://www.solarisinternals.com/wiki/index.php/ZFS_Evil_Tuning_Guide#Cache_Flushes

Re: [zfs-discuss] Oracle database on zfs

2009-03-03 Thread Richard Elling
Vahid Moghaddasi wrote: Hi, I am wondering if there is a guideline on how to configure ZFS on a server with Oracle database? Start with the Best Practices Guide http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide We are experiencing some slowness on writes to ZFS filesys

[zfs-discuss] Oracle database on zfs

2009-03-03 Thread Vahid Moghaddasi
Hi, I am wondering if there is a guideline on how to configure ZFS on a server with Oracle database? We are experiencing some slowness on writes to ZFS filesystem. It take about 530ms to write a 2k data. We are running Solaris 10 u5 127127-11 and the back-end storage is a RAID5 EMC EMX. This is a