[Orca-users] Re:

[Blair Zajac]

Hi Stephen,

Stephen Kelly wrote:
> 
> Hi everyone,
> 
> I am currently working on using Orca as a performance monitoring tool for
> our Oracle databases around the nation. Currently, we do this via a daily
> email sent from each box giving us a snapshot of the system at the end of
> the day. During our End of Day processing the oracle databases are shutdown
> and restarted.
> 
> This means that a lot of the cumulative stats will be reset each day.
> 
> My problem is this. Most of the stats are going to be polled on a daily
> basis, to give us the same snapshot view we currently receive, but with the
> added benefit of a graph indicating trends etc.
> 
> Some of the other states may be polled on a 10 minute basis. Will orca
> handle in a sane manner inconsistent polling periods, or will resulting
> plots be out of alignment.
> 
> Should I have seperate data files for each polling period?

Regarding the different data sets with different polling periods, you'll
need to set up two different Orca configuration file 'groups' each with
its own specific 'interval'.

Orca can handle what you're trying to do, but there are some things to be
careful about, such as that RRD likes to have its measurements measured
as close to integer multiples of the interval.  So in your daily case,
you'll want to measure the data as close to 24 hours GMT time (not local
time).

You should have different data files for each polling period.

> 
> Another thing I am interested in doing is having a baseline for certain
> plots show up in the graphs. For example, the cache hit baseline might be
> 90%. Thus, If that could be a visual cue on the graph, it would be very
> useful. It would be easy to identify times when performance was poor etc
> without having to check the scale of the graph on the machine in question.
> Things would be consistent accross all the platforms in production,
> regardless of differing usage and hardware spec.
> 
> Your input on these issues would be greatly appreciated.
> 
> regards,
> 
> Steve Kelly
> 

Do you have any scripts you can share for measuring Oracle databases?

If you want baselines for your plots, you can add them by adding an
additional 'data' option to the plot:

plot {
data	some_measurement
data	0.90			# this is the baseline and will be plotted
}

Regards,
Blair Zajac


> ======================	====
> ##   Stephen Kelly
> ##   Technical Services Specialist
> ##   Beacon Technology
> ##   http://www.beacon.com.au
> ##   ph + 61 8 9486 8500 (x231)
> ##   steve at beacon.com.au
> ==========================
> 
> "It is a lesson history teaches wiser men,
>  to trust ideas and not circumstances."
>                         -- Emerson
> 
> -------------------------- eGroups Sponsor -------------------------~-~>
> Get free updates on your stocks from any phone with Tellme!
> Click here and you can even personalize these quotes.
> http://click.egroups.com/1/9536/12/_/576139/_/971168618/
> ---------------------------------------------------------------------_->