Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Extents and Segment space management

Re: Extents and Segment space management

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 31 Jan 2006 09:06:18 -0800
Message-ID: <1138727174.196346@jetspin.drizzle.com>


DMina_at_laiki.com wrote:
> First of all thank for the reply. I am trying to find some
> documentation related to the number of extents and how it affects the
> performance. For example i have a table which has 150 extents. Does it
> make any difference in performance if it is 10 extents?!

The number of extents for numbers such as you are discussing are irrelevant. When you get to tens or hundreds of thousands you may have reason for concern.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jan 31 2006 - 11:06:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US