RE: Tracking buffer gets by tablespace

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Tue, 27 Jun 2000 18:44:31 -0300
Message-Id: <10541.110589@fatcity.com>

Hi,

Using v$bh and/or v$cache you can figure out the number of blocks that = are
being held and occupied by an object and from where. However estimating buffer gets is a measure of transactions. Because a block in the buffer could be held for longer or not depending on the concurrency and = activity of
the database.

Regards.

> -----Mensaje original-----
> De: Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca]
> Enviado el: Martes 27 de Junio de 2000 16:16
> Para: Multiple recipients of list ORACLE-L
> Asunto: Tracking buffer gets by tablespace

>=20

> Is there a way to do this?

>=20
> I can track disk reads and writes by tablespace (via v$filestat), but =
am
> having trouble figuring out how to associate buffer gets against
> individual
> tablespaces.

>=20

> Thanks.
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)

>=20


> Systems Admin & Operations | Admin. et Exploit. des syst=E8mes

> Technology Services        | Services technologiques

> Informatics Branch         | Direction de l'informatique=20

> Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

>=20

> E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

>=20

> --=20
> Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 27 2000 - 16:44:31 CDT