Re: Question on Extents

Hi,

it isn't bad. Oracle reads Oracle blocks, not extents. And if you have parrallel query option you must have multiple extents, because Oracle splits tables (indexes, cluster ...) in extents for multiple query slaves.
Of course, a very big number (over 100) of extents will be bad, Oracle must manage them in data dictonary.

Torsten

Mike wrote:
>
> Would someone settle a question for me?
>
> Is it good or bad to have multiple table extents (say 30) or not?
>
> I have read, that multiple extents (anything over 4) is bad just for the fact
> that you have them, now I have been told by a DBA that it's not bad in and of
> itself... I can't see the logic in that one - but maybe I'm missing something -
> can anyone shed some light on the subject, and maybe some pointers to reference
> material on the matter...
>
> Thanks...
>
> A novice Oracle DBA
> --
> Please remove ".nojunkmail" from my
> address before replying............
Received on Thu Feb 25 1999 - 05:52:41 CST