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
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Sundeep - Start by reading the classic paper "How to
> Stop Defragmenting and
> Start Living" at this link:
>
http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm
>
> Actually, autoallocate and uniform extents work very
> well together. But you
> need to understand the concepts behind them first.
> And make sure your
> application doesn't use up all your disk space if
> you autoallocate.
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Tuesday, March 26, 2002 12:54 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Can someone point me to good reading material on
> this
> subject. Is one better than the other for
> performance
> and manageability?
>
> Syntactically the autoallocate is shorter and seems
> to
> be more hands off (does that mean worry free also?).
>
>
>
> TIA
>
>
> =====
>
> Sundeep Maini
> Consultant
> Currently on Assignement at Marshfield Clinic WI
> mainis_at_mfldclin.edu
>
> __________________________________________________
> 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: sundeep maini
> INET: sundeep_maini_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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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).
Sundeep Maini
Consultant
Currently on Assignement at Marshfield Clinic WI
mainis_at_mfldclin.edu
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: sundeep maini
INET: sundeep_maini_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 - 14:45:43 CST
