Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Locally Managed Tablespaces

Re: Locally Managed Tablespaces

From: Chip <ocp-dba_at_earthlink.net>
Date: Sat, 22 Mar 2003 04:05:41 -0700
Message-Id: <24748.322787@fatcity.com>


The other pctincrease option that preserves a multiple of the extent size is 100.
Similiar to LMT autoallocate extent sizes always being a multiple of 64K.

Have Fun :)

Rachel Carmichael wrote:

>pctincrease=0 and set the storage parameters at the tablespace level
>and do NOT put storage parameters on the individual objects.
>
>you can "fake" the workings (without the bitmap!) of an LMT by doing
>that. Next extent=initial extent, pctincrease=0 will effectively
>allocate extents of equal sizes
>
>
>--- rgaffuri_at_cox.net wrote:
>
>
>>thanks in case I happen to work on a 7.3 database....
>>
>>what kind of pctincrease should I set? What about the other settings?
>>Just curious.
>>
>>Ryan
>>
>>
>>>From: "BALA,PRAKASH (HP-USA,ex1)" <prakash.bala_at_hp.com>
>>>Date: 2003/03/21 Fri PM 12:54:41 EST
>>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>>Subject: RE: Locally Managed Tablespaces
>>>
>>>Once you set to uniform extents, pctincrease will default to 0.
>>>
>>>Most Oracle gurus advise to just use uniform extents for all
>>>
>>>
>>situations.
>>
>>
>>>-----Original Message-----
>>>Sent: Friday, March 21, 2003 10:59
>>>To: Multiple recipients of list ORACLE-L
>>>
>>>
>>>This is probably pretty basic, so please keep in mind that Im a
>>>
>>>
>>developer
>>
>>
>>>and Im trying to pick up more of the DBA side.
>>>
>>>I am assuming that the preferred way to create a tablespace in 8i,
>>>
>>>
>>9i is as
>>
>>
>>>follows(this is out of OTN docs)
>>>
>>>CREATE TABLESPACE lmtbsb DATAFILE '/u02/oracle/data/lmtbsb01.dbf'
>>>
>>>
>>SIZE 50M
>>
>>
>>> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;
>>>
>>>
>>>When you use Uniform Extents you know longer have to worry about
>>>
>>>
>>tablespace
>>
>>
>>>fragmentation correct? You also do not need to worry
>>>
>>>
>>minimum,initial,and
>>
>>
>>>next extents correct?
>>>
>>>What are some rules of thumb for setting PCTINCREASE(there is
>>>
>>>
>>another PCT
>>
>>
>>>setting too right)? A DBA I used to work with said you should
>>>
>>>
>>almost always
>>
>>
>>>use zero for PCTINCREASE. Could someone please tell me why? The
>>>
>>>
>>default is
>>
>>
>>>like 40?
>>>
>>>Is there a time when I should not use Uniform Extents?
>>>
>>>Thanks... hope this isnt too basic.
>>>
>>>--
>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>>--
>>>Author: <rgaffuri_at_cox.net
>>> INET: rgaffuri_at_cox.net
>>>
>>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>>>San Diego, California -- Mailing list and web hosting
>>>
>>>
>>services
>>
>>
>>---------------------------------------------------------------------
>>
>>
>>>To REMOVE yourself from this mailing list, send an E-Mail message
>>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>>the message BODY, include a line containing: UNSUB ORACLE-L
>>>(or the name of mailing list you want to be removed from). You may
>>>also send the HELP command for other information (like
>>>
>>>
>>subscribing).
>>
>>
>>>--
>>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>>--
>>>Author: BALA,PRAKASH (HP-USA,ex1)
>>> INET: prakash.bala_at_hp.com
>>>
>>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>>>San Diego, California -- Mailing list and web hosting
>>>
>>>
>>services
>>
>>
>>---------------------------------------------------------------------
>>
>>
>>>To REMOVE yourself from this mailing list, send an E-Mail message
>>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>>the message BODY, include a line containing: UNSUB ORACLE-L
>>>(or the name of mailing list you want to be removed from). You may
>>>also send the HELP command for other information (like
>>>
>>>
>>subscribing).
>>
>>
>>>
>>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>--
>>Author: <rgaffuri_at_cox.net
>> INET: rgaffuri_at_cox.net
>>
>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>>San Diego, California -- Mailing list and web hosting services
>>---------------------------------------------------------------------
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from). You may
>>also send the HELP command for other information (like subscribing).
>>
>>
>>
>
>
Received on Sat Mar 22 2003 - 05:05:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US