Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle File System.
IMO a good way to a keep flexibility while achieving performance is to keep
datafiles on filesystem with directio and put just redologs on raw devices.
But for systems with high IO activity I often use LVM + RAW devices for both datafiles and redologs.
The complexity isn't that much higher and for high-performance systems some additional complexity isn't that much of issue either. And backup & recovery should novadays be done with RMAN anyway, so this raw device backup complexity issue becomes quite obsolete.
But, if you have a 2GB database with 5 users, then don't bother :)
Tanel.
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of John Flack
> Sent: donderdag 4 maart 2004 15:49
> To: oracle-l_at_freelists.org
> 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_at_wangtrading.com]
> Sent: Thursday, March 04, 2004 9:26 AM
> To: oracle-l_at_freelists.org
> Subject: Re: Oracle File System.
>
>
> On 03/04/2004 08:34:48 AM, ramalingam.rangadoure_at_tcs.com 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Mar 04 2004 - 10:56:15 CST
![]() |
![]() |