RE: Oracle File System.
- From: Frits Hoogland <frits.hoogland@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 4 Mar 2004 16:09:34 +0100
and you are unable to do diagnostics with o/s filesystem depended tools like
vmstat, sar (-d)
(so your I/O is not visible on o/s layer)
frits
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of John Flack
Sent: donderdag 4 maart 2004 15:49
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle File System.
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 [mailto:mladen@xxxxxxxxxxxxxxx]
Sent: Thursday, March 04, 2004 9:26 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle File System.
On 03/04/2004 08:34:48 AM, ramalingam.rangadoure@xxxxxxx 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: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be copied,
disclosed to, retained or used by, any other party. If you are not an intended
recipient then please promptly delete this e-mail and any attachment and all
copies and inform the sender. Thank you.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
