Re: Statspack for RAC

From: dias <ydias_at_hotmail.com>
Date: 6 Feb 2004 11:55:30 -0800
Message-ID: <55a68b47.0402061155.1f2f2f85@posting.google.com>

Thanks,

I've checked the statspack.snap proc. To gather stats for IO, it uses v$filestat. In this view, there is no reference to instance_number !

This is the script of the view used to collect IO stats in statspack.snap. This view is owned by sys.

CREATE OR REPLACE VIEW STATS$V_$FILESTATXS ( TSNAME, FILENAME, PHYRDS, PHYWRTS, READTIM,
WRITETIM, SINGLEBLKRDS, PHYBLKRD, PHYBLKWRT,

SINGLEBLKRDTIM, WAIT_COUNT, TIME ) AS select ts.name      tsname


     , df.name	    filename

     , fs.phyrds

     , fs.phywrts

     , fs.readtim

     , fs.writetim

     , fs.singleblkrds

     , fs.phyblkrd

     , fs.phyblkwrt

     , fs.singleblkrdtim

     , fw.count     wait_count

     , fw.time      time

  from x$kcbfwait   fw


     , v$filestat   fs

     , v$tablespace ts

     , v$datafile   df

 where ts.ts#    = df.ts#

   and fs.file# = df.file#
   and fw.indx+1 = df.file#

Thanks

"DBA Infopower Support" <support_at_dbainfopower.com> wrote in message news:<A7CdnQ58M4lf3b7dRVn-gg_at_comcast.com>...

> Hello dais,
> 
>   Statspack records information on instance / session level. i.e. I/O
> statistics are separate per instance and you'd need to sum them up.
> 
> Regards,
> 
>    Support
>    DBA Infopower
>    http://www.dbainfopower.com
> 
> 
> "dias" <ydias_at_hotmail.com> wrote in message
> news:55a68b47.0402051257.2926dd80_at_posting.google.com...
> > 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

Received on Fri Feb 06 2004 - 13:55:30 CST