RE: CPU COSTING

I was talking about how it gets populated, or the processes involved in = calculating the numbers there. if the numbers are already in v$filestat, = why do I have to collect it?

Regards,

Waleed

-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal_at_yahoo.com] Sent: Friday, April 23, 2004 11:48 AM
To: oracle-l_at_freelists.org
Subject: RE: CPU COSTING

Waleed:

CPU Costing uses X$KCFIO (externalized by V$FILESTAT) to get the single block and multiblock read times. It also uses number of single block reads and number of multiblock reads in to consideration. It works at system level.

KG

• "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> wrote:
  > So the buffer cache has no impact on the stats.=3D20
  >=20
  > Was wondering how this system stats get calculated, it has to be =3D
  > collected by the individual sessions themselves and then all the =3D
  > collected numbers get summarized/correlated into one set of numbers =
  =3D
  > (system level).
  >=20
  > Waleed
  >=20

  ---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

  ---

  To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

  ---

  ---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

  ---

  To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

  ---