RE: 8.1.7 LMTs Autoallocate vs Uniform Extents

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 26 Mar 2002 11:43:55 -0800
Message-ID: <F001.00433EEC.20020326114355@fatcity.com>

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). Received on Tue Mar 26 2002 - 13:43:55 CST