dtang_at_minn.net wrote:
>
> Hi:
>
> After reading several articles, I get an imprsssion that the fewer
> extents in a table's data segment, the better the performance would
> be. But I can't find this statement in any official document.
> So I want to ask the experienced DBA about the relation between the
> size of extent and the performance.
>
> Any input will highly be appreciated. Please e-mail me at
> dtang_at_minn.net
>
> Thanks ahead
>
> Dong Tang
>
> Dong Tang
The book Oracle DBA Handbook 7.3 Edition by Oracle Press covers this
issue. Page 258 states "How the database actually stores data has an
effect on the performance of queries. If the data is fragmented into
multiple extents, then resolving a query may cause the database to look
in several physical locations for related rows....."
Received on Thu Sep 04 1997 - 00:00:00 CDT
