Re: Any Final Verdict on Nr. of Extents?

Hi Reza.

i remember seen an Oracle Whitepaper saying the number of extents (was for 7.3.4 Database) should not exceed 1000 (in tests performance was reduced at no. of 4000 extents and more). Sry, but i don't know, the exakt url of that whitepaper. Must be somewhere at oracle.com, suppose technet.oracle.com.

hth Stephan

Reza schrieb:

> 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

--
Mit freundlichen Gr$B|_(Ben

Stephan Langer,
QITS GmbH