Optimize stats oracle 11g

Hello,

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

Thanks

bibi
bibi92Asked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
bibi92Author Commented:
Thanks bibi
0
All Courses

From novice to tech pro — start learning today.