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: [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).
defrag.pdf
