RE: DBFS or ACFS for Flat Files and Dump Files
- From: Andy Rivenes <andy.rivenes@xxxxxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Fri, 29 Aug 2014 10:23:20 -0700 (PDT)
Just curious, by not practical do you mean having to call dbfs_client and not
being able to use a mounted file system?
Andy Rivenes
From: Ls Cheng [mailto:exriscer@xxxxxxxxx]
Sent: Friday, August 29, 2014 10:18 AM
To: Andy Rivenes
Cc: fuzzy.graybeard@xxxxxxxxx; Oracle Mailinglist
Subject: Re: DBFS or ACFS for Flat Files and Dump Files
Yes fuse is only available for linux and solaris.
I have tried to use DBFS in AIX and it is simply not practical :-)
On Fri, Aug 29, 2014 at 5:46 PM, Andy Rivenes <HYPERLINK
"mailto:andy.rivenes@xxxxxxxxxx"; \nandy.rivenes@xxxxxxxxxx> wrote:
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:HYPERLINK "mailto:fuzzy.graybeard@xxxxxxxxx";
\nfuzzy.graybeard@xxxxxxxxx]
Sent: Friday, August 29, 2014 5:54 AM
To: HYPERLINK "mailto:oracle-l@xxxxxxxxxxxxx"; \noracle-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 (as
opposed 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:
