RE: How to remove tablespace frgamentation

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Tue, 03 Apr 2001 16:46:05 -0700
Message-ID: <F001.002E0B1B.20010403164530@fatcity.com>

Seema,

Plan what is needed to be defragged.
Determine whether it is framentation on a block, extent, tablespace level.

Having many extents does not necessarily mean that you have fragmention. Incorrect extent sizing for segments could cause poor performance.

Try to create segments with uniform initial and next extent sizing per tablespace.

Use extent sizes that are multiple of db_block_size and db_file_multiblock_read_count parameters to perform efficient scans for multi block read operations.

Read through the attached whitepaper (SAFE) to give you an idea for eliminating fragmention.

You can rebuild indexes, change storage clause and move into different tablespaces.

What version of Oracle are you using?

IF you are on Oracle 8i you can move tables around to different tablespaces and also
change storage parameters (initial, next, pctincrease, ...) without import/ export.

Also visit http://www.ixora.com.au/tips/creation/extents.htm for ideas of planning extent sizes
for your segments.

Regards
Suhen

Hi Gurus
What is the best method to eliminate the tablespace fragmentation. except EXPORT/CREATE/IMPORT
Suggestion will be appriciated.
Thanks
-Seema

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seema Singh
INET: oracledbam_at_hotmail.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 Tue Apr 03 2001 - 18:46:05 CDT