Thank you very much Robert Freeman for your opinion. I
am half way through your book of 9i new features. It
is very good.
Could some one else give some opinion on the need to
spread IO even when using EMC storage please.
- "Freeman, Robert " <Robert_Freeman_at_csx.com> wrote:
> I'd stick to the idea of fewer file systems. Here is
> why:
>
> 1. Shorter system reboot time (fsck doesn't take as
> long with
> fewer file systems).
>
> 2. Fewer file systems reduce the risk of Inode
> corruption.
>
> 3. Fewer file system easier to manage.
>
> As for EMC and IO and performance, I'm not sure I'm
> the
> best person to address that question.
>
> RF
>
> Robert G. Freeman
> Author Oracle9i New Features by Oracle Press
> Mastering Oracle8i By Sybex
>
> -----Original Message-----
> From: Johnson Poovathummoottil
> [mailto:joni_65_at_yahoo.com]
> Sent: Wednesday, April 24, 2002 8:58 AM
> To: LazyDBA.com Discussion
> Subject: Number of File systems to use.
>
>
> 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.
>
> 1: 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.
>
> 2: 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/
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> To subscribe: send a blank email to
> oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
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 Thu Apr 25 2002 - 09:48:33 CDT