runstats: some questions
We have Oracle 10.2.
The runstats option currently used in production is : 'FOR ALL INDEXED COLUMNS SIZE AUTO". Based on some research we found it was not the right option and we changed it to "FOR ALL COLUMNS SIZE AUTO" . Our runstats jobs started little longer than expected so I would like to check with you:
-Will the runstats job have any impact on the application performance? Means if my runstats runs beyond the maintenance window and if the application users were to process at the same time does it affect the users response time.
Are there any options that can be turned on so that the runstats can run passive? If so what are the options?
- Does Oracle provide a progressive "runstats" option? Means start runstats to a point on one day, pause at some point and resume it from the point where left.
TIA