[Orca-users] Re: Oracle Stats

[Liston Bias]

On Fri, 23 Aug 2002, Adam Levin wrote:

> On Thu, 22 Aug 2002, markzander61 wrote:
> > We would like to start using Orca to monitor our Oracle instances.  I
> > have looked through the archives here and at orca-discuss and have
> > seen people asking how to do this, but haven't seen anything the
> > really tells how.
>
> Our database guy wrote a little shell script that writes out some DB
> metrics to a log file.  I then use that log file in a separate Orca group
> called oracle.  It contains stuff like user counts, requests, scans, file
> i/o, blocking locks, redo waits, fetches, etc.  It looks like it's a
> continuous counter, but I imagine that with a little script massaging and
> some state control, you could do the numbers as incremental rather than
> cumulative.
>
> Scripts are attached.
>
> The cron call is:
> ## ORCA Database Metrics every 5 minutes, 7x24
> 0,5,10,15,20,25,30,35,40,45,50,55 * * * * /opt/oracle/admin/OASIS/unix_scripts/db_metrics.sh

Can you also send following referenced in script?

  $SQL_SCRIPTS/db_metrics.sql
  $UNIX_SCRIPTS/change.sh

Thanks,
Liston