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

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: Scripts to get "historical" tuning data

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

From: Guy Dallaire <gdallair_at_criq.qc.ca>
Date: 2000/05/17
Message-ID: <39229ce3.3109122@news.criq.qc.ca>#1/1

On Wed, 17 May 2000 05:50:11 GMT, Jerry Gitomer <jgitomer_at_erols.com> wrote:

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

Yeah, I know cron. But I want a script that can output tabular data that I can later plot.

I already have all the scripts, but they do NOT produce tabular data, that means that I have to rewrite a new script that collects ALL the neccessary info and output it in ONE LINE that would lokk somthing like:

Date                        Hit_Ratio    pfree_tbs_x  phy_rd_tbs_x
...
00-10-01 20:34:00  0.96             20.45            10231

Please don't tell me thos figures are insignificant, I know that. THIS IS ONLY AN EXAMPLE TO SHOW WHAT I NEED Many thanks Received on Wed May 17 2000 - 00:00:00 CDT

Original text of this message

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