Re: RE: Locally Managed Tablespaces

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).
Received on Fri Mar 21 2003 - 12:12:30 CST