[Orca-users]

[Stephen Kelly]

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?

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

==========================
##   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/
---------------------------------------------------------------------_->