Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: A Challenge
I do this adhoc reporting with top remotely/centrally using ssh
shared key files (no pw prompt on command line). I've never taken
the next step that you suggest of automating the page. I go look when
I'm looking for trouble. Seems like an easy tcl/perl/cron to review
and move the files around is in order.
If you have snmp based enterprise monitoring in place, it could/should be done there also. We use Smarts/InCharge for this, which is this side of wonderful.
> ssh stellr_at_nem top -b -d1 >> nem.la
Authorized use only. All activity may be monitored and reported.
> cat nem.la
load averages: 0.23, 0.37, 0.48 14:42:28
87 processes: 86 sleeping, 1 on cpu
Memory: 4096M real, 2070M free, 1411M swap in use, 5821M swap free
PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
3135 oracle 11 58 0 0K 0K sleep 60:45 7.72% oracle 14942 oracle 14 58 0 0K 0K sleep 184.3H 1.18% oracle 14950 oracle 1 58 0 0K 0K sleep 54.9H 0.57% oracle 9168 oracle 1 58 0 0K 0K sleep 52:54 0.40% oracle 8211 stellr 1 18 0 1776K 1144K cpu/0 0:00 0.24% top 3141 oracle 1 58 0 0K 0K sleep 61:15 0.20% oracle 8208 root 1 28 0 6816K 2936K sleep 0:00 0.17% sshd 3137 oracle 1 58 0 0K 0K sleep 62:14 0.16% oracle 7831 oracle 1 58 0 0K 0K sleep 55:40 0.13% oracle 3139 oracle 1 58 0 0K 0K sleep 63:09 0.13% oracle 14944 oracle 19 58 0 0K 0K sleep 21.9H 0.03% oracle 1358 root 14 11 0 7192K 6416K sleep 147:47 0.02% picld 3131 oracle 11 58 0 0K 0K sleep 9:15 0.02% oracle 8210 stellr 1 28 0 6816K 2176K sleep 0:00 0.02% sshd 14930 oracle 15 58 0 0K 0K sleep 399:58 0.02% oracle
On Mon, Nov 14, 2005 at 01:17:42PM -0600, Post, Ethan wrote:
> This is just for fun, I have a solution but wondering what others would
> do. I will post mine later.
>
> Task:
> Monitor load average on a unix host.
>
> Requirements:
> * Notify me via email when load exceeds 8 for more than 60 minutes.
> * After initial alert do not alert me again for at least 2 hours unless
> the load falls below 8 before the 2 hours expires.
> * Log the load to a file for historical purposes.
> * Alert me when the load falls back below 8.
>
> Challenge:
> Can you come up with a solution to this problem using existing
> scripts/utilities (home grown or otherwise)? Ideally lines/$$ required
> to implement the better. Just wondering what others might do.
>
>
-- -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 14 2005 - 14:00:41 CST
![]() |
![]() |