Re: Fragmentation & Locally Managed Tablespaces

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: paled_at_home.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).