Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bstat/Estat File -> Table?

RE: Bstat/Estat File -> Table?

From: Djordje Jankovic <djankovic_at_corp.attcanada.ca>
Date: Wed, 07 Feb 2001 13:18:39 -0800
Message-ID: <F001.002AE3CE.20010207131055@fatcity.com>

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-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).
Received on Wed Feb 07 2001 - 15:18:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US