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

  • From: Kevin Jernigan <kevin.jernigan@xxxxxxxxxx>
  • To: Don Seiler <don@xxxxxxxxx>
  • Date: Thu, 16 Oct 2014 12:18:01 -0700

Don,

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@xxxxxxxxxx <mailto:kevin.jernigan@xxxxxxxxxx>> 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@xxxxxxxxxxxxx
    <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
    [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Hans Forbrich
    *Sent:* Thursday, October 16, 2014 11:30 AM
    *To:* oracle-l@xxxxxxxxxxxxx <mailto:oracle-l@xxxxxxxxxxxxx>
    *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

Other related posts: