Reading descriptions of the effects of Autoallocate leads me to
think that Autoallocate is nothing more than PCTINCREASE redux--a
little less crude, but still no way to manage your space.
Paul Baumgartel
- sundeep maini <sundeep_maini_at_yahoo.com> wrote:
> Dennis,
>
> I mentioned Autoallocate and not autoextend. I have
> been using LMTs for over a year now but only with
> UNIFORM extent sizes. I am not sure if I am ready to
> handover space management to Oracle (via Autoallocate
> which is being foisted upon me as a panecea of all
> ills) least I have evaluated the pros and cons. The
> stuff in Manual and technet I have reveiwed so far
> doesn't give you enough information like how much
> space is wated in Autoallocate vs Uniform extent
> sizes. How does Oracle decide to allocate an extent
> for an Insert or an Update in Autoallocate option and
> how does it decide on the extent size?
>
> So far I have looked at SQLRef, Concepts manual and
> technet. Any other pointers?
>
> TIA
> Sundeep
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: treegarden_at_yahoo.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).
Received on Tue Mar 26 2002 - 15:36:49 CST
