Statistics management is probably a topic all by itself for large systems.
The larger the system, the more critical the statistics, but the smaller a
window you have. Enter "monitoring". This is my approach - I wrote a PL/SQL
package to manage this:
- switch all objects of interest to monitoring
1) Oracle is bug free. If not bug free, it is, at least, unbreakable.
That means that nothing wrong will happen to you as long as you don't
have users or data. They are the problem.
2) Direct load doesn't generate statistics, even if monitoring
attribute is set. Direct load is built for s
Dennis,
First, #2 since it is a shorter answer... I don't know, but I just saw
another resonder say it did not. That's good to know, I haven't
previously taken that into account.
Personally, I like the monitor/gather stale feature. I have heard,
some on this list, some on metalink of bugs where t
Title: RE: Question On Statistics Gathering
1. not much experience
2. yes it will, but in 8i the rate at which the stats were updated in the DD was *slow*, in 9i it is on demand or 5 minutes I think.
Raj
Dennis,
There has been a substantial amount of discussion on this subject in the past,
you might want to go look at the archives. But to directly answer your questions:
1) I'm not having a problem with it (8.1.7.4)
2) NO.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8
