From oracle-l-bounce@freelists.org Sun Jul 31 12:33:42 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6VHXf9R017636 for ; Sun, 31 Jul 2005 12:33:41 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6VHXdIP017626 for ; Sun, 31 Jul 2005 12:33:39 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F3CE1DAEF6; Sun, 31 Jul 2005 12:33:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26813-03; Sun, 31 Jul 2005 12:33:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9C0791DAF84; Sun, 31 Jul 2005 12:33:36 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C595F6.1D6974F8" Date: Sun, 31 Jul 2005 20:34:33 +0300 Message-ID: <5A841A20A9085A4C984EADD0FF97BF3704F3C1@ectilex.ectel.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Q: oracle data files & performance Thread-Index: AcWV9h0+TbCf6IKqR8uObCeTDHcdEA== From: "Amihay Gonen" To: X-archive-position: 23087 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: AmihayG@ectel.com Precedence: normal Reply-To: AmihayG@ectel.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org Subject: Q: oracle data files & performance X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.1 required=5.0 tests=AWL,BAYES_00,HTML_50_60, HTML_FONTCOLOR_RED,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C595F6.1D6974F8 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi ,=20 I've received a two interesting questions from a collage of mine. =20 1) If two processes are writing to the same file , will they suffer from some conation on the file handler ?=20 Do you think that spreading very busy tables (has a lot of inserts from different sessions) on different tablespaces (which will be translate to different data files ) will have better I/O performance over one single data file ?=20 =20 I'm talking only from performance perspective , not from backup & recovery ? =20 2) If we have tablespaces with several data files . Will oracle allocate extents in a round-robin fashion between the files or will he fill one data file and then pass to the another data file ? =20 =20 =20 Amihay Gonen DBA, ------_=_NextPart_001_01C595F6.1D6974F8 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi ,=20

I've = received a two=20 interesting questions from a collage of mine.

If two = processes are=20 writing to the same file , will they suffer from some = conation on=20 the file handler ?

Do you = think=20 that spreading very busy tables (has a lot of inserts = from=20 different sessions) on different tablespaces (which will be = translate to=20 different data files ) will have better I/O performance over one single = data=20 file ?

I'm = talking only=20 from performance perspective , not from backup & recovery =20 ?

If we = have=20 tablespaces with several data files . Will oracle allocate extents in a=20 round-robin fashion between the files or will he fill one data = file and=20 then pass to the another data file ?

Amihay = Gonen
DBA,

------_=_NextPart_001_01C595F6.1D6974F8-- -- http://www.freelists.org/webpage/oracle-l