Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: Scripts to get "historical" tuning data
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
![]() |
![]() |