Oracle-L: Re: asynch I/O

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 18 Sep 2003 23:24:43 -0800
Message-ID: <F001.005D06BA.20030918232443@fatcity.com>

Hi!

You can have spread your datafiles in 1, 2, 3,4 ..100 different directories or mount points, but the performance remain the same for all of them as long as all the mount points are striped on the same disks.

If you think of mount points as different sets of disks, e.g. when adding a new mount point, you add more disks, then yes, IO performance will improve, because larger number of disks.

Tanel.

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 19, 2003 5:09 AM

> Could you clarify something for me? Are you saying that if I have a
variety
> of 'mounts' on our netapp
>
> say
>
> /mnt1
> /mnt2
>
> I would not benefit by putting my datafiles on seperate ones? I thought
that
> is where my I/O waits are coming from. Since we have all of our datafiles
in
> the same directory?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ryan
> INET: rgaffuri_at_cox.net
>
> 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: 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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: 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 Fri Sep 19 2003 - 02:24:43 CDT