Another option:

EXEC DBMS_UTILITY.ANALYZE_SCHEMA('<schema name>','<estimate or compute>');







"Deepak Nair "
<oracledba-ezmlmshield-x82120758.[Email address protected]
05/31/2006 03:45 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: analyze index






Begin
For i in (SELECT index_name FROM dba_indexes WHERE
tablespace_name=<tablespace_name>) loop
execute immediate 'analyze index <schema>.'||i.index_name||' validate
structure';

end loop;
end;

Deepak
-----Original Message-----
From: Katz Gil
[mailto:oracledba-ezmlmshield-x3963433.[Email address protected]
Sent: Wednesday, May 31, 2006 4:16 AM
To: LazyDBA Discussion
Subject: analyze index

Hi

I want to analyze all the indexes in my schema

I know that the sql statement to get the indexes list is

SELECT index_name FROM dba_indexes WHERE
tablespace_name=<tablespace_name>;

And to analyze index I have to

analyze index <schema>.<index_name> validate structure;

how do I combine the two?



Gil Katz

QA Engineer

AppSight J2EE Team

Identify Software Ltd.

UIN 1538854

Tel: +972 (3) 9101927

=================================================

= So Long, and Thanks for All the Fish
=

=================================================







--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html




Notice:
This message and any attachments are the property of Logan Aluminum Inc
and are intended solely for the named recipients or entity to whom this
message is addressed. If you have received this message in error please
inform the sender via e-mail and destroy the message. If you are not the
intended recipient you are not allowed to use, copy or disclose the
contents or attachments in whole or in part.

Oracle LazyDBA home page