!! Please do not post Off Topic to this List !!
Cherie - We have been using the autoextend feature for 6 months now and have
been really pleased with it. I am now studying the Oracle White Papers on
the locally managed and uniform extent philosophy and beginning to follow
that scheme. I would recommend studying it carefully. We have had a couple
of runaways that ate up a lot of disk, that is the most obvious downside.
The upside is obvious in the title of the Oracle white paper "Stop
Defragging and Start Living". Here are my procedures so far:
1. Use Oracle's new uniform extent recommendations to eliminate free extent
fragmentation. Since all extents are the same size, no fragmentation can
occur.
2. Use locally-managed tablespaces per Oracle's recommendation.
3. Set all extents in a tablespace to the same size. There are no unusable
small free extents, free space is usable by any segment, and administration
is minimized.
4. Use only 3 extent sizes: 128K, 4M, and 128M
5. All segments should have less than 1,024 extents. When a table approaches
1,024 extents, it should be moved to the next larger extent size tablespace.
6. Monitor archive log space.
7. Temporary and rollback tablespaces should be divided into 1,024 extents
for optimal performance.
8. Export the table before moving it.
9. Use the Oracle "alter table XXX move" command.
10. Use the Oracle "alter index XXX rebuild" command.
Let me know if you have any more questions, and please share your ideas.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
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).
