Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Filesystem for Linux production database server?

Re: Filesystem for Linux production database server?

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Sun, 29 Jun 2003 10:36:41 -0700
Message-ID: <F001.005BBDF3.20030629101439@fatcity.com>


Linux file systems usually do not support direct I/O (bypassing the buffer cache), which means that you're going to have double caching with almost everything except raw devices. You can have up to 256 raw devices on a Linux box and if your database is small enough (32-bit system, 2G limit applies), that will definitely be the fastest option. My recommendation is to go with IBM JFS because it is a battle tested, mature, well performing file system. I would advise against XFS because nobody uses it. As for availability, you'll have to go with some RAID controller and standby database or RAC. In case of RAC, your choice of file systems is clear (OCFS). Whatever you do, do not configure your RAID as RAID-5 but RAID 1+0 (BARF).

which means that
On 2003.06.29 11:44, zhu chao wrote:
Hi, friends that run oracle on linux:

    We are running some database on linux, some with UPS protection and some not, all using ext2. Currently we have a DW server running oracle 817/Redhat 7.2/Ext2. When server crash because of power supply, fsck took rather long time!

    And we are planning migrate to redhat as2.1/9.2, and I am thinking of what kind of filesystem shall I choose for the new server. The database is about 150G.I had planned to use ext3 for it is journal filesystem, But according to http://www.linuxjournal.com/article.php?sid=5841, ext3 is bad for performance, and some friend said he hit filesystem crash with ext3.

    So,what is your experience using filesystem for oracle in linux? Performance and avaliability is of most important.

    Thanks.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.cnoug.org
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: zhu chao
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Mladen Gogala
Oracle DBA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mladen Gogala
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Jun 29 2003 - 12:36:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US