Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Auto task - Gather Stats.How do Oracle knows which DB objects to analyze ?

User_3ZQRHApr 21 2015 — edited Apr 21 2015

Hi,

Do oracle has any specific criteria while identifying which Oracle DB objects needs to be analyze as part of Gather Stats ( included as "auto task") ?

Does it uses information from DBA_TAB_MODIFICATIONS to find any fixed % of change like 10% or so or it analyzes all objects ?

This post has been answered by John Stegeman on Apr 21 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2015

Added on Apr 21 2015

#general-database-discussions

5 comments

317 views