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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
