Re: Extents and Segment space management

From: DA Morgan <damorgan@xxxxxxxxx>
Date: Tue, 31 Jan 2006 09:06:18 -0800

DMina@xxxxxxxxx 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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.

References:
- Extents and Segment space management
  - From: DMina
- Re: Extents and Segment space management
  - From: sybrandb@xxxxxxxxx
- Re: Extents and Segment space management
  - From: DMina

Prev by Date: Re: RMAN problem
Next by Date: Re: Oracle error (Ora-15500)
Previous by thread: Re: Extents and Segment space management
Next by thread: Exclude MVs from full export
Index(es):
- Date
- Thread

Relevant Pages

Re: [Tux3] Tux3 report: Tux3 Git tree available
... I don't see any reason it is a problem for efficiency. ... filesystem extents tend to erode the argument for superpages. ...
(Linux-Kernel)
Re: [Tux3] Tux3 report: Tux3 Git tree available
... I don't see any reason it is a problem for efficiency. ... filesystem extents tend to erode the argument for superpages. ...
(Linux-Kernel)
Re: create dynamic variables
... do I see where there is any reason for users not to share the ... same pool of variables. ... Daniel A. Morgan ...
(comp.databases.oracle.server)
Re: Simple Oracle Query Taking Too Long
... DA Morgan wrote: ... of a single justification for either the 64K extents or a pctincrease ... And what would be wrong with 64kB extents? ...
(comp.databases.oracle.misc)