Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: Scripts to get "historical" tuning data
Modify your performance monitoring scripts. If you want to build a spread sheet have your scripts generate comma delimited output and then load it into your favorite spread sheet. You could also modify them so that their output gets inserted into Oracle tables. Depends on what you are most comfortable with.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 5/17/00, 8:26:37 AM, gdallair_at_criq.qc.ca (Guy Dallaire) wrote regarding 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 u
se
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 <<<<<<<<<<<<<<<<<<
> >
> 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 Thu May 18 2000 - 00:00:00 CDT
![]() |
![]() |