!! Please do not post Off Topic to this List !!
Prior to the advent of 8i, uniform extents had to be enforced through making
sure that every extent in a given tablespace was the same size by using
appropriate values in the storage clause in effect at the time of object
creation. The easiest method was to just set initial = next and pctincrease =
0 in the tablespace default storage clause and prohibit the use of these
particular parameters in individual object creation scripts. The DBA often had
to review all object creation scripts and remove/fix any offending parameters.
(When using Designer, I could run custom scripts against the API to do the
"cleanup" though.) LMTs and the ability to declaratively enforce "uniform
extents" eliminated this grunge work. Now we just have to decide which
tablespace is appropriate.
-Don Granaman
[OraSaurus - Honk if you remember UFI!]
PS: When others heard about this, they often replied "But SMON won't coalesce
free space if pctincrease=0 at the tablespace level!". My universal reply:
"Good! I don't want it to!"
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 7:50 AM
> !! Please do not post Off Topic to this List !!
>
>
> Don,
>
> Thanks for your comprehensive reply. Could you elaborate on how you
> enforce uniform extents through controlling the DDL?
> What do you mean by that?
>
> Thanks,
>
> Cherie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
