Re: system stats $ RAC

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 9 Aug 2004 17:55:17 +0300

> AUX_STAT$ does not have INST_ID in current versions. So there is no way
> to differentiate the workload patterns across the nodes in the cluster.
> So I would be little careful in using CPU costing in RAC environments.

What if you ran gather_system_stats on each node? Wouldn't it leave instance
specific stats in each instances SGA during runtime? (not talking about
storing stats in aux_stats$ here)

Tanel.


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: