thanks for all the responses to such a basic question.
----- Original Message -----
From: "Chip" <ocp-dba_at_earthlink.net>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Saturday, March 22, 2003 6:03 AM
Subject: Re: Locally Managed Tablespaces
> 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).
> >>
> >>
> >>
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
> >http://platinum.yahoo.com
> >
> >
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chip
> INET: ocp-dba_at_earthlink.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
Received on Sat Mar 22 2003 - 06:29:50 CST
