RE: Varying plans on different nodes

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <greg@xxxxxxxxxxxxxxxxxx>
  • Date: Thu, 7 Jun 2007 07:39:03 +0200

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


Other related posts: