Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Filesystem for Linux production database server?
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 servicesto: [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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: [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
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message