Re: analyze index

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 25 Jan 2005 08:41:03 +0000 (UTC)
Message-ID: <ct50mu$min$1@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 Tue Jan 25 2005 - 02:41:03 CST