Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bstat/Estat File -> Table?
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: djankovic_at_corp.attcanada.ca 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-LReceived on Wed Feb 07 2001 - 15:18:39 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).