Re: Multiple Datafiles and performance?

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