RE: How to find no of blocks

From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR>
Date: Tue, 25 Jul 2000 17:09:50 -0300
Message-Id: <10569.112932@fatcity.com>

Try this:

select name, decode(status,'CR', 'Modified', 'XCUR', 'Not Modified', status)
"Status", count(*)
from v$cache
group by name, decode(status,'CR', 'Modified', 'XCUR', 'Not Modified', status
)

order by 3 desc
/

REGARDS. NOTE: If you have Oracle 7.3.X, you have to run catparr.sql from $ORACLE_HOME/rdbms/admin.

> -----Mensaje original-----
> De: Gautam_Reddy_at_Dell.com [SMTP:Gautam_Reddy_at_Dell.com]
> Enviado el: Martes 25 de Julio de 2000 14:19
> Para: Multiple recipients of list ORACLE-L
> Asunto: How to find no of blocks
>
> How to find how many blocks of an object are present in the DB Buffer area
> at a given time.
>
Received on Tue Jul 25 2000 - 15:09:50 CDT