Any Final Verdict on Nr. of Extents?

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 Received on Thu Sep 06 2001 - 05:18:12 CDT