I ran catio.sql how do I read the data it collects?
...JIM...
>>> ddorr.cs_at_clearstream.com 10/27/00 5:01:14 AM >>>
What about $ORACLE_HOME/rdbms/admin/catio.sql ?
> ----------
> From: James Howerton[SMTP:jhowerton_at_uabmc.edu]=20
> Reply To: ORACLE-L_at_fatcity.com=20
> Sent: Thursday, October 26, 2000 22:01
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Script for most active tables
>=20
> Thanks all,
>=20
> 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.
>=20
> ...JIM...
>=20
> >>> Winnie_Liu_at_infonet.com 10/25/00 5:35:51 PM >>>
>=20
>=20
> 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.
>=20
> Winnie
>=20
>=20
>=20
>=20
>=20
> "Koivu, Lisa" <lkoivu_at_qode.com>@fatcity.com on 10/25/2000 02:32:21 PM
>=20
> Please respond to ORACLE-L_at_fatcity.com=20
>=20
> Sent by: root_at_fatcity.com=20
>=20
>=20
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>=20
>=20
>=20
>=20
>=20
> Doesn't utlbstat/utlestat tell you what you need to know?
>=20
>=20
> -----Original Message-----
> Sent: Wednesday, October 25, 2000 3:52 PM
> To: Multiple recipients of list ORACLE-L
>=20
> 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.
>=20
> TIA
> ...JIM...
>=20
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --
> Author: James Howerton
> INET: jhowerton_at_uabmc.edu=20
>=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).
>=20
>=20
>=20
>=20
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --
> Author:
> INET: Winnie_Liu_at_infonet.com=20
>=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).
>=20
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
> --=20
> Author: James Howerton
> INET: jhowerton_at_uabmc.edu=20
>=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).
>=20
--=20
Please see the official ORACLE-L FAQ:
http://www.orafaq.com=20
--=20
Author:=20
INET: ddorr.cs_at_clearstream.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
Received on Fri Oct 27 2000 - 09:57:18 CDT
