SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Tuning Expert Reports

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Tuning Expert Reports
Author Message
Melanie Ledford



Joined: 18 Sep 2002
Posts: 1

Post Tuning Expert Reports Reply with quote

I have run the tuning expert report and received a
list of objects that had outdated statistics in the
data dictionary. The suggestion in the report was
to run the ANALYZE command on these objects. I have
done that, but am still receiving the same suggestion
everytime that I re-run the report.

Any suggestions? Thanks!

Wed Sep 18, 2002 2:49 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Tuning Expert Reports Reply with quote

DB Tuning Expert compares statistics stored in the system catalog against physical object attributes and allocation.
For example, it compares number of blocks allocated to a table (as reported in dba_segments) against number of blocks found by the last ANALYZE command and written to some internal Oracle table that is seen via all_tables view.
If the difference is significant, DB Tuning Expert suggests to analyze such table.

You can verify the result yourself by querying dba_segments and all_tables for one of the found objects.

: I have run the tuning expert report and received a
: list of objects that had outdated statistics in the
: data dictionary. The suggestion in the report was
: to run the ANALYZE command on these objects. I have
: done that, but am still receiving the same suggestion
: everytime that I re-run the report.

: Any suggestions? Thanks!

Wed Sep 18, 2002 3:12 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.