RE: Varying plans on different nodes

Hi Gred

> The object stats would be the same, but it is possible
> for the system stats to be different. Have you validated
> they are consistent across nodes?

Could you please explain how to get two sets of system stats in one database at a given time? AFAIK this is not possible because system stats are stored in a single table (sys.aux_stats$) and in it there is no mention of instance ID.

Thank you,
Chris

--
http://www.freelists.org/webpage/oracle-l