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

        I kick my scripts off every night using Unix cron jobs (if you use NT look into the AT command). Works like a charm. Every night at 7:00 I run my monitoring scripts, at 8:00 I run my analyze scripts, and at 10:00 I run my archive purge.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/16/00, 3:20:43 PM, gdallair_at_criq.qc.ca (Guy Dallaire) wrote regarding HELP: Scripts to get "historical" tuning data:

> Hi,
 

> I would like to know if anyone of you have any good script that can be
 

> used to output tuning data in a way that it can easily used to plot
> graphs with another tool (GNUPlot, excel, RDRTOOL, etc..)
 

> I already have a whole toolkit of scripts that I run on a regular
> basic to check the health of my databases, but I lack scripts that
> collect data at regular time intervals so I can EASILY compare current
 

> figures with historical data.
 

> This would be useful to determine if the tuning effort was worth it,
> to do capacity planning, to cross reference wioth OS level historical
> data and so on.
 

> What I need are the "usual" statistics (I/O's, free space, waits, hit
> ratios, number of users, etc....)
 

> If anyone has a good script to do this, please point me in the right
> direction, I don't want to have to reinvent the wheel.
 

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