Home » RDBMS Server » Performance Tuning » INDEX ANALYZE (10g AIX)
INDEX ANALYZE [message #314007] Tue, 15 April 2008 08:50 Go to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
hello
i need please script that do for me analyze for all my index in schema.

thanks
Re: INDEX ANALYZE [message #314010 is a reply to message #314007] Tue, 15 April 2008 08:54 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
DBMS_STATS is already part of this Oracle release
Re: INDEX ANALYZE [message #314012 is a reply to message #314010] Tue, 15 April 2008 09:06 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
but if see the index i see BLEVEL HIGH AFTER DBMS_STATS
but if i run analyze index .... compute estimate
i see BLEVEL 2.

Re: INDEX ANALYZE [message #314014 is a reply to message #314007] Tue, 15 April 2008 09:12 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
so? the values are different.
which value is correct & how do you know it is correct answer?
Re: INDEX ANALYZE [message #314016 is a reply to message #314007] Tue, 15 April 2008 09:23 Go to previous messageGo to next message
lioracle
Messages: 68
Registered: February 2008
Location: Israel
Member
really?
i didnt know.

to who to believe
for dbms_Stats or analze index ?
Re: INDEX ANALYZE [message #314019 is a reply to message #314016] Tue, 15 April 2008 09:47 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It's not that I don't believe you, but could you show us some evidence (cut and paste from SQL*Plus) that shows the Blevel changing for an index as the result of an Analyze/Dbms_Stats command.
(And I don't mean changing from null to a value).

What version of Oracle are you using?
Previous Topic: bulk collect help in production
Next Topic: Performance discrepancies
Goto Forum:
  


Current Time: Wed Dec 07 14:23:31 CST 2016

Total time taken to generate the page: 0.16082 seconds