Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Any Final Verdict on Nr. of Extents?
"Reza" <reza_at_digital-dispatch.co.uk> wrote in message news:<999771696.4333.0.nnrp-09.d4f07ab4_at_news.demon.co.uk>...
> Hi guys
> I've been having a hot debate with our new say DBAs, on effect of Number
> extents in an object like a table or index on performance.
> Basically I didnot agree to take a 7x24 system down for 6 hours to just
> reduce the number of extents on few huge tables and their indexes.
> I would personally believed few years ago that lower number of extents will
> be better performance and even remember arguing this with some Oracle Tutors
> in their lectures. Since then I have somehow revised my view due to working
> with few production databases, and also hearing more from other DBAs in
> favor of ineffectiveness of Nr. of extents in Performance.
>
> Anyway I would appreciate if anyone could direct me to a definitive article
> or somehow share their view on this so I can supprt my argument better or at
> list to revise it again.
> I think somehow fragmentation problem might come to this argument as well,
> if the extents are not contiguse in the Objects table space. Any view on
> this aspect.
>
> May thanks for any help or feedback.
> Best Regards
> Reza Oskouie
Take a look at this:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:262215349296 Received on Thu Sep 06 2001 - 11:39:58 CDT