Physically No Extents, No Blocks are Contigous.. There is No Use in Bringing
the Entire Table 1 or 10 Extents. If you have Used PCTIncrease in your TBS
then Over Time Your Tables and Indexwes will be fragmented.
My Suggestion would be to give Uniform sized Extents and move the table and
Index into that tablespace.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
============================================
Live to learn... forget... and learn again.
============================================
-----Original Message-----
Sent: Monday, April 29, 2002 4:43 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have segments (Tables and indexes) which go into 500 MB -- 1 GB . I
intend to do a rebuild since they are fragmented.
Is it beneficial to have a single extent of 500 Mb or multiple extents are
ok ? (maybe 4 --5)
My contention is that so long as the extents are contiguous ( I could do a
rebuild) the number do not matter
so long as they are not too high.
Any suggestions ?
Thanks
shreepad
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ganesh Raja
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).
