Re: analyze index

Just to clarify ....

"I am sure i looked at v$session-wait ( p1 and p2 ) pointed to table segments." -- when i say this i am referring to the old post.

"Oradba Linux" <techiey2k3_at_comcast.net> wrote in message news:geudnaZJFbjxRGfcRVn-qw_at_comcast.com...
> 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 - 20:38:13 CST