Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 5811 invoked from network); 8 Aug 2006 10:20:12 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 10:20:10 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6979D3BD515; Tue, 8 Aug 2006 11:19:54 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06699-06; Tue, 8 Aug 2006 11:19:54 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DD6663BCE0D; Tue, 8 Aug 2006 11:19:53 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 11:19:04 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C76303BCFA3 for ; Tue, 8 Aug 2006 11:19:03 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06479-07 for ; Tue, 8 Aug 2006 11:19:03 -0400 (EDT) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6616B3BCF4D for ; Tue, 8 Aug 2006 11:19:02 -0400 (EDT) Received: by py-out-1112.google.com with SMTP id z74so1654304pyg for ; Tue, 08 Aug 2006 08:19:13 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=dSoZxou6qgJXmjN/C73XWEPuAu5r/qGt/quVM63y/xNMWbO6ItP00obMqNGU9ETqg4ydL15/SyUb2b4Vwybc2AeHqH5BJx8hu9WrtSDmXuZWcRDJHP7iIzxsZyg5OqCJ4jN4MkE/TN9xaKNN05XVUhe1z4sjBE/2nd1XvHSAsQU= Received: by 10.35.26.14 with SMTP id d14mr14815695pyj; Tue, 08 Aug 2006 08:19:12 -0700 (PDT) Received: by 10.35.80.7 with HTTP; Tue, 8 Aug 2006 08:19:12 -0700 (PDT) Message-ID: Date: Tue, 8 Aug 2006 23:19:12 +0800 From: "Lou Fangxin" To: niall.litchfield@gmail.com Subject: Re: MAXSIZE 32767M Cc: "Sergey Popov" , "Oracle Discussion List" In-Reply-To: <7765c8970608031226t3be2a4c6ja3369d85960eee98@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_72030_17146729.1155050352368" References: <40a16b360608031017s7866f3d9oef369beb1381b793@mail.gmail.com> <7765c8970608031050y56e257a7p2dd376ded7aea8f@mail.gmail.com> <7765c8970608031226t3be2a4c6ja3369d85960eee98@mail.gmail.com> X-archive-position: 37880 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: anysql@gmail.com Precedence: normal Reply-to: anysql@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net ------=_Part_72030_17146729.1155050352368 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline It's should be 2^22-1 blocks * db_block_size for single for tablespace under 10g or SMALLFILE on 10g, for BIGFILE tablespace in 10g, one fileonly per tablespace, then the maxsize is 2^32-1 blocks. On 8/4/06, Niall Litchfield wrote: > > tragically, I was responding from a mobile phone and so didn't have a > calculator when composing the mail. its 2^32 -1 blocks * blocksize which as > sergey states is 32gb for 8k blocks, would be 64gb for 16k blocks. > > I'll get my coat. > > > On 8/3/06, Sergey Popov wrote: > > > > 32Gb is the maximum for 8K blocks. > > > > > > On 8/3/06, Niall Litchfield wrote: > > > > > > dba_data_files. you have specified unlimited for max size when > > > creating the datafile. unlimited means the maximum no of blocks > > > multiplied by the block size of the ts. so you have a smallfile ts > > > with iirc a 16k blocksize. > > > > > > > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info > -- Welcome! Home: http://www.IamDBA.com ------=_Part_72030_17146729.1155050352368 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline It's should be 2^22-1 blocks * db_block_size for single for tablespace under 10g or SMALLFILE on 10g, for BIGFILE tablespace in 10g, one fileonly per tablespace, then the maxsize is 2^32-1 blocks.

On 8/4/06, Niall Litchfield <niall.litchfield@gmail.com> wrote:
tragically, I was responding from a mobile phone and so didn't have a calculator when composing the mail. its 2^32 -1 blocks * blocksize which as sergey states is 32gb for 8k blocks, would be 64gb for 16k blocks.

I'll get my coat.


On 8/3/06, Sergey Popov <sspopov@gmail.com> wrote:
32Gb is the maximum for 8K blocks.


On 8/3/06, Niall Litchfield <niall.litchfield@gmail.com > wrote:
dba_data_files. you have specified unlimited for max size when
creating the datafile. unlimited means the maximum no of blocks
multiplied by the block size of the ts. so you have a smallfile ts
with iirc a 16k blocksize.




--
Niall Litchfield
Oracle DBA
http://www.orawin.info



--
Welcome!
Home: http://www.IamDBA.com ------=_Part_72030_17146729.1155050352368-- -- http://www.freelists.org/webpage/oracle-l