Received: (qmail 17836 invoked from network); 3 Mar 2011 13:57:05 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 3 Mar 2011 13:56:51 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98F56DAAE65; Thu, 3 Mar 2011 14:56:19 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1299182179; bh=CQK6vdFuBbkzBu6J+LYYC449qBsY0GmQEsVxnghM MMk=; h=MIME-Version:In-Reply-To:References:Date:Message-ID:Subject: From:To:Cc:Content-Type:Sender:Reply-To:List-help:List-unsubscribe: List-Id:List-subscribe:List-owner:List-post:List-archive; b=cPxkRh KmHK5L8Vz06Pp70Iwlf1ChTRScStSGj93eVdXgDiO8BDMT9uqZFHpIa8nQaWKQPONmh ybTB6n6PTNpSDkp8A4lUxu7nNGwq8H+xJFb15e4kTbe62FQvwwpn9X1kgzJ8/041Pr2 IgtKYdYuiq6b77mPIPGjrWhkVROVots= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ZL21up935ZRr; Thu, 3 Mar 2011 14:56:19 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B77BFDAAD8B; Thu, 3 Mar 2011 14:55:35 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 03 Mar 2011 14:54:54 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C1601DAA107 for ; Thu, 3 Mar 2011 14:54:53 -0500 (EST) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key) header.i=@gmail.com Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id z9bCXp2MR2lI for ; Thu, 3 Mar 2011 14:54:53 -0500 (EST) Received: from mail-wy0-f179.google.com (mail-wy0-f179.google.com [74.125.82.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 79240DA925C for ; Thu, 3 Mar 2011 14:54:47 -0500 (EST) Received: by wyb28 with SMTP id 28so1295193wyb.10 for ; Thu, 03 Mar 2011 11:54:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=1Tt41K+fOEGCY2vZkaBcU7BWRcJjI0U7Bnbbi5kblBY=; b=FgUoWhkM80xs6UUV8aylCFUaygyLnGsXqr6h9lFwnVS/UE+bxXxoL15IHyJPaz2ZrB mI00CJO0llJGhrhykDj3pW7tK56sxG919adBpl8lC9uFZA0Nrx2LC3zkSWUaIe8ZRAiy w1NJvkGoj/wr8ZblMNMORtMTvztk/oW4EUmsk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=ZssYVzlA1bhI/un7rc9DyZxwIrfx2Vj/41ApzxjO9RaZKez7IilqnY0zgVsXx95zY1 7rQHFTB2/XUgFY4yt6JEZAzfHX2pM5UPIOGWAt6xTnnn1Pk9D442B1WNPz96blSuGrhX 8/+qgz4zrZKHgtFAhngGp8W2i8Fthh8R+j6qE= MIME-Version: 1.0 Received: by 10.216.174.69 with SMTP id w47mr1007024wel.41.1299182083036; Thu, 03 Mar 2011 11:54:43 -0800 (PST) Received: by 10.216.240.68 with HTTP; Thu, 3 Mar 2011 11:54:42 -0800 (PST) In-Reply-To: References: Date: Thu, 3 Mar 2011 14:54:42 -0500 Message-ID: Subject: Re: maxextents From: Igor Neyman To: Thomas.Mercadante@labor.ny.gov Cc: "pdba1966@hotmail.com" , "oracle-l@freelists.org" Content-Type: multipart/alternative; boundary=001485f1e28a8ef74d049d996655 X-archive-position: 34822 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: igor.neyman@gmail.com Precedence: normal Reply-To: igor.neyman@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --001485f1e28a8ef74d049d996655 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable >"datafiles that are currently larger than their maxtent size" Confusion comes from the fact that PD mixes segment storage parameter (MAXEXTENTS) with datafile AUTOEXTEND option. Regards, Igor Neyman On Thu, Mar 3, 2011 at 2:43 PM, Mercadante, Thomas F (LABOR) < Thomas.Mercadante@labor.ny.gov> wrote: > PD, > > > Well I=92m confused about your question. > > > For a physical data file, you can set the maximum file size to a specific > size. > > You can also set the increment for the file that tells Oracle how much to > grow the file by if it runs out of room. > > > > So if a file is 100M and you tell Oracle to increment it by 50M up to 300= M > and a table is growing in that tablespace/file, and you reach the 100M us= age > point, Oracle will allocate another 50M to the physical file growing it t= o > 150M. > > This can happen a couple of times until the file reaches 300M. Oracle wi= ll > then not automatically grow the file any more. > > > > Does this answer your question? > > > Tom > > > > > > *From:* oracle-l-bounce@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *P D > *Sent:* Thursday, March 03, 2011 2:20 PM > *To:* oracle-l@freelists.org > *Subject:* RE: maxextents > > > > FYI - Blocksize=3D8192. Using auto allocate versus uniform. > > > > ------------------------------ > > From: pdba1966@hotmail.com > To: oracle-l@freelists.org > Subject: maxextents > Date: Thu, 3 Mar 2011 13:34:58 -0500 > > I am still confused by maxextents on a datafile and the more documentatio= n > and websites that I read the more confused that I get. > > > > If I have autoextend ON with NEXT set to 16384K then I understand that ea= ch > time it has to extend it will extend in 16384K chunks. > > > > However, does maxsize value mean it will continue to allocate in those > 16384K chunks until the total of those chunks reaches the size identified= by > maxsize? It doesn=92t mean that maxextent is the total size the datafil= e can > ever be (correct?) because I have some datafiles that are currently large= r > than their maxtent size... > > > > If you have NEXT set to 16384K, is there a recommendation of what size > maxextents should be or is it just whatever you want to put it at? For > example, does it need to be a multiple of block size or next extent, etc. > > > > When I use OEM and try and set Maximum Size to Unlimited and hit apply, i= t > doesn=92t show up with the Unlimited bullet highlighted. Instead it sho= ws up > as Value=3D32767MB. Why is that? Is 32GB the largest a datafile is ev= er > supposed to be? > > > > This is 11.1.0.7 on RHEL5. > --001485f1e28a8ef74d049d996655 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable >"datafiles that are currently larger than their maxtent size= "

Confusion comes from the fact that PD mixes segment st= orage parameter (MAXEXTENTS) with datafile AUTOEXTEND option.

Regard= s,
Igor Neyman

On Thu, Mar 3, 2011 at 2:43 P= M, Mercadante, Thomas F (LABOR) <Thomas.Mercadante@labor.ny.gov> = wrote:

PD,


Well I=92m confused about your question.


For = a physical data file, you can set the maximum file size to a specific size.=

You can also set the increment for the file that tells Oracle how muc= h to grow the file by if it runs out of room.

=A0

So if a file is 100M and you tell Oracle to increment it by 50M up to 30= 0M and a table is growing in that tablespace/file, and you reach the 100M u= sage point, Oracle will allocate another 50M to the physical file growing i= t to 150M.

This can happen a couple of times until the file reaches 300M.=A0 Ora= cle will then not automatically grow the file any more.

=A0

Does this answer your question?


Tom

=A0

=A0

From:= oracle-l-bounce@freelists.org [mailto:oracle-l-bounce= @freelists.org] On Behalf Of P D
Sent: Thursday, March 03, 2011 2:20 PM
To: oracle-l@freelists.org
= Subject: RE: maxextents

=A0

FYI -=A0Blocksize= =3D8192.=A0=A0=A0=A0 Using auto allocate versus uniform.
=A0
=A0
= =A0

From: pdba1966@hotmail.com
To: oracle-l@freelists.org
Subject: maxextents
Date: Thu, 3 Mar 2011 13:34:58 -0500

I am still confused by maxextents on a datafile and= the more documentation and websites that I read the more confused that I g= et.

=A0

If I have autoextend ON with NEXT set to 16384K the= n I understand that each time it has to extend it will extend in 16384K chu= nks.=A0=A0

=A0

However, does=A0maxsize value=A0mean it will contin= ue to allocate in those 16384K chunks until the total of those chunks reach= es the size identified by maxsize?=A0=A0 It doesn=92t mean that maxextent i= s the total size the datafile can ever be (correct?)=A0because I have some = datafiles that are currently larger than their maxtent size...

=A0

If you have NEXT set to 16384K, is there a recommen= dation of what size maxextents should be or is it just whatever you want to= put it at?=A0=A0=A0 For example, does it need to be a multiple of block si= ze or next extent, etc.

=A0

When I use OEM and try and set Maximum Size to Unli= mited and hit apply, it doesn=92t show up with the Unlimited bullet highlig= hted.=A0=A0 Instead it shows up as Value=3D32767MB.=A0=A0 Why is that?=A0= =A0 Is 32GB the largest a datafile is ever supposed to be?

=A0

This is 11.1.0.7 on RHEL5.


--001485f1e28a8ef74d049d996655-- -- http://www.freelists.org/webpage/oracle-l