Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle File System.

RE: Oracle File System.

From: John Flack <>
Date: Thu, 4 Mar 2004 09:49:12 -0500
Message-ID: <>

I think Ranga is looking for advantages/disadvantages of storing database files as RAW as opposed to storing them in a file system, not for info on Oracle Internet File System.

Ranga -
RAW devices are going to make your database run faster, because Oracle can read and write directly to and from the disk, instead of requesting the operating system to provide this as a service. On the other hand, because your operating system does not own these disk partitions, it cannot provide the usual services like listing database files with a "ls" command, or showing free space with a "df". You will not be able to do a cold backup with os utilties "tar" or "cpio" - you'll need to use a command like "dd" that can operate on raw devices. However, if you use rman for backup and recovery, you probably won't care that you can't use tar or cpio.

Anyone else want to shed some light?

-----Original Message-----
From: Mladen Gogala [] Sent: Thursday, March 04, 2004 9:26 AM
Subject: Re: Oracle File System.

On 03/04/2004 08:34:48 AM, wrote:
> Hi All,
> We are using Oracle in Solaris environment for our application.
> We want to know the following things to go for a Oracle file system
> 1. Is it good to go for a file system,instead of storing data in
> RAW disk. If we are using file system what are the advantages...... like
> taking back up,crash over recovery,etc ......
> 2. Is there any disadvantage for using the file system..........
> like performance degrade.
> Please if any of you using the file system give the detail to us .

Oracle Internet File System presents oracle tables as files. It's just a presentation layer on top of the database. As databases are far more complex then file systems, that means that oracle IFS will be much slower then NFS or CIFS (to unix users known as Samba or SMB). On the other hand, loading things to and from the database will be reduced to copying things.

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Thu Mar 04 2004 - 08:54:06 CST

Original text of this message