Re: Statspack for RAC

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: 6 Feb 2004 17:58:10 -0800
Message-ID: <14a1f766.0402061758.c4dccaf@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<hsb520dajm6j9353ba9sg5h13rlkgl6d82_at_4ax.com>...
> On 5 Feb 2004 12:57:44 -0800, ydias_at_hotmail.com (dias) wrote:
>
> >Hi,
> >
> >In a Rac environment with 2 nodes, statspack snapshots must be taken
> >from each of the two instances or just from one isntance ?
> >
> >For example, the IO stats reported in the stats for the first instance
> >inculde the IO for the second one or just the IO for this instance ?
> >
> >Thanks
>
> If you do a describe on stats$snapshot and other tables, you will see
> every table includes an instance_id.
> So I guess now the answer to your questions is obvious.

Well, if you're suggesting what I think you're suggesting, you're wrong. Statspack is not instance-aware, and has to be run from each node separately, just like the OP thought. You cannot collect cluster-wide statistics with Statspack, and a given Statspack report will only show the statistics for the instance it was collected from.

HJR Received on Fri Feb 06 2004 - 19:58:10 CST