Re: Statspack for RAC

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 05 Feb 2004 22:04:26 +0100
Message-ID: <hsb520dajm6j9353ba9sg5h13rlkgl6d82@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.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Feb 05 2004 - 15:04:26 CST