RE: Script for most active tables

Thanks all,

I'm still looking around for a script. Estat/bstat only gives tablespace = or datafile info i'm looking for
the same kind of info at the table level.

...JIM...
>>> Winnie_Liu_at_infonet.com 10/25/00 5:35:51 PM >>>

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=20

Sent by: root_at_fatcity.com=20

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=20
--
Author: James Howerton
  INET: jhowerton_at_uabmc.edu=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).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--
Author:
  INET: Winnie_Liu_at_infonet.com=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