Re: Multiple Datafiles and performance?

Note that in previous mail, my reply starts from 2nd paragraph, the first one wasn't indented correctly for some reason..

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, August 08, 2003 2:59 PM

> > As for the datafiles and indexfiles being distributed over different
> physical disks, well I can not confirm you are wrong, in our site id DID
> boost the performance, and specially if you locate in separate physical
> drives your redologs and datafiles (both indexes or data). Of course it
> depends on the server's work load and how many people are simultaneously
> accesing data and indexes. I can understand what you say but if many
> different users are accesing the same table via indexes and both the
table's
> data and the indexes are on the same physical drive I think performance
> should be worst than if they were separated, right or wrong? ...
>
> Wrong, because in multi-user environment, disk reading heads will never be
> physically be in same place where you "left" them. (Well, almost never,
> depending on your IO queue length).
>
> Are you comparing oranges with oranges here - if you got one disk in your
> server and get performance boost by buying another disk in and putting
some
> files (doesn't matter which files) on new disk, then you are comparing 1
> disk vs. 2 disks, and that doesn't have anything to do with the type of
> segments in the files.
>
> Tanel.
>
>
> --
> 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).
>

-- 
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).