Oracle-L: Number of File systems to use.

From: Johnson Poovathummoottil <joni_65_at_yahoo.com>
Date: Wed, 24 Apr 2002 05:58:31 -0800
Message-ID: <F001.0044DB2A.20020424055831@fatcity.com>

All,

Although this has been discussed many times. My boss wants other opinions on this.

We EMC storage whcih uses 9 gig disks.
We also use veritas volume manager.

We plan to upgrade our SUN ultra e6500 to sun fire 15K machine. During to move we want to do a little reorg. This machine will have 6 partitions, 3 for the OLTP databases and 3 for the warehouse.

The warehouse currently uses 20 file systems 25 GB each(3 disks raid S) for data and index. We have agreed on making the file systems to use 4 disks and stripe it with 256 KB stripe size. There are two opinions regarding the number of file systems.

50 file systems of 15 GB each. In this case the 4 disks are not fully used. What is ramainig after the 15 GB can be alloted to other file systems other than the ones used by the database. Advantage IO spread over disks.
20 file systems of 34 GB each. All four disks are fully used. IO over 80 disks.

Question.:
1:Since we are using EMC do we need to pay so much attention to spreading IO.
2: Any problems/advantages in having too many file systems.

Please give all your opinions.

Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/
--

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

Author: Johnson Poovathummoottil
INET: joni_65_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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 Wed Apr 24 2002 - 08:58:31 CDT