Received: (qmail 17807 invoked from network); 3 Mar 2011 13:56:27 -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:02 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EA4DDDAA0C6; Thu, 3 Mar 2011 14:54:24 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1299182064; bh=ZDW/byDrUBR+kzIwngI0doBE4OoRjEV1a2/ORKUH H7I=; h=From:To:Subject:Date:Message-ID:References:In-Reply-To: Content-Type:MIME-Version:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=XRU3v2uTtc8gIFgi7Yd/qxKWWAVRTXgrTTVDj+Ooruc9l0lyBy SeFl6HI4OUEA8XPXsod48SqFp2xzey7U7Y3yNiJ7uuj9170dG79M96A6mz/UPl5mhYo wPXqJlPGC8sHUq3bsNv4roZXsFXc0/GIgrr8xUaz6vTK9MRXfm8ESc= 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 773OuJE9JMdc; Thu, 3 Mar 2011 14:54:24 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7FB5DDA8F38; Thu, 3 Mar 2011 14:53:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 03 Mar 2011 14:52:59 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 58300DAAF26 for ; Thu, 3 Mar 2011 14:52:59 -0500 (EST) 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 vcs4p3l30vYK for ; Thu, 3 Mar 2011 14:52:59 -0500 (EST) Received: from webmail3.micros.com (usmail2k10cas2.micros.com [63.163.61.227]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 642ECDAAE5D for ; Thu, 3 Mar 2011 14:52:56 -0500 (EST) Received: from USMAIL2K10-01.us.Micros.int ([::1]) by USMAIL2K10CAS2.us.micros.int ([::1]) with mapi id 14.01.0270.001; Thu, 3 Mar 2011 14:52:52 -0500 From: "Uzzell, Stephan" To: "'Thomas.Mercadante@labor.ny.gov'" , "pdba1966@hotmail.com" , "oracle-l@freelists.org" Subject: RE: maxextents Thread-Topic: maxextents Date: Thu, 3 Mar 2011 19:52:51 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [65.173.246.250] Content-Type: multipart/alternative; boundary="_000_DF78EADE484D37419A53F5C898629DB7017B92USMAIL2K1001usmic_" MIME-Version: 1.0 X-archive-position: 34821 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: SUzzell@MICROS.COM Precedence: normal Reply-To: SUzzell@MICROS.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 --_000_DF78EADE484D37419A53F5C898629DB7017B92USMAIL2K1001usmic_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable PD, Say you add a datafile: alter tablespace blah add datafile 'd:\oracle\oradata\blah02.dbf' size 100m= autoextend on next 50m maxsize 300m; -- just to match Tom's numbers At this point the datafile is 100M, maxsize is 300M. Then you decide that's not large enough: Alter datafile 'd:\oracle\oradata\blah02.dbf' resize 500m; Presto - you have a datafile whose size exceeds the maxsize. Does that help? Stephan Uzzell From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Mercadante, Thomas F (LABOR) Sent: Thursday, 03 March, 2011 14:44 To: pdba1966@hotmail.com; oracle-l@freelists.org Subject: RE: maxextents PD, Well I'm confused about your question. For a physical data file, you can set the maximum file size to a specific s= ize. You can also set the increment for the file that tells Oracle how much to g= row 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 300M = and a table is growing in that tablespace/file, and you reach the 100M usag= e 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 will= 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 documentation = 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 each= time it has to extend it will extend in 16384K chunks. However, does maxsize value mean it will continue to allocate in those 1638= 4K chunks until the total of those chunks reaches the size identified by ma= xsize? It doesn't mean that maxextent is the total size the datafile can = ever be (correct?) because I have some datafiles that are currently larger = than their maxtent size... If you have NEXT set to 16384K, is there a recommendation of what size maxe= xtents should be or is it just whatever you want to put it at? For examp= le, 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, it = doesn't show up with the Unlimited bullet highlighted. Instead it shows u= p 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. --_000_DF78EADE484D37419A53F5C898629DB7017B92USMAIL2K1001usmic_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

PD,

 <= /p>

Say you add a datafile:

 <= /p>

alter tablespace blah add= datafile ‘d:\oracle\oradata\blah02.dbf’ size 100m autoextend o= n next 50m maxsize 300m; -- just to match Tom’s numbers

 <= /p>

At this point the datafil= e is 100M, maxsize is 300M.

 <= /p>

Then you decide that̵= 7;s not large enough:

 <= /p>

Alter datafile ‘d:\= oracle\oradata\blah02.dbf’ resize 500m;

 <= /p>

Presto – you have a= datafile whose size exceeds the maxsize.

 <= /p>

Does that help?

 <= /p>

Stephan Uzzell

 <= /p>

From: oracle-l= -bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mercadante, Thomas F (LABOR)
Sent: Thursday, 03 March, 2011 14:44
To: pdba1966@hotmail.com; oracle-l@freelists.org
Subject: RE: maxextents

 

PD,


Well I’m confused about your question.


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

You can also set the incr= ement for the file that tells Oracle how much to grow the file by if it run= s out of room.

 <= /p>

So if a file is 100M and = you tell Oracle to increment it by 50M up to 300M and a table is growing in= that tablespace/file, and you reach the 100M usage point, Oracle will allocate another 50M to the physical file growing it to 150M.<= o:p>

This can happen a couple = of times until the file reaches 300M.  Oracle will then not automatica= lly grow the file any more.

 <= /p>

Does this answer your que= stion?


Tom

 <= /p>

 <= /p>

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: pdb= a1966@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 get.

 

If I have autoextend ON with NEXT set to 16384K then I u= nderstand that each time it has to extend it will extend in 16384K chunks.&= nbsp; 

 

However, does maxsize value mean it will conti= nue to allocate in those 16384K chunks until the total of those chunks reac= hes the size identified by maxsize?   It doesn’t mean that = maxextent is the total size the datafile can ever be (correct?) because I have = some datafiles that are currently larger than their maxtent size...<= span style=3D"font-size:10.0pt;font-family:"Tahoma","sans-se= rif"">

 

If you have NEXT set to 16384K, is there a recommendatio= n 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, it doesn’t show up with the Unlimited bullet highligh= ted.   Instead it shows up as Value=3D32767MB.   Why is= that?   Is 32GB the largest a datafile is ever supposed to be?

 

This is 11.1.0.7 on RHEL5.=

--_000_DF78EADE484D37419A53F5C898629DB7017B92USMAIL2K1001usmic_-- -- http://www.freelists.org/webpage/oracle-l