RE: Size of segment

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Mon, 29 Apr 2002 05:13:22 -0800
Message-ID: <F001.00451B21.20020429051322@fatcity.com>

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: Shreepad.Vaidya_at_alltel.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: Ganesh Raja
  INET: ganesh_at_gtfs-gulf.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 Mon Apr 29 2002 - 08:13:22 CDT