Method R Discussion GroupMethod R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle. |
|
Discuss Method R products, techniques, and events. Ask new questions or post your own responses. |
As I understand the internal code used to collect the statistic information, there isn't really any more work being done at the ALL level as there is at TYPICAL. However Oracle seems to not use the information when the level is set to TYPICAL. I have always recommending having this set to ALL. It's a little more information and for the STAT lines it's critical because without it the time values will likely not add up correctly and that make performance analysis that much harder.
|
Powered by FogBugz