What about $ORACLE_HOME/rdbms/admin/catio.sql ?
> ----------
> From: James Howerton[SMTP:jhowerton_at_uabmc.edu]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, October 26, 2000 22:01
> To: Multiple recipients of list ORACLE-L
> Subject: 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
>
> 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).
>
> --
> 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
Received on Fri Oct 27 2000 - 03:54:59 CDT
