RE: How to find no of blocks

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Wed, 26 Jul 2000 14:40:03 -0400
Message-Id: <10570.113037@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF730.EE67E210
Content-Type: text/plain;

charset="iso-8859-1"

values of status are in lower case - 'cr', 'xcur'

Alex Hillman

-----Original Message-----
From: Trassens Christian [mailto:trassenc_at_TELEFONICA.COM.AR] Sent: Tuesday, July 25, 2000 5:19 PM
To: Multiple recipients of list ORACLE-L Subject: RE: How to find no of blocks

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.
>
> Thx
> Gautam
>

-- 
Author: Trassens Christian
  INET: trassenc_at_TELEFONICA.COM.AR

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).

------_=_NextPart_001_01BFF730.EE67E210
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: How to find no of blocks </TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>values of status are in lower case - 'cr', 'xcur'</FONT>
</P>

<P><FONT SIZE=2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Trassens Christian [<A HREF="mailto:trassenc_at_TELEFONICA.COM.AR">mailto:trassenc_at_TELEFONICA.COM.AR</A>]</FONT>
<BR><FONT SIZE=2>Sent: Tuesday, July 25, 2000 5:19 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: How to find no of blocks </FONT>
</P>
<BR>

<P><FONT SIZE=2>Try this:</FONT>
</P>

<P><FONT SIZE=2>select name, decode(status,'CR', 'Modified', 'XCUR', 'Not Modified',</FONT>
<BR><FONT SIZE=2>status)</FONT>
<BR><FONT SIZE=2>&quot;Status&quot;, count(*)</FONT>
<BR><FONT SIZE=2>&nbsp; from v$cache</FONT>
<BR><FONT SIZE=2>&nbsp;&nbsp; group by name, decode(status,'CR', 'Modified', 'XCUR', 'Not Modified',</FONT>
<BR><FONT SIZE=2>status</FONT>
<BR><FONT SIZE=2>)</FONT>
<BR><FONT SIZE=2>&nbsp;&nbsp; order by 3 desc</FONT>
<BR><FONT SIZE=2>/</FONT>
</P>

<P><FONT SIZE=2>REGARDS.</FONT>
</P>

<P><FONT SIZE=2>NOTE: If you have Oracle 7.3.X, you have to run catparr.sql from</FONT>
<BR><FONT SIZE=2>$ORACLE_HOME/rdbms/admin.</FONT>
</P>

<P><FONT SIZE=2>&gt; -----Mensaje original-----</FONT>
<BR><FONT SIZE=2>&gt; De:&nbsp;&nbsp; Gautam_Reddy_at_Dell.com [SMTP:Gautam_Reddy_at_Dell.com]</FONT>
<BR><FONT SIZE=2>&gt; Enviado el:&nbsp;&nbsp; Martes 25 de Julio de 2000 14:19</FONT>
<BR><FONT SIZE=2>&gt; Para: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>&gt; Asunto:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How to find no of blocks </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt; How to find how many blocks of an object are present in the DB Buffer area</FONT>
<BR><FONT SIZE=2>&gt; at a given time. </FONT>
<BR><FONT SIZE=2>&gt;&nbsp; </FONT>
<BR><FONT SIZE=2>&gt; Thx</FONT>
<BR><FONT SIZE=2>&gt; Gautam</FONT>
<BR><FONT SIZE=2>&gt;&nbsp; </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Trassens Christian</FONT>
<BR><FONT SIZE=2>&nbsp; INET: trassenc_at_TELEFONICA.COM.AR</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>

Received on Wed Jul 26 2000 - 13:40:03 CDT