Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Extents and Segment space management
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
![]() |
![]() |