so we are going back to the Oracle specified maximum extents for a
particular blocksize?
>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Fragmentation & Locally Managed Tablespaces
>Date: Thu, 28 Jun 2001 00:15:50 -0800
>
>VIVEK_SHARMA wrote:
> >
> > Is Fragmentation of Objects meaningless in Locally managed Tablespaces
> > Assuming EXTENTS is 3,000 for Some of the Objects
> >
> > Or Do the Objects need to be DE-Fragmented using exp/imp ?
> >
>
>Vivek,
>
>funny, I was just looking into this tonight.
>
>what is your block size?
>
>I would recommend a quick visit to our friend Steve Adams site:
>
>http://www.ixora.com.au/tips/creation/extents.htm
>
>"For this reason, we recommend that the number of extents per segment in
>locally managed tablespaces be limited to the number of rows that can be
>accommodated in the extent map within the segment header block
>- that is, approximately (db_block_size / 16) - 7."
>
>for an 8 KB block size - that is 505 extents per segment.
>
>Those objects would be good candidates to move to a different (new?)
>tablespace with a larger (uniform) extent size.
>
>Paul
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Paul Drake
> 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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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).
