This content has been marked as final. Show 2 replies
When will and who (which job) will ( only updated when statistics are collected) collect the statistics? (Once in when DB is created? or once in a day? or once in every 12 hours? or do we need to set something to do this?)
The version of oracle is 11g release2 (I assume 10g release2 should have same)
You, or your DBA, needs to create a job to collect statistics periodically. How often you collect them, what tables/indexes you collect them on and the type of statistics you collect depend on your particular needs.
Many organizations have a job that runs nightly and/or weekly to gather statistics to include that days activities.
For batch processing a full set of stats if often generated just prior to large batch runs.