Re: Automanagement of extent sizing

!! 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" <ORACLE-L_at_fatcity.com> 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: granaman_at_home.com

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: 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).