Re: system_stats vs table_stats

Ana C. Dent wrote:

> How hard did you look & where did you look?
> I don't understand what you mean by "mutually exclusive".
> They do different things; which is why there are two different procedures.
>
> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_stats2.htm
>
>
> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_stats2.htm#1010477
>
>
> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_stats2.htm#1003993
>
>

Thank you for the links. While I wasn't overly clear on the differences before, what led to more confusion what the fact that both use the system_statistics table (optionally). So, if I've interpreted the doco correctly, then they can both use the system_stats table, import/export the different stats (identified by statid) as necessary, but won't override the other's settings?

Cheers,

Rick Received on Sat Dec 27 2003 - 12:58:15 CST