Re: DBFS or ACFS for Flat Files and Dump Files

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: Andy Rivenes <andy.rivenes@xxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 29 Aug 2014 11:18:25 -0600

Thanks for the correction. I was not aware there was a DBFS_CLIENT was available for Windows or AIX.


/Hans

On 29/08/2014 9:46 AM, Andy Rivenes wrote:
DBFS or ACFS for Flat Files and Dump Files

Actually mounting DBFS is restricted to Linux and Solaris because FUSE is used, but dbfs_client itself can access DBFS on any platform that the database is supported on.

Andy Rivenes

*From:*Hans Forbrich [mailto:fuzzy.graybeard@xxxxxxxxx]
*Sent:* Friday, August 29, 2014 5:54 AM
*To:* oracle-l@xxxxxxxxxxxxx
*Subject:* Re: DBFS or ACFS for Flat Files and Dump Files

I find it interesting that, on Exadata, Oracle says yes to DBFS and (until GI 12.1.0.2) said no to ACFS. https://blogs.oracle.com/RobertGFreeman/entry/exadata_support_for_acfs_and

And for Exadata, it is the only real way to hold these staging files. Works like a charm and is the best practice.

See also http://kevinclosson.net/2009/12/17/oracle-database-file-system-dbfs-its-not-an-exadata-feature-part-i/

As far as I'm concerned, the DBFS is simply the latest evolution to the oradav capability that has allowed us to 'mount the database table as a file system' since Oracle8i. It has had many years to mature and become robust, but the concept is from the late 90s.

However, dbfs_client is only available on Linux.

/Hans

On 29/08/2014 3:12 AM, Chitale, Hemant K wrote:

    Are there organisations that have the courage to use DBFS or ACFS
    to hold

    (a) Flat Files to be interpreted as External Tables

    (b) Dump Files to be transferred to other databases

    What would be the objections to using storage on the Database
    Server  (asopposed to NFS) ?

    Hemant K Chitale


    This email and any attachments are confidential and may also be
    privileged. If you are not the intended recipient, please delete
    all copies and notify the sender immediately. You may wish to
    refer to the incorporation details of Standard Chartered PLC,
    Standard Chartered Bank and their subsidiaries at
    https://www.sc.com/en/incorporation-details.html.


Other related posts: