Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Very High BLKS_GETS_PER_ACCESS, Clustering Factor?
Post the query/ies please that are causing
"SAP BASIS Consultant" <basis_consultant_at_hotmail.com> wrote in message
news:dd2036f3.0305260737.524b6331_at_posting.google.com...
> Hi,
>
> On a v8.1.5 (AIX) system, there are some indexes, about 40MB
> or 50MB in size, for which INDEX_STATS (After analysis) shows
> the following:
>
> PCT_USED: 90% (PCTFREE is 10%)
> LF_ROWS: 225000 (Or some other very large number)
> DEL_LF_ROWS: 0
> HEIGHT: 3
> BLKS_GETS_PER_ACCESS: 241 (542 in another and 5749 in another!).
>
> I rebuilt one of them, reanalyzed it, and the numbers are the same.
>
> Aside from BLKS_GETS_PER_ACCESS, the index seems in very good shape.
>
> However, BLKS_GETS_PER_ACCESS is very poor. Is this a case of
> very poor clustering (In which I cannot do much aside from
> reorganizing the table), or should I look into somehing else?
>
>
>
> Thanks in Advance,
> DF
Received on Mon May 26 2003 - 12:10:23 CDT