Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h78DToO24285 for ; Fri, 8 Aug 2003 08:29:50 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h78DTnp24279 for ; Fri, 8 Aug 2003 08:29:49 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h78B6FI22150 for oracle-l@orafaq.net; Fri, 8 Aug 2003 04:06:15 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005C9A1F; Fri, 08 Aug 2003 03:59:22 -0800 Message-ID: Date: Fri, 08 Aug 2003 03:59:22 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Tanel Poder" Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Tanel Poder" Subject: Re: Multiple Datafiles and performance? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit > 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@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@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).