I would put it the other way around. If you need that information in tables
(which I agree is much better than in the report.txt file) edit the utlestat
and put the result in a table, or at least create a file in a loadable
format (series of inserts or file suitable for Sql*Loader), and not go to
report and than to table.
The best way though is to create your own utlbstat/utlestat type of script
and record the info that you are interested in, other than letting
utlbstat/utlestat decide what is interesting to you.
My 2 cents.
Djordje
-----Original Message-----
Sent: Wednesday, February 07, 2001 3:09 PM
To: Multiple recipients of list ORACLE-L
Hi,
Just curious if anyone has a script(s) that will take the contents of the
report.txt file and turn it into loadable files or something along those
lines. I know about 'statspack' but many companies are hesitant to permit
the creation of tables for storing statistics on their production
databases.
Thanks.
-wk
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).