RE: Script for most active tables

From: <Winnie_Liu_at_infonet.com>
Date: Wed, 25 Oct 2000 14:33:15 -0700
Message-Id: <10660.120233@fatcity.com>

I think utlbstat/utlestat only tell you what tablespace/datafile is active... unless your whole table is in that particular datafile, or el= se 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:

Subject: RE: Script for most active tables

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

-----Original Message-----

From: James Howerton [mailto:jhowerton_at_uabmc.edu] Sent: Wednesday, October 25, 2000 3:52 PM To: Multiple recipients of list ORACLE-L Subject: Script for most active tables

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 lo= ad
by moving hot tables into new tablespaces.

TIA
...JIM...
--

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

Author: James Howerton
=A0 INET: jhowerton_at_uabmc.edu

Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858) 538-= 5051
San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- 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).=A0 You may also send the HELP command for other information (like subscribing). Received on Wed Oct 25 2000 - 16:33:15 CDT