Re: Is filesystemio_options relevant when the database is on ASM ?

Why do you recommend not using ZFSSA for live databases yet? We (Oracle) have many customers using ZFSSA for live production environments - including our own IT department, with >200PBs of ZFSSA storage in place for applications that support all aspects of our business...

-Kevin J

-- 
Kevin Jernigan
Senior Director Product Management
Advanced Compression, Hybrid Columnar
Compression (HCC), Database File System
(DBFS), SecureFiles, Database Smart Flash
Cache, Total Recall, Database Resource
Manager (DBRM), Direct NFS Client (dNFS),
Continuous Query Notification (CQN),
Index Organized Tables (IOT), Information
Lifecycle Management (ILM)
+1-650-607-0392 (o)
+1-415-710-8828 (m)

On 10/16/14, 11:32 AM, Don Seiler wrote:


> Yes in 12c DNFS works on NFSv4. In fact, NFSv4 is required if you plan 

> to use OISP (Oracle Intelligent Storage Protocol) to talk to their 

> ZFSSA. Although I would not suggest using the ZFSSA to run live 

> databases yet. Should be OK for FRA uses.

>

> Don.

>

> On Thu, Oct 16, 2014 at 10:46 AM, Kevin Jernigan 

> <kevin.jernigan_at_oracle.com <mailto:kevin.jernigan_at_oracle.com>> wrote:

>

>     As of Oracle Database 12c, dNFS works with both NFSv3 and NFSv4...KJ

>

>     -- 

>     Kevin Jernigan

>     Senior Director Product Management

>     Advanced Compression, Hybrid Columnar

>     Compression (HCC), Database File System

>     (DBFS), SecureFiles, Database Smart Flash

>     Cache, Total Recall, Database Resource

>     Manager (DBRM), Direct NFS Client (dNFS),

>     Continuous Query Notification (CQN),

>     Index Organized Tables (IOT), Information

>     Lifecycle Management (ILM)

>     +1-650-607-0392  <tel:%2B1-650-607-0392>  (o)

>     +1-415-710-8828  <tel:%2B1-415-710-8828>  (m)

>

>     On 10/16/14, 8:37 AM, Hameed, Amir wrote:

>>

>>     I don't believe DNFS is certified to work with NFSv4.

>>

>>     *From:*oracle-l-bounce_at_freelists.org

>>     <mailto:oracle-l-bounce_at_freelists.org>

>>     [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Hans Forbrich

>>     *Sent:* Thursday, October 16, 2014 11:30 AM

>>     *To:* oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>

>>     *Subject:* Re: Is filesystemio_options relevant when the database

>>     is on ASM ?

>>

>>     On 16/10/2014 3:35 AM, Frits Hoogland wrote:

>>

>>         When using NFS underneath ASM, I've witnessed

>>         filesystemio_options being honoured by the database, which

>>         means it needs setting it to 'setall' for the combination

>>         AIO+DIO. Which makes sense, because you need to create a file

>>         on a (NFS) filesystem to be used as ASM disk device.

>>

>>     Then it becomes important to know which NFS?

>>

>>     I believe DNFS behaves different than standard NFSv3 which may be

>>     different again from NFSv4

>>

>>     /Hans

>>

>

>

>

>

> -- 

> Don Seiler

> http://www.seiler.us



--
http://www.freelists.org/webpage/oracle-l