From oracle-l-bounce@freelists.org Fri Jan 28 17:54:28 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0SNsS6J019694 for ; Fri, 28 Jan 2005 17:54:28 -0600 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 j0SNsSem019690 for ; Fri, 28 Jan 2005 17:54:28 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5AD506868B; Fri, 28 Jan 2005 17:53:38 -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 30744-02; Fri, 28 Jan 2005 17:53:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D351C686BB; Fri, 28 Jan 2005 17:53:37 -0500 (EST) Message-ID: <41FAC21A.8010606@alumni.sfu.ca> Date: Fri, 28 Jan 2005 14:52:10 -0800 From: Lyndon Tiu User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Oracle-L@freelists.org Subject: Many small ones or one big one. Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-OriginalArrivalTime: 28 Jan 2005 22:51:56.0600 (UTC) FILETIME=[F7CE1B80:01C5058B] X-archive-position: 15448 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ltiu@alumni.sfu.ca Precedence: normal Reply-To: ltiu@alumni.sfu.ca X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Hello, I know this question has been asked before but lacking the correct keywords, hard for me to search google for the answer. I would like to know if I have a large table in a database, is it better to put everything in one big datafile or split it up into a few smaller ones? What are the factors to investigate when decising how big to set datafiles? What are the advantages/disadvantages. Thanks. -- Lyndon Tiu -- http://www.freelists.org/webpage/oracle-l