Re: analyze index

Johnathan

I did a small test on 9204 . I did not offline/online the tablespaces. I peeked at the trace file ( 10046 level 8), it did not touch the datafile that houses the table. I dont know under what circumstances should the analyze command look at the table segment. I am sure i looked at v$session-wait ( p1 and p2 ) pointed to table segments.
The command i issued was
analyze table < tabname> estimate statistics <sample> percent for all indexes ;

Thanks

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:ct50mu$min$1_at_sparta.btinternet.com...
>
> On a simple test case, and after putting the tablespaces
> offline then online, this did not happen on 9.2.0.6.
>
> Can you repeat the test, offlining the table's tablespace,
> or doing offline/online to both, and then run with
> 10046 at level 8 to see how many table blocks
> are referenced.
>
> What was the exact analyze command you used ?
>
> --
> Regards
>
> Jonathan Lewis
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/seminar.html
> Public Appearances - schedule updated Jan 21st 2005
>
>
>
>
>
>
> "Oradba Linux" <techiey2k3_at_comcast.net> wrote in message
> news:PqWdnWfBCLtfNGjcRVn-jQ_at_comcast.com...
> >
> > "DA Morgan" <damorgan_at_x.washington.edu> wrote in message
> > news:1106617227.881341_at_yasure...
> >> Oradba Linux wrote:
> >>
> >> > Why would analyze index command read table segments?
> >>
> >> Why would you think it does?
> >>
> >> One simple answer would be because it is reading ind$
> >> or obj$ but your question contains no context.
> >> --
> >> Daniel A. Morgan
> >> University of Washington
> >> damorgan_at_x.washington.edu
> >> (replace 'x' with 'u' to respond)
> >
> > Hello Daniel
> >
> > BTW I am on oracle 9204. I will say that before you ask me for it. I am
> > not
> > using dbms_stats to gather index stats for many reasons (bugs). When i
> > running analyze, the session was waiting for sequential read event. I
> > looked
> > at which segment it is trying to read
> > and it pointed to a table segment of the table for which i am analyzing
> > index for.
> >
> >
>
>
Received on Fri Jan 28 2005 - 18:32:02 CST