Re: Any Final Verdict on Nr. of Extents?

Reza wrote:
>
> 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

http://www.vampired.net/articles/files/stopfrag.zip

I don't agree with everything it says, but basically I've never seen any problems with anything up to 500 extents - after that, its not extents I'm worried about - its that my planning was so wrong that I had it in the wrong (locally managed) tablespace!

hth
connor

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."