If Next Extent Sizing is NON-Uniform for an LMT , will
the Larger Number of Extents cause Fragmentation & Performance Degradation ?
If so What Number of Extents may be Considered as a
Candidate for DE-Fragmentation ?
NOTE - We have been Manually Specifying the Size
of the NEXT_EXTENT of Objects in LMTs by Converting ALLOCATION_TYPE
(sys.dba_tablespaces) from "SYSTEM" to "USER" for respective Tablespaces
to Check Growth to Larger Numbers of Extents
100-200 Extents we Consider as a Candidate for
DE-Fragmentation using exp/imp OR ALTER TABLE/INDEX ... MOVE with
Bigger Extent Sizes
Oracle 8.1.7
|
Title: RE: datafile sizing question
- RE: datafile sizing question Jared . Still
- RE: datafile sizing question Rachel Carmichael
- RE: datafile sizing question VIVEK_SHARMA
- RE: datafile sizing question Rachel Carmichael
- RE: datafile sizing question Jamadagni, Rajendra
- Re: datafile sizing question Tim Gorman
- Re: datafile sizing question Tim Gorman
- RE: datafile sizing question DENNIS WILLIAMS
- RE: datafile sizing question Rachel Carmichael
- RE: datafile sizing question Jamadagni, Rajendra
- Re: datafile sizing question VIVEK_SHARMA
- Re: datafile sizing question Tim Gorman