Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: A Challenge

Re: A Challenge

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Mon, 14 Nov 2005 14:58:23 -0500
Message-ID: <20051114195823.GA25720@locust.cns.vt.edu>


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-l
Received on Mon Nov 14 2005 - 14:00:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US