Re: HELP: Scripts to get "historical" tuning data

From: Andy Cowling <andy_at_redeye.com>
Date: 2000/05/17
Message-ID: <m28zx9obat.fsf@puma.redeye.com>#1/1

>>>>> "Guy" == Guy Dallaire <gdallair_at_criq.qc.ca> writes:

    Guy> Hi, I would like to know if anyone of you have any good
    Guy> script that can be used to output tuning data in a way that
    Guy> it can easily used to plot graphs with another tool (GNUPlot,
    Guy> excel, RDRTOOL, etc..)

For Oracle 8, Oracle have developed STATSPACK (replacement for BSTAT/ESTAT) which includes a script to automatically schedule data collection (which is stored database tables) using DBMS_JOB.

There's an excellent article in Oracle Magazine describing how to install and configure STATSPACK.

http://www.oracle.com/oramag/oracle/00-Mar/o20tun.html

HTH

-- 
Andy Cowling
Red Eye International
http://www.redeye.com/

Received on Wed May 17 2000 - 00:00:00 CDT