Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Optimize stats oracle 11g

Posted on 2011-02-28
3
Medium Priority
?
681 Views
Last Modified: 2012-05-11
Hello,

How can I optimize stats on oracle 11g?
Can I use dbms_gather_stats, please?

Thanks

bibi
0
Comment
Question by:bibi92
3 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 34996906
what do you mean by "optimize" stats?

You can and should gather statistics using the dbms_stats package.
11g should have a dbms_scheduler job already running to periodically collect stats.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34996916
Yes, you should use dbms_stats.

What stats are you wanting to gather?  Table, schema, index, ???  The choice is up to you.

Do you want to 'estimate' or not?  Again, up to you.

0
 

Author Closing Comment

by:bibi92
ID: 34997123
Thanks bibi
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question