RE: Script for most active tables

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Thu, 26 Oct 2000 13:42:01 -0400
Message-Id: <10661.120314@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_01C03F74.0BC14E20
Content-Type: text/plain;

charset="iso-8859-1"

You can use view dba_tab_modifications to get the number of inserts, updates and deletes for the table if you have alter table <table_name> monitoring. For selects you will need to use auditing.

Alex Hillman

-----Original Message-----
From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com] Sent: Wednesday, October 25, 2000 6:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: Script for most active tables

I think utlbstat/utlestat only tell you what tablespace/datafile is active... unless your whole table is in that particular datafile, or else I don't think bstat/estat will tell you much.

Winnie

"Koivu, Lisa" <lkoivu_at_qode.com>@fatcity.com on 10/25/2000 02:32:21 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Doesn't utlbstat/utlestat tell you what you need to know?

-----Original Message-----
Sent: Wednesday, October 25, 2000 3:52 PM To: Multiple recipients of list ORACLE-L

Does anyone have a sql script to share that shows table activity. I'm preparing to rebuild an instance and want to furthur balance the load by moving hot tables into new tablespaces.

TIA
...JIM...

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

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




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

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_01C03F74.0BC14E20
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: Script for most active tables</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>You can use view dba_tab_modifications to get the =
number of inserts, updates and deletes for the table if you have alter =
table &lt;table_name&gt; monitoring. For selects you will need to use =
auditing.</FONT></P>

<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Winnie_Liu_at_infonet.com [<A =
HREF=3D"mailto:Winnie_Liu_at_infonet.com">mailto:Winnie_Liu_at_infonet.com</A>=
]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, October 25, 2000 6:36 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Script for most active tables</FONT>
</P>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>I think utlbstat/utlestat only tell you what =
tablespace/datafile is</FONT>
<BR><FONT SIZE=3D2>active... unless your whole table is in that =
particular datafile, or else I</FONT>
<BR><FONT SIZE=3D2>don't think bstat/estat will tell you much.</FONT>
</P>

<P><FONT SIZE=3D2>Winnie</FONT>
</P>
<BR>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>&quot;Koivu, Lisa&quot; =
&lt;lkoivu_at_qode.com&gt;@fatcity.com on 10/25/2000 02:32:21 PM</FONT>
</P>

<P><FONT SIZE=3D2>Please respond to ORACLE-L_at_fatcity.com</FONT>
</P>

<P><FONT SIZE=3D2>Sent by:&nbsp; root_at_fatcity.com</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>To:&nbsp;&nbsp; Multiple recipients of list ORACLE-L =
&lt;ORACLE-L_at_fatcity.com&gt;</FONT>
<BR><FONT SIZE=3D2>cc:</FONT>
</P>
<BR>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>Doesn't utlbstat/utlestat tell you what you need to =
know?</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, October 25, 2000 3:52 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>

<P><FONT SIZE=3D2>Does anyone have a sql script to share that shows =
table activity.</FONT>
<BR><FONT SIZE=3D2>I'm preparing to rebuild an instance and want to =
furthur balance the load</FONT>
<BR><FONT SIZE=3D2>by moving hot tables into new tablespaces.</FONT>
</P>

<P><FONT SIZE=3D2>TIA</FONT>
<BR><FONT SIZE=3D2>...JIM...</FONT>
</P>

<P><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Author: James Howerton</FONT>
<BR><FONT SIZE=3D2>=A0 INET: jhowerton_at_uabmc.edu</FONT>
</P>

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


(like subscribing).</FONT>

</P>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: </FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Winnie_Liu_at_infonet.com</FONT>
</P>

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

Received on Thu Oct 26 2000 - 12:42:01 CDT