Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Segment Fragmentation and Performance
I am a new Oracle DBA and would like to solicit opinions concerning the
affect
read
that too
I read a
disputes that
environment, because
small requests, and services
diskhead is going to be moving all
full-table scans would be affected in the first
that the disk controller wouldn't be interrupted
completing that scan. So while it can be argued that it's
confine a segment to relatively few extents, there's no reason
with 50 extents shouldn't perform about as well as a segment in
extent.
seem to be
rebuild a
in
of row
fragmentation has
row migration that did
there have a bone to pick with this stance? I am curious
focus my attention, primarily on minimal extents, or on fine tuning
pctfree attributes, and whether I should avoid wasting disk space assuring
that a segment remains in one extent, in favor of increasing the pctfree
value
segment
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 18 1998 - 16:52:45 CDT