Hi All,
I have a few questions on this,
- In your project do you collect statistics on sys or system account?
We have the practice of not collecting schema statistics on sys and
system accounts... probably because there have been some reports of
systems suffering from performance issues after collecting statistics
on sys.
- Recommended way to go about collecting schema statistics...in oracle
9i with monitoring option and gather stale/auto, it is possible to
collect statistics only on tables that have significant changes. Do you
collect statistics regularly on time based event like at daily or
weekly interval or do you collect statistics based on dml activities?
(i.e. By turning on the monitoring option etc) In the later case have
you experienced any problems related to statistics?
With thanks,
Nirav
Received on Wed Jun 14 2006 - 06:08:07 CDT